Do we have a list of excel functions which are implemented in Webix ?
Hey @robertwong68, are you talking about the general functionality these two apps share or are you talking about the compatibility with Excel files when using the spreadsheet widget?
Considering the first point, you can check out the full featured demo live at https://webix.com/demos/spreadsheet/ and see all the supported functions, alternatively, you can read more about the widget in the documentation.
If you’re talking about the file compatibility, the widget is fully compatible with any Excel file and should pose no problems while exporting/importing, unless it is some extreme off-case.
If you are talking about math - spreadsheet supports only subset of Excel methods. You can add a custom math methods though
https://docs.webix.com/api__ui.spreadsheet_registermathmethod.html
Math methods
SUM
AVERAGE
COUNT
COUNTA
COUNTBLANK
MAX
MIN
PRODUCT
SUMPRODUCT
SUMSQ
VARP
STDEVP
POWER
QUOTIENT
SQRT
ABS
RAND
PI
INT
ROUND
ROUNDDOWN
ROUNDUP
TRUNC
EVEN
ODD
CONCATENATE
LEFT
MID
RIGHT
LOWER
UPPER
PROPER
TRIM
LEN