Excelize

Fork

ref #65, new formula functions: DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, and DVARP

Fix CONTRIBUTING doc typo issues (#1266)

This closes #1264, fix can't modify cell content issue in some cases

Remove inline rich text when setting cell value and cell formulas

ref #65, new formula function: DAVERAGE

ref #65, new formula functions: DMAX and DMIN

This closes #1260, fixes compiling issue under 32-bit, and new formula functions

- ref #65, new formula functions: DCOUNT and DCOUNTA
- support percentile symbol in condition criteria expression
- this update dependencies module

ref #65, new formula function: HYPERLINK

ref #65, new formula function: EUROCONVERT

This closes #1257, fix incorrect worksheet header footer fields order

ref #65, new formula function: STEYX

ref #65, new formula function: DAYS360

ref #65, new formula functions: NETWORKDAYS, NETWORKDAYS.INTL, and WORKDAY

This closes #1254, `DeleteDataValidation` support delete all data validations in the worksheet

Fix the problem of multi arguments calculation (#1253)

RichTextRun support set superscript and subscript by vertAlign attribute (#1252)

check vertical align enumeration, update set rich text docs and test

ref #65: new formula function WORKDAY.INTL

refactor: replace strings.Replace with strings.ReplaceAll (#1250)

strings.ReplaceAll(s, old, new) is a wrapper function for
strings.Replace(s, old, new, -1). But strings.ReplaceAll is more
readable and removes the hardcoded -1.

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

ref #65: new formula function EOMONTH

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