Excelize

Fork

Support format cell value with fraction number format code

- Fix delete incorrect image files when picture deleting pictures
- Update the unit test and dependencies modules

This closed #1680, fixing a potential issue that stream reader temporary files can not be clear

- Delete image files from the workbook internally when deleting pictures to reduce generated workbook size and resolve potential security issues

This closes #1681, closes #1683

- Fix incorrect formula calculation result
- Introduce new exported function `SetCellUint`
- Updates unit test
- Typo fixed

Keep all cells value in the table range when deleting table (#1684)

This fix #1682, removes table and content type parts when deleting the table

- Move worksheet-related functions in one place

This improves performance for adding and removing pivot table

Update actions/checkout from 3 to 4 (#1676)

Add new exported function `DeletePivotTable`

- Support adding pivot table by specific table name
- Update unit tests

This closes #1677, fix the incorrect custom number format ID allocated

- Improve compatibility with empty custom number format code

ref #65, formula functions TEXTAFTER and TEXTBEFORE (array formula not support yet)

This sorted exported error constants by name and listed them in one place

The `AddSlicer` function now support create pivot table slicer

This fix #1665, supports getting formula string cell value

- Improve compatibility for absolute path drawing part
- Fix incorrect table ID generated in the workbook which contains single table cells
- Fix missing relationship parts in the content types in some cases
- Upgrade number format parser to fix missing literal tokens in some cases
- Update built-in zh-cn and zh-tw language number format
- Ref #65, init new formula function: TEXT
- Remove duplicate style-related variables
- Update the unit tests

This closes #1661, fix incorrect time number format result

Introduce the new exported function `AddSlicer` for adding table slicer

- Fix a v2.8.0 regression bug, generate workbook corruption caused by incorrect MRU colors style parts
- Fix corrupted workbooks generated when adding tables in some cases
- Added several exported extension list child element URI constants
- Move part of the internal constant and variables definition to the template source code file
- Updated unit tests

This fixes #1658

- Fix a v2.8.0 regression bug, number format code apply result was empty
- Fix calculate formula functions CHITEST and MMULT panic in some cases
- Updated unit tests

This fixes #1645 and fixes #1655

- Breaking changes, change the data type for the `HeaderFooterOptions` structure fields `AlignWithMargins` and `ScaleWithDoc` as a pointer
- Fixed panic on `AutoFilter` by adding nil pointer guard for local sheet ID
- Allow dot character in the defined name, table name, or pivot table name
- Update the unit tests

Fix bug in checkDefinedNames

This fixes #1643, fixes #1647 and fixes #1653

- Correction cell type when formatting date type cell value
- Add check for MID and MIDB formula functions num_chars arguments, prevent panic on specifying a negative number
- Ref #65, add support for 2 formula functions: SEARCH and SEARCHB
- Fix a v2.8.0 regression bug, error on set print area and print titles with built-in special defined name
- Add new exported function `GetPivotTables` for get pivot tables
- Add a new `Name` field in the `PivotTableOptions` to support specify pivot table name
- Using relative cell reference in the pivot table docs and unit tests
- Support adding slicer content type part internally
- Add new exported source relationship and namespace `NameSpaceSpreadSheetXR10`, `ContentTypeSlicer`, `ContentTypeSlicerCache`, and `SourceRelationshipSlicer`
- Add new exported extended URI `ExtURIPivotCacheDefinition`
- Fix formula argument wildcard match issues
- Update GitHub Actions configuration, test on Go 1.21.x with 1.21.1 and later
- Avoid corrupted workbooks generated by improving compatibility with internally indexed color styles

add Footer & Header clarification to docs (#1644)

Update the README and documentation for the data validation functions

ref #65, add support for 10 formula functions

- Add support for 10 formula functions: ARRAYTOTEXT, FORECAST, FORECAST.LINEAR, FREQUENCY, INTERCEPT, ODDFYIELD, ODDLPRICE, ODDLYIELD, PROB and VALUETOTEXT
- Update unit tests

This closes #1628, fix the GetPictures function returns pictures doesn't correct in some cases

This closes #314, closes #1520 and closes #1521 (#1574)

- Add new function GetStyle support for get style definition

This closes #674, closes #1454, add new exported functions GetTables and DeleteTable (#1573)

This improves applying cell value with currency and accounting number format

- Update the unit test and dependencies modules

This fixed #1610, support to create a conditional format with number format and protection

This improves the date and time number formats

- Now support applying date and time number format for 812 language tags
- Fix panic on getting merged cells with the same start and end axis

This ref #1585, support to read one cell anchor pictures and improve date and time number format

- Support apply date and time number format with 16 languages: Persian, Polish, Portuguese, Punjabi, Quechua, Romanian, Romansh, Sakha, Sami, Sanskrit, Scottish Gaelic, Serbian, Sesotho sa Leboa, Setswana, Sindhi, Sinhala and Slovak
- Update the unit test and dependencies modules

This fixes #1599, and improve date and time number format

- Fix basic arithmetic operator priority issues
- Support apply date and time number format with 52 languages: Estonian, Faroese, Filipino, Finnish, Frisian, Fulah, Galician, Georgian, Greek, Greenlandic, Guarani, Gujarati, Hausa, Hawaiian, Hebrew, Hindi, Hungarian, Icelandic, Igbo, Indonesian, Inuktitut, Kannada, Kashmiri, Kazakh, Khmer, Kiche, Kinyarwanda, Kiswahili, Konkani, Kyrgyz, Lao, Latin, Latvian, Lithuanian, Luxembourgish, Macedonian, Malay, Malayalam, Maltese, Maori, Mapudungun, Marathi, Mohawk, Morocco, Nepali, Nigeria, Norwegian, Occitan, Odia, Oromo, Pashto and Syllabics
- Support apply the Chinese weekdays' number formats
- Update the unit test and dependencies modules