Excelize

Fork

This closes #1448, speed up for checking merged cells (#1500)

Breaking changes: changed the function signature for 2 exported functions

- Change
`func (f *File) AddPictureFromBytes(sheet, cell, name, extension string, file []byte, opts *GraphicOptions) error`
to
`func (f *File) AddPictureFromBytes(sheet, cell string, pic *Picture) error`
- Change
`func (f *File) GetPicture(sheet, cell string) (string, []byte, error)`
to
`func (f *File) GetPictures(sheet, cell string) ([]Picture, error)`

Co-authored-by: huangsk <645636204@qq.com>

This closes #1499, support to set number format for chart data labels and axis

This update the return value for the `CalcCellValue` function (#1490)

- Using formula error string in the result of the `CalcCellValue` function
- Using the error message in the `CalcCellValue` function returns error
- Update unit tests

This closes #1492, fix data bar min/max value doesn't work

Breaking change: changed the third parameter for the `AddFilter`

- Support to add multiple filter columns
- Remove the exported type `AutoFilterListOptions`
- Support to specify if show header row of the table
- Update unit tests and documents of the function

This closes #1484, fix the formula calc result issue (#1485)

- Optimize variable name for data validation

Breaking changes: replace the type `ShapeParagraph` with `RichTextRun`

- This removes the `Color` field from the type `Shape`, and uses the `Fill` instead of it
- Remove sharp symbol from hex RGB color
- Update unit tests

This fixes #756, made stream writer skip set cell value when got nil (#1481)

This renamed conditional format type `iconSet` to `icon_set`

- Remove Minimum, Maximum, MinLength, and MaxLength fields from the type `ConditionalFormatOptions`
- Update unit tests and format code

Support double-byte chars for formula functions LENB, RIGHTB and MIDB (#1478)

This closes #1476, support double-byte chars for formula functions LEFT,RIGHT, LEN and MID (#1477)

Support specifies the values in second plot for the bar/pie of pie chart

- Upgrade dependencies package golang.org/x/image to 0.5.0
- Update unit tests

Update dependencies package golang.org/x/net from 0.5.0 to 0.7.0 (#1475)

This closes #1474, support set the format for the data series fill (solid fill)

- Breaking changes: remove the `Color` field in the `ChartLine` structure
- This support set the bubble size in a data series
- Unit test update and correct the docs of the function `GetSheetDimension`

This closes #1469, fix cell resolver caused incorrect calculation result (#1470)

This closes #1468, checks the table name, and added a new error constant `ErrTableNameLength`

- XML Structure field typo fixed
- Update documentation for the `AddChart` function
- Update unit test

This closes #1463, add new functions `SetSheetDimension` and `GetSheetDimension` (#1467)

Support creating a conditional format with an "icon sets" rule

- Improvement compatibility for the worksheet extension lists
- Update unit test

This closes #1462 and closes #1464

- Support creating a conditional format with a "stop if true" rule
- Support set border color and create solid color for the color data bar
- Fix incorrect cell type when modifying string cell with the time number
- Update unit test for the add pivot table to avoid pivot table range overlap

Add support for insert BMP format images

- Add support for workbook function groups
- Update code and docs for the build-in currency number format
- Update unit tests

This fixes #1461, supports 0 row height and column width

- Increase max cell styles to 65430
- Add new exported error variable `ErrCellStyles`
- Update unit tests, support test under Go 1.20.x

Support to create of 17 kinds of fill variants styles

- Update the unit tests
- Update the `SetHeaderFooter` function parameters name
- Update document for the `SetDocProps` and `SetCellHyperLink` functions

This fixes #1457, reduce string concatenation when applying number format (#1459)

Co-authored-by: Nathan Davies <ndavies@turnitin.com>

This fixes #1455, pre generate strings months name for number format (#1456)

- Reducing string concatenation and string conversion between rune string data types

Co-authored-by: Nathan Davies <ndavies@turnitin.com>

This roundup time value when a millisecond great than 500 to fix the accuracy issue

- Correction example in the documentation of set cell formula
- Rename the internal function `parseOptions` to `getOptions`
- Update unit tests

This closes #1447, add support for strict theme namespace

- Support specify if applying number format style for the cell calculation result
- Reduce cyclomatic complexities for the OpenReader function

Fix panic caused by the workbook relationship part not exist (#1443)

- Check nil map in the getSheetMap function
- Update unit tests

This fixes #1441, add copyright agreement statement on the LICENSE

This closes #1438, fix cell data type issue for formula calculation engine

- Update dependencies module
- Update unit tests