summaryrefslogtreecommitdiff
path: root/calc_test.go
Commit message (Collapse)AuthorAge
* This closes #858 (#859)jaby2021-06-08
| | | | | | | * fixes https://github.com/360EntSecGroup-Skylar/excelize/issues/858 * fixes https://github.com/360EntSecGroup-Skylar/excelize/issues/858 Co-authored-by: dvelderp <peter.de.velder@gmail.com>
* fixes #856 (#857)jaby2021-06-07
|
* This closes #652, new SetColWidth API, support set column width in stream ↵xuri2021-05-10
| | | | writing mode, and export error message
* #65 fn: BESSELK and BESSELYxuri2021-05-09
|
* #65 fn: IRR nad MIRRxuri2021-04-16
|
* #65 fn: FV, FVSCHEDULE, NPER, NPV and PDURATIONxuri2021-04-14
|
* #65 fn: DB, DDB, DOLLARDE, DOLLARFR, EFFECT, ISPMT and NOMINALxuri2021-04-13
|
* fixed the negative values series missing chart color, #65 fn: CUMIPMT and ↵xuri2021-04-11
| | | | CUMPRINC
* #65 fn: IPMT, PMT and PPMTxuri2021-04-09
|
* Fixed #819, read empty after streaming data writingxuri2021-04-08
| | | | #65 fn: IMAGINARY, IMARGUMENT, IMCONJUGATE and IMDIV
* #65 fn: IMLOG2, IMPOWER, IMPRODUCT, IMREAL, IMSEC, and IMSECHxuri2021-04-07
|
* #65 fn: IMSIN, IMSINH, IMSQRT, IMSUB, IMSUM, IMTANxuri2021-04-05
|
* Go 1.15 and later required, #65 fn: IMABS, IMCOS, IMCOSH, IMCOT, IMCSC, ↵xuri2021-04-04
| | | | IMCSCH, IMEXP, IMLN and IMLOG10
* Fixed #813, streaming data writer result missing after call normal APIxuri2021-04-03
| | | | #65 formula function: COMPLEX
* #65 fn: BESSELI and BESSELJxuri2021-04-02
|
* #65 fn: VAR.P and VARP and fix Yoda conditions issuexuri2021-04-01
|
* #65 fn: QUARTILE and QUARTILE.INCxuri2021-03-31
|
* #65 fn: N, PERCENTILE.INC and Txuri2021-03-30
| | | | typo fixed
* #65 fn: PERCENTILE and PERMUTATIONAxuri2021-03-27
|
* #65, new fn: POISSON.DIST, POISSON, SKEW, and STDEV.Sxuri2021-03-26
|
* This closes #809, and add new fn: HARMEANxuri2021-03-25
|
* #64 fn: NORM.DIST, NORMDIST, NORM.INV, NORMINV, NORM.S.DIST, NORMSDIST, ↵xuri2021-03-24
| | | | NORM.S.INV, and NORMSINV
* related issue #65 fn: FIXEDxuri2021-03-21
|
* #65 fn: DATEDIFxuri2021-03-19
|
* #65 fn: NOW and TODAY, and update dependenciesxuri2021-03-14
|
* #65 fn: LARGE, SMALL, SUBSTITUTE, refactor ARABICxuri2021-03-02
|
* This improves compatibility for absolute XML path, Windows-style directory ↵xuri2021-02-27
| | | | separator and inline namespace;
* 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
|
* 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
|
* Fix #724, standardize variable naming and update unit testsxuri2020-11-11
|
* 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
generated by cgit v1.2.1 (git 2.18.0) at 2025-04-19 14:13:43 +0000