Bumps github.com/xuri/excelize/v2 from 2.5.0 to 2.6.0.
Release notes
Sourced from github.com/xuri/excelize/v2's releases.
v2.6.0
We are pleased to announce the release of version 2.6.0. Featured are a handful of new areas of functionality and numerous bug fixes.
A summary of changes is available in the Release Notes. A full list of changes is available in the changelog.
Release Notes
The most notable changes in this release are:
Compatibility
- Rename exported constants
NameSpaceDublinCoreMetadataIntiative
to NameSpaceDublinCoreMetadataInitiative
for typo fix
- Rename exported variable
ErrUnsupportEncryptMechanism
to ErrUnsupportedEncryptMechanism
- Rename exported variable
ErrDataValidationFormulaLenth
to ErrDataValidationFormulaLength
- Rename exported variable
ErrDefinedNameduplicate
to ErrDefinedNameDuplicate
- Remove exported variable
XMLHeaderByte
- Remove second useless parameter
isCurrentSheet
and error returns of the function SetSqrefDropList
- Remove
TotalRows
of row iterator
Notable Features
ProtectSheet
now support protect sheet with specify algorithm: XOR, MD4, MD5, SHA1, SHA256, SHA384, and SHA512
UnprotectSheet
now support specified the second optional password parameter to remove sheet protection with password verification
- New support 71 formula functions: AVERAGEIFS, BETADIST, BETA.DIST, BETAINV, BETA.INV, BINOMDIST, BINOM.DIST, BINOM.DIST.RANGE, BINOM.INV, CHIINV, CHITEST, CHISQ.DIST, CHISQ.DIST.RT, CHISQ.INV, CHISQ.INV.RT, CHISQ.TEST, CONFIDENCE.T, CORREL, COVAR, COVARIANCE.P, CRITBINOM, ERROR.TYPE, EXPON.DIST, EXPONDIST, F.DIST, F.DIST.RT, FDIST, F.INV, F.INV.RT, FINV, FORMULATEXT, F.TEST, FTEST, GAMMA.DIST, GAMMADIST, GAMMA.INV, GAMMAINV, GAMMALN.PRECISE, GAUSS, HOUR, HYPGEOM.DIST, HYPGEOMDIST, INDIRECT, LOGINV, LOGNORM.DIST, LOGNORMDIST, LOGNORM.INV, MODE, MODE.MULT, MODE.SNGL, NEGBINOM.DIST, NEGBINOMDIST, PHI, SECOND, SERIESSUM, SUMIFS, SUMPRODUCT, SUMX2MY2, SUMX2PY2, SUMXMY2, T.DIST, T.DIST.2T, T.DIST.RT, TDIST, TIMEVALUE, T.INV, T.INV.2T, TINV, T.TEST, TTEST, TYPE
- Check file extension on save the workbook
- Support workbook views mode and ruler display settings
- Improve number format support, introduced NFP (number format parser) dependencies module for custom dates and times number format and text place holder support, include local month name and AM/PM format in 19 languages (Afrikaans, Bangla, Chinese, English, French, German, Austria, Irish, Italian, Russian, Spanish, Thai, Tibetan, Turkish, Welsh, Wolof, Xhosa, Yi and Zulu) support for number format, related issues #660, #764, #1093, #1112, #1133
- New exported functions
SetWorkbookPrOptions
and GetWorkbookPrOptions
to support setting and getting the FilterPrivacy
and CodeName
properties of the workbook, resolve limitations when adding VBA project to the workbook, related issue #1148
- Formula engine now support calculation with the none parameter formula function after infix operator notation
- Support to read boolean data type cell value
- Support set hole size when create the doughnut chart by
AddChart
function, resolve issue #1172
- Export 4 errors
ErrPasswordLengthInvalid
, ErrUnsupportedHashAlgorithm
, ErrUnsupportedNumberFormat
, ErrWorkbookExt
so users can act differently on the different type of errors
Improve the Compatibility
- Improve compatibility with LibreOffice, fixed the issue auto filter doesn't work on LibreOffice if the sheet name has spaces, resolve issue #1122
- Improve the compatibility with alternate content, support preserve alternate content in the workbook, worksheet, and drawingML
- Improve the compatibility with page setup DPI fields
Bug Fixes
- Fix missing page setup of worksheet after re-saving the spreadsheet, resolve issue #1117
- Fix merged cells doesn't updated after opertaion in some cases
- Fix style parsing issue, which causes bold and other style missing, resolve issue #1119
- Fix file corrupted when save as in XLAM / XLSM / XLTM / XLTX extension in some case
- Correct cells style in merge range, make cell support inheritance columns/rows style, resolve issue #1129
- Fix incorrect style ID returned on getting cell style in some cases
- Fix incorrect build-in number format: 42
- Fixed parsing decimal precision issue in some case
SetCellDefault
support non-numeric value, resolve issue #1139
... (truncated)
Commits
c1940c2
This includes new formula functions support, dependencies upgrade, and bug fix
9b8f1a1
ref #65, new formula functions: MODE.MULT and MODE.SNGL
5bf4bce
ref #65, #1196: fix the compatibility issue and added new formula function
26174a2
This closes #1196, fix the compatibility issue and added new formula function
ecbc6e2
ref #65, new formula functions: T.INV and T.INV.2T
be8fc0a
ref #65, new formula functions: T.DIST.2T and T.DIST.RT
b834573
ref #65, new formula functions: T.DIST and TDIST
d9b5afc
ref #65, new formula functions: NEGBINOM.DIST and NEGBINOMDIST
18c48d8
ref #65, new formula functions: CHISQ.INV and CHISQ.INV.RT
29d63f6
ref #65, new formula functions: HYPGEOM.DIST and HYPGEOMDIST
- Additional commits viewable in compare view
Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase
.
Dependabot commands and options
You can trigger Dependabot actions by commenting on this PR:
@dependabot rebase
will rebase this PR
@dependabot recreate
will recreate this PR, overwriting any edits that have been made to it
@dependabot merge
will merge this PR after your CI passes on it
@dependabot squash and merge
will squash and merge this PR after your CI passes on it
@dependabot cancel merge
will cancel a previously requested merge and block automerging
@dependabot reopen
will reopen this PR if it is closed
@dependabot close
will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually
@dependabot ignore this major version
will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)
@dependabot ignore this minor version
will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)
@dependabot ignore this dependency
will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)