summaryrefslogtreecommitdiff
path: root/calc.go
Commit message (Collapse)AuthorAge
* Fix the error on getting the range of merged cells on the worksheet which ↵xuri2022-10-28
| | | | | | | | contains one cell merged cell range - Parse workbook default theme for custom theme color support in the feature - Variables name typo fix - Add system foreground and background color as RGB in the IndexedColorMapping list
* Support get cell value which contains a date in the ISO 8601 formatxuri2022-10-24
| | | | | | | | - Support set and get font color with indexed color - New export variable `IndexedColorMapping` - Fix getting incorrect page margin settings when the margin is 0 - Update unit tests and comments typo fixes - ref #65, new formula functions: AGGREGATE and SUBTOTAL
* Fix the formula calculation result issue of the OR function (#1374)gonghaibinx2022-10-21
| | | Co-authored-by: gonghaibin <gonghaibin@qq.com>
* Support to set summary columns to appear to the right of detail in an outlinexuri2022-10-08
| | | | | | - Simplify calculation engine code - Update documentation for the functions - Update dependencies module
* This closes #1360, closes #1361xuri2022-09-28
| | | | | | | - Fix default number format parse issue with a long string of digits - Fix creating a sheet with an empty name cause a corrupted file - The `GetCellStyle` function no longer return master cell style of the merge cell range - Using the specialized name in variables and functions
* Using the specialized name in a variable and making comments clearxuri2022-09-18
| | | | - Add JSON tags for `AppProperties`, `PivotTableOption` and `PivotTableField` structure
* This closes #1323, an error will be returned when set the not exist style IDxuri2022-09-01
|
* This closes #1319, fix calculate error for formula with negative symbolxuri2022-08-17
| | | - Update unit test and comment for the functions
* This closes #1244 and closes #1314, improving the compatibility with Google ↵xuri2022-08-13
| | | | | | Sheet - Format code with `gofmt`
* adjust `ErrColumnNumber`, rename `TotalColumns` to `MaxColumns` and add new ↵MJacred2022-07-14
| | | | | constant `MinColumns` (#1272) Signed-off-by: Benjamin Lösch <loesch.benny92@gmx.de>
* This closes #1262, support for dependence formulas calculationxuri2022-07-10
| | | | | - Add export option `MaxCalcIterations` for specifies the maximum iterations for iterative calculation - Update unit test for the database formula functions
* ref #65, new formula function: DGETxuri2022-07-03
|
* ref #65, new formula functions: DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, and DVARPxuri2022-07-02
|
* ref #65, new formula function: DAVERAGExuri2022-07-01
|
* ref #65, new formula functions: DMAX and DMINxuri2022-06-28
|
* This closes #1260, fixes compiling issue under 32-bit, and new formula functionsxuri2022-06-27
| | | | | | - ref #65, new formula functions: DCOUNT and DCOUNTA - support percentile symbol in condition criteria expression - this update dependencies module
* ref #65, new formula function: HYPERLINKxuri2022-06-24
|
* ref #65, new formula function: EUROCONVERTxuri2022-06-22
|
* ref #65, new formula function: STEYXxuri2022-06-20
|
* ref #65, new formula function: DAYS360xuri2022-06-17
|
* ref #65, new formula functions: NETWORKDAYS, NETWORKDAYS.INTL, and WORKDAYxuri2022-06-16
|
* Fix the problem of multi arguments calculation (#1253)ww15161232022-06-14
|
* ref #65: new formula function WORKDAY.INTLxuri2022-06-13
|
* refactor: replace strings.Replace with strings.ReplaceAll (#1250)Eng Zer Jun2022-06-12
| | | | | | | strings.ReplaceAll(s, old, new) is a wrapper function for strings.Replace(s, old, new, -1). But strings.ReplaceAll is more readable and removes the hardcoded -1. Signed-off-by: Eng Zer Jun <engzerjun@gmail.com>
* ref #65: new formula function EOMONTHxuri2022-06-11
|
* ref #65: new formula function EDATExuri2022-06-10
|
* 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
|
generated by cgit v1.2.1 (git 2.18.0) at 2025-04-16 00:28:30 +0000