summaryrefslogtreecommitdiff
path: root/calc.go
Commit message (Collapse)AuthorAge
* ref #65: new formula function WEEKNUMxuri2022-06-09
|
* Improves the calculation engine, docs update, and adds the dependabotxuri2022-05-26
| | | | | | - Initialize array formula support for the formula calculation engine - Update example and unit test of `AddPivotTable` - Update the supported hash algorithm of ProtectSheet
* This fix formula calculation accuracy issue and panic when set panexuri2022-05-23
| | | | | - Fix `GROWTH` and `TREND` calculation accuracy issue - Fix panic when add pane on empty sheet views worksheet - New exported constants `MinFontSize`
* This fixes a part of staticcheck issues and updates the code of conductxuri2022-05-18
| | | | Update example for set cell hyperlinks with `HyperlinkOpts`
* Optimization formula calculation performance and update README card badgexuri2022-04-24
|
* ref #65, new formula function: CONVERTxuri2022-04-20
|
* ref #65, initial formula functions: GROWTH and TRENDxuri2022-04-17
|
* ref #65, new formula functions: SKEW.P and SLOPE, remove no-required format ↵xuri2022-04-16
| | | | default
* ref #65, new formula functions: PEARSON and RSQxuri2022-04-15
|
* ref #65, new formula functions: MINVERSE and MMULTxuri2022-04-14
|
* ref #65, new formula functions: COVARIANCE.S and STDEVPAxuri2022-04-12
|
* This includes new formula functions support, dependencies upgrade, and bug fixxuri2022-04-11
| | | | | | | - Fix page setup fields parsing issue - Go Modules dependencies upgrade - Ref #65, CONFIDENCE.T and PHI - Ref #1198, Fix the issue that the chart axis maximum and minimum didn't work when the value is 0
* ref #65, new formula functions: MODE.MULT and MODE.SNGLxuri2022-04-07
|
* ref #65, #1196: fix the compatibility issue and added new formula functionxuri2022-04-06
| | | | - New formula functions: MODE and T.TEST
* This closes #1196, fix the compatibility issue and added new formula functionxuri2022-04-05
| | | | ref #65, new formula functions: TINV and TTEST
* ref #65, new formula functions: T.INV and T.INV.2Txuri2022-04-04
| | | | - Typo fixed
* ref #65, new formula functions: T.DIST.2T and T.DIST.RTxuri2022-04-03
| | | | - Update GitHub Action settings
* ref #65, new formula functions: T.DIST and TDISTxuri2022-04-02
|
* ref #65, new formula functions: NEGBINOM.DIST and NEGBINOMDISTxuri2022-04-01
|
* ref #65, new formula functions: CHISQ.INV and CHISQ.INV.RTxuri2022-03-31
|
* ref #65, new formula functions: HYPGEOM.DIST and HYPGEOMDISTxuri2022-03-30
|
* ref #65, new formula functions: F.TEST and FTESTxuri2022-03-29
|
* ref #65, new formula functions: CHISQ.DIST.RT CHISQ.DIST and GAMMALN.PRECISExuri2022-03-28
|
* ref #65, new formula functions: CHITEST and CHISQ.TESTxuri2022-03-27
|
* ref #65, new formula functions: F.DIST.RT and SERIESSUMxuri2022-03-26
|
* ref #65, new formula functions: F.DIST and FDISTxuri2022-03-25
|
* Format code, update documentation and remove exported variable `XMLHeaderByte`xuri2022-03-24
|
* ref #65, new formula functions: AVERAGEIFS and SUMPRODUCTxuri2022-03-23
|
* ref #65, new formula functions: CRITBINOM and SUMIFSxuri2022-03-22
|
* This closes #1185, fix formula function calculation result precision issue ↵xuri2022-03-21
| | | | | | | on arm64 * New formula functions: BINOM.DIST.RANGE and BINOM.INV * Fix complex number calculation result precision issue
* ref #65, #1185, new formula functions and precision improvementxuri2022-03-20
| | | | | * New formula functions: BETA.DIST, BINOMDIST and BINOM * Fix a part of formula function calculation result precision issue on arm64
* ref #65, new formula functions: CHIINV and BETADISTxuri2022-03-17
|
* ref #65, new formula functions: LOGNORM.DIST and LOGNORMDISTxuri2022-03-16
|
* ref #65, new formula functions: LOGNORM.INV and LOGINVxuri2022-03-15
| | | | * Update docs for the function `SetCellHyperLink`
* ref #65, new formula functions: GAMMA.INV and GAMMAINV and format codexuri2022-03-12
|
* ref #65, new formula functions: GAMMA.DIST and GAMMADISTxuri2022-03-11
|
* ref #65, new formula functions: F.INV and GAUSSxuri2022-03-10
|
* ref #65, new formula functions and read boolean data type cell value supportxuri2022-03-08
| | | | * added 3 new formula functions: BETAINV, BETA.INV, F.INV.RT
* This closes #1171, improve the compatibility and added new formula functionxuri2022-03-07
| | | | ref #65, added new formula function: FINV
* ref #65, new formula functions: CORREL, SUMX2MY2, SUMX2PY2, and SUMXMY2xuri2022-03-06
|
* This closes #1164, fix nested formula calculation result errorxuri2022-03-04
|
* ref #65, new formula functions: COVAR, COVARIANCE.P, EXPON.DIST and EXPONDISTxuri2022-03-02
|
* ref #65, new formula functions FORMULATEXT and TYPExuri2022-03-01
|
* 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
|
generated by cgit v1.2.1 (git 2.18.0) at 2025-04-26 14:39:36 +0000