18c48d8291
ref #65 , new formula functions: CHISQ.INV and CHISQ.INV.RT
3 years ago
29d63f6ae0
ref #65 , new formula functions: HYPGEOM.DIST and HYPGEOMDIST
3 years ago
0030e800ca
ref #65 , new formula functions: F.TEST and FTEST
3 years ago
46336bc788
ref #65 , new formula functions: CHISQ.DIST.RT CHISQ.DIST and GAMMALN.PRECISE
3 years ago
f8d763d0bd
ref #65 , new formula functions: CHITEST and CHISQ.TEST
3 years ago
17141a9638
ref #65 , new formula functions: F.DIST.RT and SERIESSUM
3 years ago
4affeacc45
ref #65 , new formula functions: F.DIST and FDIST
3 years ago
8a335225c7
Format code, update documentation and remove exported variable `XMLHeaderByte`
3 years ago
139ee4c4b0
ref #65 , new formula functions: AVERAGEIFS and SUMPRODUCT
3 years ago
797958210d
ref #65 , new formula functions: CRITBINOM and SUMIFS
3 years ago
067c5d5643
This closes #1185 , fix formula function calculation result precision issue on arm64
...
* New formula functions: BINOM.DIST.RANGE and BINOM.INV
* Fix complex number calculation result precision issue
3 years ago
49424b0eb3
ref #65 , #1185 , new formula functions and precision improvement
...
* New formula functions: BETA.DIST, BINOMDIST and BINOM
* Fix a part of formula function calculation result precision issue on arm64
3 years ago
94f197c4fe
This improved formula calculate precision and added zero placeholder number format support
3 years ago
14b461420f
This fix scientific notation and page setup fields parsing issue
3 years ago
1da129a3df
ref #65 , new formula functions: CHIINV and BETADIST
3 years ago
c3424a9a0f
ref #65 , new formula functions: LOGNORM.DIST and LOGNORMDIST
3 years ago
4220bf4327
ref #65 , new formula functions: LOGNORM.INV and LOGINV
...
* Update docs for the function `SetCellHyperLink`
3 years ago
e1d660dda7
ref #65 , new formula functions: GAMMA.INV and GAMMAINV and format code
3 years ago
361611c23a
ref #65 , new formula functions: GAMMA.DIST and GAMMADIST
3 years ago
aee7bdd3a0
ref #65 , new formula functions: F.INV and GAUSS
3 years ago
74b1a998d6
This closes #1172 , support set hole size for doughnut ( #1173 )
3 years ago
56aa6b8263
ref #65 , new formula functions and read boolean data type cell value support
...
* added 3 new formula functions: BETAINV, BETA.INV, F.INV.RT
3 years ago
61eb265c29
This closes #1171 , improve the compatibility and added new formula function
...
ref #65 , added new formula function: FINV
3 years ago
354d1696d8
ref #65 , new formula functions: CORREL, SUMX2MY2, SUMX2PY2, and SUMXMY2
3 years ago
f0cb29cf66
This closes #1162 , improve the compatibility with alternate content
...
Preserve alternate content in the workbook, worksheet, and drawingML
3 years ago
129052ae7d
This closes #1164 , fix nested formula calculation result error
3 years ago
3971e8a48b
ref #65 , new formula functions: COVAR, COVARIANCE.P, EXPON.DIST and EXPONDIST
3 years ago
1efa283887
ref #65 , new formula functions FORMULATEXT and TYPE
3 years ago
42a9665aa9
ref #65 : formula function INDIRECT support and formula engine improvement
...
Support calculation with the none parameter formula function after infix operator notation
3 years ago
471c8f22d0
This closes #1160 , and added 4 new formula functions
...
* Fix show sheet tabs issue
* Ref #65 , new formula functions: ERROR.TYPE, HOUR, SECOND TIMEVALUE
3 years ago
92764195dc
This improvement number format support
...
* Local month name and AM/PM format support Tibetan and Traditional Mongolian
* Support text place holder
3 years ago
3231817169
This fixed code review issue in PR #1154 ( #1159 )
3 years ago
e84130e55c
Improvement local month name and AM/PM format support in number format
...
* Support for the Vietnamese, Wolof and Xhosa
3 years ago
8a6815fccc
Improvement local month name and AM/PM format support in number format
...
* Support for the Irish, Russian, Spanish, Thai, Turkish, Welsh, Yi, and Zulu
3 years ago
07be993631
Fixed parsing decimal precision issue
3 years ago
f87c39c41d
This closes #1148 , resolve limitations when adding VBA project to the workbook
...
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
3 years ago
ad09698515
Initialize local month name and AM/PM format support for number format
3 years ago
4b64b26c52
Ref: #660 , #764 , #1093 , #1112 , #1133 This improve number format support
...
- Introduced NFP (number format parser) dependencies module
- Initialize custom dates and times number format support
- Dependencies module upgraded
3 years ago
3f8f4f52e6
This closes #1139 , `SetCellDefault` support non-numeric value
...
- Add default value on getting `View` property of sheet views
- Add examples and unit test for set sheet views
- Re-order field on sheet view options
- Fix incorrect build-in number format: 42
- Simplify code for the `stylesReader` function
3 years ago
0f1fcb78d5
Support workbook views Showruler settings ( #1138 )
3 years ago
862dc9dc13
Support workbook views settings ( #1136 )
3 years ago
156bf6d16e
This closes #1129 , make cell support inheritance columns/rows style
...
Correct cells style in merge range
Fix incorrect style ID returned on getting cell style in some cases
Unit test updated and simplified code
3 years ago
3ee3c38f9c
Fix file corrupted in some cases, check file extension and format code
...
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`
3 years ago
74f6ea94ea
ref #1054 , breaking change for the column and row's iterator
...
This removed 3 exported functions: `TotalCols`, `CurrentCol` and `CurrentRow`
3 years ago
4daa6ed0b4
Breaking change: remove `TotalRows` of row iterator and performance optimization
...
Reduce allocation memory 20%, and 80% GC times for the row's iterator
3 years ago
50c4dedf8d
This closes #1122 , improve compatibility with LibreOffice
...
Fixed the issue auto filter doesn't work on LibreOffice if the sheet name has spaces
3 years ago
236ee61d20
This closes #1119 , style parsing issue fixed
3 years ago
67127883dd
Fix adjustMergeCells not modifies cell rect ( #1118 )
3 years ago
b96329cc88
Breaking change for data validation and fixed #1117
...
- Remove second useless parameter `isCurrentSheet` of the function `SetSqrefDropList`
- Fix missing page setup of worksheet after re-saving the spreadsheet
3 years ago
891e5baac1
ref #1096 , reduce memory usage by about 50% for large data spreadsheet
3 years ago
xuri