summaryrefslogtreecommitdiff
path: root/calc.go
diff options
context:
space:
mode:
authorxuri <xuri.me@gmail.com>2020-08-14 10:19:27 +0000
committerxuri <xuri.me@gmail.com>2020-08-14 10:19:27 +0000
commit3cf3101fd99ad8901eac94ba4d15ad10cf3777a1 (patch)
treeca40bc99d9643ded716d193be0c41efbc4fa378f /calc.go
parent843bd24e56450791ad122a2f3875956a0a70ec6e (diff)
test on Go 1.5 on Travis CI and update docs for the CalcCellValue
Diffstat (limited to 'calc.go')
-rw-r--r--calc.go13
1 files changed, 13 insertions, 0 deletions
diff --git a/calc.go b/calc.go
index f86b12c..54683a8 100644
--- a/calc.go
+++ b/calc.go
@@ -96,6 +96,19 @@ type formulaFuncs struct{}
// CalcCellValue provides a function to get calculated cell value. This
// feature is currently in working processing. Array formula, table formula
// and some other formulas are not supported currently.
+//
+// Supported formulas:
+//
+// ABS, ACOS, ACOSH, ACOT, ACOTH, ARABIC, ASIN, ASINH, ATAN2, ATANH, BASE,
+// CEILING, CEILING.MATH, CEILING.PRECISE, COMBIN, COMBINA, COS, COSH, COT,
+// COTH, COUNTA, CSC, CSCH, DECIMAL, DEGREES, EVEN, EXP, FACT, FACTDOUBLE,
+// FLOOR, FLOOR.MATH, FLOOR.PRECISE, GCD, INT, ISBLANK, ISERR, ISERROR,
+// ISEVEN, ISNA, ISNONTEXT, ISNUMBER, ISO.CEILING, ISODD, LCM, LN, LOG,
+// LOG10, MDETERM, MEDIAN, MOD, MROUND, MULTINOMIAL, MUNIT, NA, ODD, PI,
+// POWER, PRODUCT, QUOTIENT, RADIANS, RAND, RANDBETWEEN, ROUND, ROUNDDOWN,
+// ROUNDUP, SEC, SECH, SIGN, SIN, SINH, SQRT, SQRTPI, SUM, SUMIF, SUMSQ,
+// TAN, TANH, TRUNC
+//
func (f *File) CalcCellValue(sheet, cell string) (result string, err error) {
var (
formula string