Excelize

Fork

This closes #660, supports currency string, and switches argument for the number format code

- Support round millisecond for the date time
- Update built-in number formats mapping
- Update unit tests
- Upgrade dependencies package

Ref #660, support placeholder, padding and rounds numbers by specified number format code

- Remove built-in number formats functions
- Update unit tests
- Upgrade dependencies package

Ref #1533, this made number format text handler just handle text tokens

- Fix race conditions for concurrency read and write shared string table
- Unit tests has been updated

This closes #1528, closes #1533

- Avoid format text cell value as a numeric
- Fix race conditions for concurrency safety functions

This optimizes internal functions signature and mutex declarations

Optimizing regexp calls to improve performance (#1532)

Breaking changes: rename exported variable `ErrTableNameLength` to `ErrNameLength`

- Check the defined name
- Improve the cell comment box shape size compatibility with KingSoft WPS
- Update unit test

This closes #1523, preventing format text cell value as a numeric

- Simplify variable declaration and error return statements
- Remove the internal `xlsxTabColor` data type
- Using the `xlsxColor` data type instead of `xlsxTabColor`
- Update unit test, improve code coverage

This commit contains 5 changes:

- Fix incorrect comment box size for multi-line plain text comments
- Prevent create duplicate tables with the same name
- Add new exported error variable `ErrExistsTableName`
- Allocate buffer inside escape XML characters
- Update the unit tests

This closes #1519, escape XML characters after checking cell value length

Support checking cell value length with multi-bytes characters (#1517)

Upgrade actions/setup-go from 3 to 4 (#1512)

This upgrade dependencies package

Require using ChartType enumeration value to specify the chart type

- Update docs and unit tests

This support get cell hyperlink for merged cells

This closes #1508, support SST index which contains blank characters

Breaking changes: changed the function signature for 4 exported functions

- Change
`func (f *File) AddVBAProject(bin string) error`
to
`func (f *File) AddVBAProject(file []byte) error`
- Change
`func (f *File) GetComments() (map[string][]Comment, error)`
to
`func (f *File) GetComments(sheet string) ([]Comment, error)`
- Change
`func (f *File) AddTable(sheet, rangeRef string, opts *TableOptions) error`
to
`func (f *File) AddTable(sheet string, table *Table) error`
- Change
`func (sw *StreamWriter) AddTable(rangeRef string, opts *TableOptions) error`
to
`func (sw *StreamWriter) AddTable(table *Table) error`
- Rename exported data type `TableOptions` to `Table`
- Simplify the assert statements in the unit tests
- Update documents for the functions
- Update unit tests

This closes #1503, case-insensitive for the file extension name

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)