Excelize

Fork

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

This closes #1777, fix the GetStyle or GetConditionalStyle function to returns incorrect DecimalPlaces field value

- Update documentation for the NewStyle function
- Update unit tests
- Update dependencies Go module
- Update GitHub workflow dependencies package version
- Update copyright agreement statement

This closes #1770, fix incorrect multiple conditional formats rules priorities

- Rename variable name hCell to topLeftCell, and rename vCell to bottomRightCell
- Update the unit tests

This closes #1769 and closes #1770, support multiple conditional formats rules

- Update the unit tests

This recover the Sizes field in the ChartSeries data type removed in commit dfaf418f340f260c5005e8343135cd6af60b8e58

- Update unit tests and documentation of the internal uintPtr function

This closes #1767, change struct field tabRatio date type to float64

Breaking changes: Go 1.18 and later required

- This made the GetPictureCell function support get embedded cell images
- Update dependencies module
- Update GitHub workflow
- Update documentation for the AddChart function

This closes #664, support get embedded cell images (#1759)

Co-authored-by: liying05 <liying05@zhidemai.com>

This closes # 1704, support set the data labels position for the chart (#1755)

- Breaking change: remove the Sizes field in the ChartSeries data type
- Add new field DataLabelPosition in the ChartSeries data type, support to sets the position of the chart series data label
- Add new field BubbleSize in the Chart data type, support set the bubble size in all data series for the bubble chart or 3D bubble chart
- Add new exported ChartDataLabelPositionType data type
- Update docs and unit test for the AddChart function
- Fix a v2.7.1 regression bug, the bubble is hidden in the bubble or 3D bubble chart, commit ID: c2d6707a850bdc7dbb32f68481b4b266b9cf7367

This closes #1749, fix incorrect adjust merged cells on remove rows (#1753)

Remove unused exported struct ShapeColor (#1746)

Signed-off-by: cui fliter <imcusg@gmail.com>

This closes #1745, prevent panic on get conditional format without above average rules

- Define internal map variable globally instead of inside of functions

This fix some function names in comment (#1747)

Signed-off-by: cui fliter <imcusg@gmail.com>