summaryrefslogtreecommitdiff
path: root/calc.go
Commit message (Collapse)AuthorAge
* init new formula function: VLOOKUPxuri2021-02-04
|
* This closes #774, closes #775 and closes #776xuri2021-02-02
| | | | | | | | - correct adjust calculation chain in duplicate rows - correct adjust defined name in the workbook when delete worksheet - use absolute reference in the auto filters defined name to make it compatible with OpenOffice - API `CoordinatesToCellName` have a new optional param to specify if using an absolute reference format - Fix cyclomatic complexity issue of internal function `newFills` and `parseToken`
* update formula functions testxuri2021-02-01
|
* Fix hyperbolic cotangent calculation incorrect and unit testxuri2021-01-31
|
* Nested formula function support cell references as argumentsxuri2021-01-31
|
* refactor formula calculation framework, add new function CHOOSE, and update ↵xuri2021-01-30
| | | | dependencies module
* new formula fn: IF, LEN; not equal operator support and faster numeric ↵xuri2021-01-27
| | | | precision process
* This closes #752, fix incorrectly merged cells on duplicate row, and new ↵xuri2020-12-22
| | | | formula function: LOWER, PROPER, UPPER
* new formula func CLEAN and TRIM, change import path to v2 (#747)Zhang Zhipeng2020-12-14
|
* Fixed #727, rounding numeric with precision for formula calculationxuri2020-11-19
|
* New formula function AND (#701) and update doc for the NewSheet (#714)xuri2020-10-22
|
* Fix #701, init new formula function AND and OR, prevent formula lexer panic ↵xuri2020-10-17
| | | | on retrieving the top token type
* - Resolve #711, update docs for the GetSheetIndexxuri2020-10-12
| | | | - Update unit test
* test on Go 1.5 on Travis CI and update docs for the CalcCellValuexuri2020-08-14
|
* Fix issue 665 (#666)jaby2020-07-14
|
* fn: COUNTAxuri2020-06-04
|
* fn: MEDIAN, ISNUMBERxuri2020-06-02
|
* fn: ISBLANK, ISERR, ISERROR, ISEVEN, ISNA, ISNONTEXT, ISODD, NAxuri2020-05-31
|
* fn: SUMIFxuri2020-05-30
|
* - transform the range to the matrix on the first arg of the formulaxuri2020-05-21
| | | | | - typo fix - reset cell with and height when insert picture into merged cell with autofit
* updated test and go.modxuri2020-05-11
|
* - formula engine: reduce cyclomatic complexityxuri2020-05-10
| | | | - styles: allow empty and default cell formats, #628
* - fn: SUMSQxuri2020-05-09
| | | | | | - resolve ineffectual assignment - handle exception with invalid formula - update range resolver
* #65, fn: ROUND, ROUNDDOWN, ROUNDUP, SEC, SECH, SIN, SINH, SQRTPI, TAN, TANH, ↵xuri2020-05-08
| | | | TRUNC
* #65 fn: MOD, MROUND, MULTINOMIAL, MUNIT, ODD, PI, RADIANS, RAND, ↵xuri2020-05-07
| | | | RANDBETWEEN, ROMAN
* #65 fn: CSCH, DECIMAL, DEGREES, EVEN, EXP, FACT, FACTDOUBLE, FLOOR, ↵xuri2020-05-06
| | | | FLOOR.MATH, FLOOR.PRECISE, INT, ISO.CEILING, LN, LOG, LOG10, MDETERM
* #65 fn: CEILING.PRECISE, COMBIN, COMBINA, COS, COSH, COT, COTH, CSCxuri2020-05-05
|
* fn: CEILING, CEILING.MATHxuri2020-05-04
|
* fn: ACOS, ACOSH, ACOT, ACOTH, ARABIC, ASIN, ASINH, ATANH, ATAN2, BASExuri2020-05-04
|
* fn: ABS, GCD, LCM, POWER, PRODUCT, SIGN, SQRT, SUM, QUOTIENTxuri2020-05-04
|
* init formula calculation engine, ref #65 and #599xuri2020-05-03
generated by cgit v1.2.1 (git 2.18.0) at 2025-04-19 13:51:22 +0000