Excelize

Fork

Support unset custom row height if height value is -1 (#1736)

- Return error if get an invalid row height value
- Update unit tests and update documentation of the SetRowHeigth function

This closes #1732, saving workbook with sorted internal part path (#1735)

This closes #1729, support copy conditional format and data validation on duplicate row (#1733)

This support set column style with default width in sheet props settings (#1728)

Recalculate and use the same shared string count and unique count to overwrite incorrect existing values

Fixed invalid shared string table index on set cell value (#1725)

The GetCellRichText function support to return inline rich text (#1724)

Co-authored-by: jintian.wang <jintian.wang@mihoyo.com>

This closes #1723, fix panic on read workbook in some cases (#1692)

- Fix panic on read workbook with internal row element without r attribute
- Check worksheet XML before get all cell value by column or row
- Update the unit tests

Fix panic on GetPictureCells without drawing relationships parts (#1721)

This add new exported function GetHeaderFooter (#1720)

Support set time period type conditional formatting (#1718)

Support 5 new kinds of conditional formatting types

- New conditional formatting types: text, blanks, no blanks, errors, and no errors
- Support calculate formula with multiple dash arithmetic symbol
- Fix empty calculate result with numeric arguments in LEN, LOWER, PROPER, REPT, UPPER, and IF formula functions
- Uniform double quote in calculation unit tests
- Update unit tests

Support update data validations on inserting/deleting columns/rows

Support update conditional formatting on inserting/deleting columns/rows (#1717)

Return error for unsupported conditional formatting rule types

Update data validation type and operator's enumerations (#1714)

Support update defined names on inserting/deleting columns/rows

This closes #1712, reduce memory consumption (#1713)

This closes #1125, support update drawing objects on inserting/deleting columns/rows (#1127)

Fix number format scientific notation zero fill issues (#1710)

This closes #1706 and closes #1708

- Add export ChartLineType enumeration to specify the chart line type
- Add new Border field in the Chart type to set the chart area border
- Add new Type field in the ChartLine type to set the line type
- Fix some format missing on get style definition
- Update the unit tests

Support update volatile dependencies on inserting/deleting columns/rows

Support to adjust formula cross worksheet on inserting/deleting columns/rows (#1705)

This improves compatibility for adjusting tables and formula references on inserting/deleting columns or rows

Support adjust formula for entire cols/rows reference (#1702)

- Update the unit tests

This closes #1306 and closes #1615 (#1698)

- Support adjust formula on inserting/deleting columns/rows

This closes #1694, using namespace prefix in workbook theme XML

- Improve compatibility with the viewer which doesn't support default theme part namespace
- ref #1690, support read background color style, and conditional format with default pattern type
- Update the unit tests

This closes #1690, new exported function `GetConditionalStyle`

- Support get the conditional format style definition
- Update the unit test

This closes #1218 and closes #1689 (#1634)

- Introduce new exported function GetPictureCells
- Upgrade dependencies module golang.org/x/net from 0.16.0 to 0.17.0
- Update unit tests

Remove redundant `len` check in `GroupSheets` and `UngroupSheets` (#1685)

This closes #1687 and closes #1688

- Using sync map internally to get cell value concurrency safe
- Support set the height and width for the comment box
- Update the unit test