Excelize

Fork

This closes #1867, breaking changes: change the data type for the ConditionalFormatOptions structure field Format as a pointer

Support get the cell images inserted by IMAGE formula function

This closes #1865, unescape newline character in stream writer

- Update dependencies module

Support get rich data value rels index from rich value part (#1866)

Introduce new exported PictureInsertType enumeration (#1864)

Add support for get the Microsoft 365 cell images (#1857)

- Update unit tests

This closes #1861, fix missing parentheses in the adjusted formula

- Allow adjust cell reference with max rows/columns
- Fix incorrect data validation escape result
- Update out date reference link in the documentation
- Update unit tests

This closes #1851, and closes #1856 fix formula calculation result round issue (#1860)

- The SetSheetName function now support case sensitivity
- Update unit tests

This closes #1847, support apply number format with alignment (#1852)

- Update dependencies module
- Update unit tests

This fix performance impact introduced in #1692 (#1849)

Co-authored-by: chun.zhang2 <chun.zhang2@geely.com>

- This fix speed slowdown and memory usage increase base on the reverts commit 6220a798fd79231bf4b3d7ef587bb2b79d276710
- Fix panic on read workbook with internal row element without r attribute
- Update the unit tests

Typo fix for the comment of the extractStyleCondFuncs variable (#1846)

Signed-off-by: yetyear <flite@outlook.com>

This closes #1835, support get data validations which storage in the extension lists (#1834)

This closes #1830, closes #1831, and closes #1833

- Fix a v2.8.1 regression bug, auto filter does not work in the LibreOffice
- Fix a v2.8.1 regression bug, support to adjust data validation with multiple cell range
- Fix incorrect result data type of the DATE formula function
- Update the unit tests

Optimize getSharedFormula to avoid runtime.duffcopy (#1837)

This closes #1825, made AddDataValidation and DeleteDataValidation functions concurrency safe (#1828)

- Remove the receiver of internal coordinatesToRangeRef, squashSqref and flatSqref functions
- Update unit tests

Co-authored-by: chenwang <chenwang@shinsson.com>

This closes #1819, closes #1827, formula function ISNUMBER, OR and FIND support matrix arguments (#1829)

- Keep minimum column and row number in formula operand when deleting columns and rows
- Update unit tests

Clear slave cells value when merging cells (#1824)

This closes #1819, formula calculation engine support array formulas

- Improve the defined name and table name validation rules
- Rename internal variable names to avoid the same with Go 1.21's built-in min and max functions
- Simplify data type conversion in internal code
- Update GitHub Actions workflow configuration, test on Go 1.22.x, and disable Go module cache
- Update dependencies module

This closes #1820, converted styleFillVariants from slice to func (#1821)

This closes #1815, cell value reading functions inherit the Options settings of the OpenReader (#1816)

Co-authored-by: Vivek Kairi <vivek@zerodhafundhouse.com>

This closes #1807, calculation engine support date and formula type cell (#1810)

Co-authored-by: zhualong <274131322@qq.com>

This closes #1805, support set chart axis font family, size and strike style (#1809)

- Update unit test workflow dependencies package version

Fix CalcCellValue does not return raw value when enable RawCellValue (#1803)

This closes #1794, add new GetBaseColor function (#1798)

Co-authored-by: wangjingwei <wang.jingwei@joyratel.com>

This closes #1792, support to update defined names reference when rename worksheet (#1797)

ref #65, new formula function: DBCS (#1791)

Co-authored-by: wujierui <wujierui@jimabrand.com>

This closes #1789, delete VML shape on delete comment (#1790)

- Improve delete cell comment shape compatibility with KingSoft WPS
- Update unit test

This closes #1786, support set fill color of the chart (#1788)

- Add a new field Fill in Chart, ChartPlotArea, and ChartMarker struct
- Support set solid color or transparent fill for chart area, plot area, and maker

This closes #1783, support set conditional formatting with multiple cell ranges (#1787)

ref #65, support _xlfn.ANCHORARRAY formula function (#1784)

- Initial formula array calculation support
- Update unit test and documentation