Excelize

Fork

ref #65: new formula function EDATE

ref #65: new formula function WEEKNUM

This update docs and tests for workbook encryption

This initialized support for encryption workbook by password, ref #199

- Remove exported variable `ErrEncrypt`

This update dependencies module and GitHub Action settings

Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>

Improves the calculation engine, docs update, and adds the dependabot

- Initialize array formula support for the formula calculation engine
- Update example and unit test of `AddPivotTable`
- Update the supported hash algorithm of ProtectSheet

This fix formula calculation accuracy issue and panic when set pane

- Fix `GROWTH` and `TREND` calculation accuracy issue
- Fix panic when add pane on empty sheet views worksheet
- New exported constants `MinFontSize`

make workbook open filed exception message clear

- New exported constant `ErrWorkbookPassword`
- Rename exported constant `ErrWorkbookExt` to `ErrWorkbookFileFormat`

This fixes a part of staticcheck issues and updates the code of conduct

Update example for set cell hyperlinks with `HyperlinkOpts`

This closes #1229, rename ErrMaxFileNameLength to ErrMaxFilePathLength (#1230)

Co-authored-by: sceneq

This closed #1163, fix set cell value with column and row style inherit issue

This made library allowing insert WMF format image

This closes #1225, allowing insert EMF format images

This closes #1219, fixes cell value reading issue, improves performance, and 1904 date system support

- Fix incorrect cell data types casting results when number formatting
- Support set cell value on 1904 date system enabled, ref #1212
- Improve performance for set sheet row and the merging cells, fix performance impact when resolving #1129

This closes #1217, support update cell hyperlink

Ref #1129, make `SetRowStyle` overwrite style of the cells

This closes #1212, init support for 1900 or 1904 date system

This closes #1213, fix get incorrect rich text value caused by missing cell type checking

This closes #1211, improve the compatibility with invalid internal styles count

Optimization formula calculation performance and update README card badge

ref #65, new formula function: CONVERT

This closes #1203, supporting same field used for pivot table data and rows/cols

ref #65, initial formula functions: GROWTH and TREND

ref #65, new formula functions: SKEW.P and SLOPE, remove no-required format default

added macro functionality to shape (#1182)

ref #65, new formula functions: PEARSON and RSQ

ref #65, new formula functions: MINVERSE and MMULT

ref #65, new formula functions: COVARIANCE.S and STDEVPA

This includes new formula functions support, dependencies upgrade, and bug fix

- Fix page setup fields parsing issue
- Go Modules dependencies upgrade
- Ref #65, CONFIDENCE.T and PHI
- Ref #1198, Fix the issue that the chart axis maximum and minimum didn't work when the value is 0

ref #65, new formula functions: MODE.MULT and MODE.SNGL

ref #65, #1196: fix the compatibility issue and added new formula function

- New formula functions: MODE and T.TEST