summaryrefslogtreecommitdiff
path: root/calc.go
Commit message (Collapse)AuthorAge
* ref #65: formula function INDIRECT support and formula engine improvementxuri2022-02-28
| | | | Support calculation with the none parameter formula function after infix operator notation
* This closes #1160, and added 4 new formula functionsxuri2022-02-26
| | | | | * Fix show sheet tabs issue * Ref #65, new formula functions: ERROR.TYPE, HOUR, SECOND TIMEVALUE
* This closes #1148, resolve limitations when adding VBA project to the workbookxuri2022-02-17
| | | | | | | | Added two exported functions `SetWorkbookPrOptions` and `GetWorkbookPrOptions` to support setting and getting the code name property of the workbook Re-order fields of the workbook properties group to improve the compatibility Go Modules dependencies upgrade Put workbook related operating in new `workbook.go` source code Library introduction docs block updated
* Fix file corrupted in some cases, check file extension and format codexuri2022-01-23
| | | | | | Fix file corrupted when save as in XLAM / XLSM / XLTM / XLTX extension in some case New exported error ErrWorkbookExt has been added, and check file extension on save the workbook Format source code with `gofumpt`
* Typo fix, rename exported constants, dependencies modules and copyright updatexuri2022-01-09
| | | | Rename exported constants `NameSpaceDublinCoreMetadataIntiative` to `NameSpaceDublinCoreMetadataInitiative`
* This closes #1095, support to set and get document application propertiesxuri2021-12-26
|
* This closes #1097, initialized formula function XLOOKUP and update testxuri2021-12-25
|
* ref #65, new formula functions MAXIFS and MINIFSxuri2021-12-19
|
* new formula function and update docs for formula functionsxuri2021-12-17
| | | | ref #65, new formula function: INDEX (array formula not support yet)
* ref #65: new formula function COUNTIFSxuri2021-12-14
|
* ref #65: new formula functions: AVERAGEIF and COUNTIFxuri2021-12-13
|
* ref #65: new formula function: SHEETS, and fix SHEET function count issuexuri2021-12-12
|
* This closes #1090 (#1092)jaby2021-12-10
| | | Keep track of operators per function
* ref #65: new formula functions: ISFORMULA, ISLOGICAL and ISREFxuri2021-12-09
|
* This closes #1088 (#1089)jaby2021-12-09
| | | Support check string equality with the string value of a defined name
* ref #65: new formula function ODDFPRICExuri2021-12-06
|
* Update docs for SetSheetStyle, and added 2 formula functionsxuri2021-12-04
| | | | | ref #65: new formula functions DURATION and MDURATION fix incorrect example in SetSheetStyle docs
* ref #65: new formula function YIELDxuri2021-11-29
|
* ref #65: new formula functions CONFIDENCE and CONFIDENCE.NORMxuri2021-11-25
|
* ref #65: new formula function VDBxuri2021-11-22
|
* ref #65: new formula function XIRRxuri2021-11-21
|
* ref #65: new formula function PRICExuri2021-11-17
| | | | | - fix COUPPCD result accuracy issue - update close spreadsheet example in documentation and README
* This closes #1061, support multi-byte language on set header footerxuri2021-11-16
| | | | typo fixed and simplify code for read the data values arguments of formula functions
* ref #65, new formula functions: COUPDAYBS, COUPDAYS and COUPDAYSNCxuri2021-11-15
|
* 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
|
generated by cgit v1.2.1 (git 2.18.0) at 2025-04-19 22:54:10 +0000