summaryrefslogtreecommitdiff
path: root/calc.go
Commit message (Collapse)AuthorAge
* handle default underline type on get rich text; #65 fn: CODE, COLUMN, FIND, ↵xuri2021-02-24
| | | | FINDB
* check empty rich text run properties; new formula fn: LEFT, LEFTB, RIGHT, RIGHTBxuri2021-02-23
|
* This closes #787, avoid duplicate rich text string items, new formula fn: ↵xuri2021-02-21
| | | | BIN2DEC, BIN2HEX, BIN2OCT, HEX2BIN, HEX2DEC, HEX2OCT, OCT2BIN, OCT2DEC, OCT2HEX
* ref: #756, set cell as blank when SetCellValue with nil #756, new formula ↵xuri2021-02-19
| | | | fn: BITAND, BITLSHIFT, BITOR, BITRSHIFT, BITXOR
* #65 fn: DEC2BIN, DEC2HEX, DEC2OCTxuri2021-02-18
|
* #65 fn: KURT, STDEV, STDEVAxuri2021-02-17
|
* This closes #785, support to change tab color; new formula function: FISHER, ↵xuri2021-02-16
| | | | FISHERINV, GAMMA, GAMMALN, MIN, MINA, PERMUT
* lint issue fixed and new formula function: ATAN, AVERAGE, AVERAGEA, CONCAT, ↵xuri2021-02-15
| | | | CONCATENATE, COUNT, COUNTBLANK, MAX
* add ten formula functions: ENCODEURL, EXACT, FALSE, IFERROR, ISTEXT, LENB, ↵xuri2021-02-14
| | | | NOT, REPT, SHEET, TRUE
* binary search in range lookup and new formula function: LOOKUPxuri2021-02-13
|
* init new formula function: HLOOKUPxuri2021-02-09
|
* 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:14 +0000