summaryrefslogtreecommitdiff
path: root/calc_test.go
Commit message (Collapse)AuthorAge
* ref #65: new formula functions TBILLPRICE and TBILLYIELDxuri2021-10-27
|
* ref #65: new formula functions TBILLEQ and TEXTJOINxuri2021-10-26
|
* ref #65: new formula functions YIELDDISC and YIELDMATxuri2021-10-24
|
* ref #65: new formula functions AVEDEV and CHIDISTxuri2021-10-23
|
* ref #65: new formula functions ADDRESS and PRICEDISCxuri2021-10-22
|
* ref #65: new formula functions DISC and INTRATExuri2021-10-21
|
* ref #65, new formula functions: RRI, SLN and SYDxuri2021-10-20
|
* ref #65: new formula functions IFNA and IFS and fix string compare result ↵xuri2021-10-19
| | | | issue in arithmetic operations
* ref #65: new formula function AMORLINCxuri2021-10-18
|
* ref #65: new formula functions ACCRINTM and AMORDEGRCxuri2021-10-17
|
* ref #65, new formula function: TIMExuri2021-10-16
|
* Update the test case of the formula function `MIRR`Tammy2021-10-15
|
* This closes #1031, fix small float parsed error in some casexuri2021-10-15
| | | | | | - new formula function: YEARFRAC, ref #65 - update the codecov version - remove unused variable
* initialize formula function TRANSPOSE, ref #65 and remove unused exported ↵xuri2021-10-01
| | | | error variable ErrToExcelTime
* new formula function: DAYS, ref #65xuri2021-09-24
|
* - new formula functions: DATEVALUE, ref #65xuri2021-09-17
| | | | | - fix ineffectual variable assignments - timeout in go test
* new formula functions: WEIBULL and WEIBULL.DIST, ref #65xuri2021-09-14
|
* new formula functions: Z.TEST and ZTEST, ref #65xuri2021-09-13
|
* This closes #993, closes #1014xuri2021-09-06
| | | | | | - Fix formula percentages calculated incorrectly - Make UpdateLinkedValue skip macro sheet - Fix conditional format bottom N not working
* This closes #998xuri2021-09-05
| | | | | | | - Support text comparison in the formula, also ref #65 - `GetCellValue`, `GetRows`, `GetCols`, `Rows` and `Cols` support to specify read cell with raw value, ref #621 - Add missing properties for the cell formula - Update the unit test for the `CalcCellValue`
* This closes #1008, added new formula functions MATCH and XOR, related issue #65xuri2021-08-29
|
* This closes #1006, new fn: MONTH ref #65Stani2021-08-21
| | | Co-authored-by: xuri <xuri.me@gmail.com>
* * This closes #1004, new fn: MONTH ref #65Stani2021-08-21
|
* This closes #997, fix LOOKUP function to find nearest match (#1001)Stani2021-08-21
|
* This closes #1002, new fn: DAY ref #65Stani2021-08-21
| | | | Co-authored-by: Stani Michiels <git@rchtct.com> Co-authored-by: xuri <xuri.me@gmail.com>
* This closes #994, fix LOOKUP function for Array formStani2021-08-19
|
* This closes #987: support nested calc for if formula (#988)bailantaotao2021-08-12
|
* 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
|