summaryrefslogtreecommitdiff
path: root/calc.go
Commit message (Collapse)AuthorAge
* ref #65: new formula function MINUTExuri2021-11-12
|
* ref #65: new formula function XNPVxuri2021-11-11
|
* ref #65: new formula functions PERCENTRANK.EXC, PERCENTRANK.INC and PERCENTRANKxuri2021-11-09
|
* ref #65: new formula functions COUPNCD and COUPNUMxuri2021-11-08
|
* ref #65: new formula functions COUPPCD and PRICEMATxuri2021-11-07
|
* ref #65: new formula functions PERCENTILE.EXC, QUARTILE.EXC and VAR.Sxuri2021-11-06
|
* ref #65: new formula functions VAR, VARA and VARPAxuri2021-11-05
|
* ref #65: new formula functions STANDARDIZE, STDEV.P and STDEVPxuri2021-11-04
|
* ref #65: new formula functions ERF, ERF.PRECISE, ERFC and ERFC.PRECISExuri2021-11-03
|
* ref #65: new formula functions DELTA and GESTEPxuri2021-11-02
|
* ref #65: new formula functions ACCRINT and ISOWEEKNUMxuri2021-11-01
|
* ref #65: new formula functions DEVSQ and GEOMEANxuri2021-10-31
|
* ref #65: new formula functions RATE and RECEIVED (#1045)Jerring2021-10-30
|
* ref #65: new formula functions PV, RANK and RANK.EQxuri2021-10-30
|
* ref #65: new formula functions VALUE and WEEKDAYxuri2021-10-29
|
* ref #65: new formula functions SWITCH and TRIMMEANxuri2021-10-28
|
* 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
|
* 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
* This closes #1026, time parse accuracy issue and typo fixedxuri2021-09-26
|
* 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 #417 and closes #520, new API `GetCellType` has been addedxuri2021-09-09
|
* This closes #262, support set line width of add the shapexuri2021-09-08
|
* 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
|
* Improve security and simplify codexuri2021-08-15
| | | | | | | - Make variable name more semantic - Reduce cyclomatic complexities for the formula calculate function - Support specified unzip size limit on open file options, avoid zip bombs vulnerability attack - Typo fix for documentation and error message
* Speed up merge cellsthree2021-08-13
|
* This closes #987: support nested calc for if formula (#988)bailantaotao2021-08-12
|
* Reduce cyclomatic complexities for the formula calculate function and update ↵xuri2021-08-09
| | | | documentation for the API: `MergeCell` and `GetCellValue`
* Fix code security issuexuri2021-07-20
|
* Fix missing set each cell's styles when set columns stylexuri2021-07-08
|