Excelize

Fork

Support apply number format with the Japanese era years

This closes #1590, add the Japanese calendar number format support

- The `GetFormControl` now support to get text, rich-text and font format of the form controls
- Update the unit tests and the documentation

This closes #1588, closes #1591, breaking changes for the `AddChart` function

- Removed exported `ChartTitle` data type
- The `AddChart` function now supports formatting and setting rich text titles for the chart
- New exported function `GetFormControl` for getting form control
- Made case in-sensitive for internal worksheet XML path to improve compatibility
- Update the unit tests
- Update the documentation and internal comments on the codes

This closes #1587, fix incorrect date time format result

This closes #1584, fix graphic object counter issues

- Optimize number format parser
- Update documentation for the `AddFormControl` function
- Update unit tests
- Upgrade dependencies package

This closes #1582, fixes the formula calculation bug, and improves form controls

- Fix incorrect formula calculate results on a nested argument function which returns a numeric result
- Add a new exported error variable `ErrorFormControlValue`
- Rename exported enumeration `FormControlCheckbox` to `FormControlCheckBox`
- Rename exported enumeration `FormControlRadio` to `FormControlOptionButton`
- The `AddFormControl` function supports new 5 form controls: spin button, check box, group box, label, and scroll bar
- Update documentation for the `GraphicOptions` data type, `AddFormControl` and `NewStreamWriter` functions
- Update the unit tests

This closes #301, support delete and add radio button form control

- New exported function `DeleteFormControl` has been added
- Update unit tests
- Fix comments was missing after form control added
- Update pull request templates

This closes #1169, initialize add form controls supported (#1181)

- Breaking changes:
* Change
`func (f *File) AddShape(sheet, cell string, opts *Shape) error`
to
`func (f *File) AddShape(sheet string, opts *Shape) error`
* Rename the `Runs` field to `Paragraph` in the exported `Comment` data type
- Add new exported function `AddFormControl` support to add button and radio form controls
- Add check for shape type for the `AddShape` function, an error will be returned if no shape type is specified
- Updated functions documentation and the unit tests

This closes #1572

- Breaking changes: changed the data type for the `DecimalPlaces` to pointer of integer
- Fallback to default 2 zero placeholder for invalid decimal places
- Update unit tests

This closes #518, support creating chart with a secondary series axis

This closes #1569, formula function CONCAT, CONCATENATE support concatenation of multiple cell values

This closes #1565, support adjust formula when instering columns and rows (#1567)

This fixed #1564, apply all of its arguments that meet multiple criteria

Made unit tests compatibility with the next Go language version

- Fix documents issues for the `AddChart` function
- Update GitHub sponsor profile

This closes #1553, the `AddChart` function support set primary titles

- Update unit tests and documentation
- Lint issues fixed

This optimize the code, simplify unit test and drawing object position calculation (#1561)

Co-authored-by: xinyao.cheng <xinyao.cheng@zerone.com.cn>

This closes #1560, fix incorrect row number when get object position

New function `GetPanes` for get sheet panes and view selection (#1556)

- Breaking changes: rename exported type `PaneOptions` to `Selection`
- Update unit tests
- Upgrade dependencies package
- Add internal error variables
- Simplify variable declarations

Support apply built-in number format code 22 with custom short date pattern

This fixed incorrect formula calculation exception expected result

- Simplify and remove duplicate code for optimization
- Update documentation comments with typo fix
- Handle error return to save the workbook
- Add file path length limitation details in the error message

This closes #1548, support to get multiple images in one cell (#1549)

This fix date and time pattern validation issues (#1547)

This closes #1539, fix adjust table issue when after removing rows

This avoid unnecessary byte/string conversion (#1541)

Signed-off-by: Eng Zer Jun <engzerjun@gmail.com>

This closes #279, refs #1536, change the default point to pixels conversion factor

This closes #1536, support fallback to default column width in sheet format property

This fixed across worksheet reference issue for the formula calculation engine

This closes #1535, add documentation for the fields for style alignment

Ref #1199, this support applies partial built-in language number format code

- Remove the `Lang` field in the `Style` data type
- Rename field name `ShortDateFmtCode` to `ShortDatePattern` in the `Options` data type
- Rename field name `LongDateFmtCode` to `LongDatePattern` in the `Options` data type
- Rename field name `LongTimeFmtCode` to `LongTimePattern` in the `Options` data type
- Apply built-in language number format code number when creating a new style
- Checking and returning error if the date and time pattern was invalid
- Add new `Options` field `CultureInfo` and new exported data type `CultureName`
- Add new culture name types enumeration for country code
- Update unit tests
- Move built-in number format code and currency number format code definition source code
- Remove the built-in language number format code mapping with Unicode values
- Fix incorrect number formatted result for date and time with 12 hours at AM

This closes #1199, support apply number format by system date and time options

- Add new options `ShortDateFmtCode`, `LongDateFmtCode` and `LongTimeFmtCode`
- Update unit tests