Skip to content

Instantly share code, notes, and snippets.

@mkozhukh
Created November 5, 2021 07:40
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mkozhukh/b65a0d422454adc16dff384acfa59324 to your computer and use it in GitHub Desktop.
Save mkozhukh/b65a0d422454adc16dff384acfa59324 to your computer and use it in GitHub Desktop.
list of methods supported by Webix Spreadsheet 9.0
We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.
ABS
ACCRINT
ACOS
ACOSH
ACOT
ACOTH
ADD
AND
ARABIC
ASIN
ASINH
ATAN
ATAN2
ATANH
AVERAGE
BASE
CEILING
CHAR
CHOOSE
CLEAN
CODE
COMBIN
COMBINA
CONCATENATE
COS
COSH
COT
COTH
COUNT
COUNTA
COUNTBLANK
CSC
CSCH
DATE
DATEDIF
DATEVALUE
DAY
DAYS
DAYS360
DB
DDB
DECIMAL
DEGREES
DIVIDE
DOLLAR
DOLLARDE
DOLLARFR
EDATE
EFFECT
EOMONTH
EQ
EVEN
EXCAT
FACT
FACTDOUBLE
FALSE
FIND
FIXED
FLOOR
FV
FVSCHEDULE
GCD
GT
GTE
HOUR
IF
INT
IPMT
IRR
ISBINARY
ISBLANK
ISEVEN
ISNOTEXT
ISNUMBER
ISODD
ISOWEEKNUM
ISPMT
ISTEXT
JOIN
LEFT
LEN
LN
LOG
LOG10
LOWER
LT
LTE
MAX
MID
MIN
MINUS
MINUTE
MOD
MONTH
MROUND
MULTINOMIAL
MULTIPLY
N
NE
NETWORKDAYS
NETWORKDAYSINTL
NOMINAL
NOT
NOW
NPER
NPV
NUMBERVALUE
ODD
OR
PDURATION
PI
PMT
POW
POWER
PPMT
PRODUCT
PROPER
PV
QUOTIENT
RADIANS
RAND
RANDBETWEEN
REGEXEXTRACT
REGEXMATCH
REGEXREPLACE
REPT
RIGHT
ROMAN
ROUND
ROUNDDOWN
ROUNDUP
SEARCH
SEC
SECH
SECOND
SIN
SINH
SQRT
SQRTPI
STDEV
STDEVA
STDEVP
STDEVPA
SUBSTITUTE
SUBTOTAL
SUM
SUMPRODUCT
SUMSQ
SUMX2MY2
SUMX2PY2
SUMXMY2
T
TAN
TANH
TIME
TIMEVALUE
TRIM
TRUE
TRUNC
UPPER
VAR
VARA
VARP
VARPA
WEEKDAY
WEEKNUM
WORKDAY
WORKDAYINTL
YEAR
YEARFRAC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment