Excelize

Fork

This closes #1164, fix nested formula calculation result error

ref #65, new formula functions: COVAR, COVARIANCE.P, EXPON.DIST and EXPONDIST

ref #65, new formula functions FORMULATEXT and TYPE

ref #65: formula function INDIRECT support and formula engine improvement

Support calculation with the none parameter formula function after infix operator notation

This closes #1160, and added 4 new formula functions

* Fix show sheet tabs issue
* Ref #65, new formula functions: ERROR.TYPE, HOUR, SECOND TIMEVALUE

This improvement number format support

* Local month name and AM/PM format support Tibetan and Traditional Mongolian
* Support text place holder

This fixed code review issue in PR #1154 (#1159)

Improvement local month name and AM/PM format support in number format

* Support for the Vietnamese, Wolof and Xhosa

Improvement local month name and AM/PM format support in number format

* Support for the Irish, Russian, Spanish, Thai, Turkish, Welsh, Yi, and Zulu

Fixed parsing decimal precision issue

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

Initialize local month name and AM/PM format support for number format

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

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

Support workbook views Showruler settings (#1138)

Support workbook views settings (#1136)

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

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`

ref #1054, breaking change for the column and row's iterator

This removed 3 exported functions: `TotalCols`, `CurrentCol` and `CurrentRow`

Breaking change: remove `TotalRows` of row iterator and performance optimization

Reduce allocation memory 20%, and 80% GC times for the row's iterator

This closes #1122, improve compatibility with LibreOffice

Fixed the issue auto filter doesn't work on LibreOffice if the sheet name has spaces

This closes #1119, style parsing issue fixed

Fix adjustMergeCells not modifies cell rect (#1118)

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

ref #1096, reduce memory usage by about 50% for large data spreadsheet

Typo fix, rename exported constants, dependencies modules and copyright update

Rename exported constants `NameSpaceDublinCoreMetadataIntiative` to `NameSpaceDublinCoreMetadataInitiative`

feat: implement SHA-512 algorithm to ProtectSheet (#1115)

Update create style example, using a pointer of the structure instead of JSON

This closes #1107, stream writer will create a time number format for time type cells

Unit test coverage improved

Preserve horizontal tab character when set the cell value (#1108)