Commit message (Collapse) | Author | Age | |
---|---|---|---|
* | This closes #1377, stream writer writes inline string type for string cell value | xuri | 2022-10-25 |
| | | | | - Add `CellTypeFormula`, `CellTypeInlineString`, `CellTypeSharedString` and remove `CellTypeString` in `CellType` enumeration - Unit tests updated | ||
* | Support get cell value which contains a date in the ISO 8601 format | xuri | 2022-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) | gonghaibinx | 2022-10-21 |
| | | | Co-authored-by: gonghaibin <gonghaibin@qq.com> | ||
* | This closes #1360, closes #1361 | xuri | 2022-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 | ||
* | This closes #1330 update non existing sheet error messages (#1331) | davidborry | 2022-08-28 |
| | |||
* | This closes #1319, fix calculate error for formula with negative symbol | xuri | 2022-08-17 |
| | | | - Update unit test and comment for the functions | ||
* | This closes #1262, support for dependence formulas calculation | xuri | 2022-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: DGET | xuri | 2022-07-03 |
| | |||
* | ref #65, new formula functions: DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, and DVARP | xuri | 2022-07-02 |
| | |||
* | ref #65, new formula function: DAVERAGE | xuri | 2022-07-01 |
| | |||
* | ref #65, new formula functions: DMAX and DMIN | xuri | 2022-06-28 |
| | |||
* | This closes #1260, fixes compiling issue under 32-bit, and new formula functions | xuri | 2022-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: HYPERLINK | xuri | 2022-06-24 |
| | |||
* | ref #65, new formula function: EUROCONVERT | xuri | 2022-06-22 |
| | |||
* | ref #65, new formula function: STEYX | xuri | 2022-06-20 |
| | |||
* | ref #65, new formula function: DAYS360 | xuri | 2022-06-17 |
| | |||
* | ref #65, new formula functions: NETWORKDAYS, NETWORKDAYS.INTL, and WORKDAY | xuri | 2022-06-16 |
| | |||
* | Fix the problem of multi arguments calculation (#1253) | ww1516123 | 2022-06-14 |
| | |||
* | ref #65: new formula function WORKDAY.INTL | xuri | 2022-06-13 |
| | |||
* | ref #65: new formula function EOMONTH | xuri | 2022-06-11 |
| | |||
* | ref #65: new formula function EDATE | xuri | 2022-06-10 |
| | |||
* | ref #65: new formula function WEEKNUM | xuri | 2022-06-09 |
| | |||
* | Improves the calculation engine, docs update, and adds the dependabot | xuri | 2022-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 pane | xuri | 2022-05-23 |
| | | | | | - Fix `GROWTH` and `TREND` calculation accuracy issue - Fix panic when add pane on empty sheet views worksheet - New exported constants `MinFontSize` | ||
* | Optimization formula calculation performance and update README card badge | xuri | 2022-04-24 |
| | |||
* | ref #65, new formula function: CONVERT | xuri | 2022-04-20 |
| | |||
* | ref #65, initial formula functions: GROWTH and TREND | xuri | 2022-04-17 |
| | |||
* | ref #65, new formula functions: SKEW.P and SLOPE, remove no-required format ↵ | xuri | 2022-04-16 |
| | | | | default | ||
* | ref #65, new formula functions: PEARSON and RSQ | xuri | 2022-04-15 |
| | |||
* | ref #65, new formula functions: MINVERSE and MMULT | xuri | 2022-04-14 |
| | |||
* | ref #65, new formula functions: COVARIANCE.S and STDEVPA | xuri | 2022-04-12 |
| | |||
* | This includes new formula functions support, dependencies upgrade, and bug fix | xuri | 2022-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.SNGL | xuri | 2022-04-07 |
| | |||
* | ref #65, #1196: fix the compatibility issue and added new formula function | xuri | 2022-04-06 |
| | | | | - New formula functions: MODE and T.TEST | ||
* | This closes #1196, fix the compatibility issue and added new formula function | xuri | 2022-04-05 |
| | | | | ref #65, new formula functions: TINV and TTEST | ||
* | ref #65, new formula functions: T.INV and T.INV.2T | xuri | 2022-04-04 |
| | | | | - Typo fixed | ||
* | ref #65, new formula functions: T.DIST.2T and T.DIST.RT | xuri | 2022-04-03 |
| | | | | - Update GitHub Action settings | ||
* | ref #65, new formula functions: T.DIST and TDIST | xuri | 2022-04-02 |
| | |||
* | ref #65, new formula functions: NEGBINOM.DIST and NEGBINOMDIST | xuri | 2022-04-01 |
| | |||
* | ref #65, new formula functions: CHISQ.INV and CHISQ.INV.RT | xuri | 2022-03-31 |
| | |||
* | ref #65, new formula functions: HYPGEOM.DIST and HYPGEOMDIST | xuri | 2022-03-30 |
| | |||
* | ref #65, new formula functions: F.TEST and FTEST | xuri | 2022-03-29 |
| | |||
* | ref #65, new formula functions: CHISQ.DIST.RT CHISQ.DIST and GAMMALN.PRECISE | xuri | 2022-03-28 |
| | |||
* | ref #65, new formula functions: CHITEST and CHISQ.TEST | xuri | 2022-03-27 |
| | |||
* | ref #65, new formula functions: F.DIST.RT and SERIESSUM | xuri | 2022-03-26 |
| | |||
* | ref #65, new formula functions: F.DIST and FDIST | xuri | 2022-03-25 |
| | |||
* | Format code, update documentation and remove exported variable `XMLHeaderByte` | xuri | 2022-03-24 |
| | |||
* | ref #65, new formula functions: AVERAGEIFS and SUMPRODUCT | xuri | 2022-03-23 |
| | |||
* | ref #65, new formula functions: CRITBINOM and SUMIFS | xuri | 2022-03-22 |
| | |||
* | This closes #1185, fix formula function calculation result precision issue ↵ | xuri | 2022-03-21 |
| | | | | | | | on arm64 * New formula functions: BINOM.DIST.RANGE and BINOM.INV * Fix complex number calculation result precision issue |