api #564

New issue

Closed

opened 2026-03-03 16:39:00 +03:00 by kerem · 0 comments

kerem commented

2026-03-03 16:39:00 +03:00

Owner

📋 Pull Request Information

Original PR: https://github.com/NdoleStudio/httpsms/pull/553
Author: @dependabot[bot]
Created: 11/1/2024
Status: ✅ Merged
Merged: 11/1/2024
Merged by: @AchoArnold

Base: main ← Head: dependabot/go_modules/api/github.com/xuri/excelize/v2-2.9.0

📝 Commits (1)

ed33e85 fix(deps): bump github.com/xuri/excelize/v2 from 2.8.1 to 2.9.0 in /api

📊 Changes

2 files changed (+8 additions, -8 deletions)

View changed files

📝 api/go.mod (+2 -2)
📝 api/go.sum (+6 -6)

📄 Description

Bumps github.com/xuri/excelize/v2 from 2.8.1 to 2.9.0.

Release notes

Sourced from github.com/xuri/excelize/v2's releases.

v2.9.0

We are pleased to announce the release of version 2.9.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:

Breaking Change

Change the data type for the ConditionalFormatOptions structure field Format as a pointer, resolve issue #1867

Notable Features

Add new functions DeleteSlicer and GetSlicers, related issue #810

Add new function MoveSheet to support changing sheet order in the workbook, related issue #1076

Add new AutoFitIgnoreAspect field in the GraphicOptions data type support for fill the cell with the image and ignore its aspect ratio

Add new TickLabelPosition field in the ChartAxis data type support for set label position of the chart

Add new fields ShowAll, InsertBlankRow and NumFmt field in the PivotTableField data type

Add new fields ClassicLayout, FieldPrintTitles and ItemPrintTitles in the PivotTableOptions data type

Introduce 2 new exported enumeration type ChartTickLabelPositionType and PictureInsertType

Introduce new exported ChartLineUnset enumeration value

Introduce 4 constants ExtURIDataField, ExtURIPivotField, ExtURIPivotFilter and ExtURIPivotHierarchy

Introduce new exported error variable ErrPivotTableClassicLayout

The MergeCell function support clear slave cells value when merging cells

The AddDataValidation, DeleteDataValidation and GetCellStyle functions support concurrency safe, related issues #1825

The GetDataValidations function support get data validations which storage in the extension lists, related issue #1835

The SetSheetName function support case sensitivity, related issue #1856

The GetPictureCells and GetPictures functions support for get the cell images inserted by IMAGE formula function and absolute paths for pictures

The SetCellHyperLink function support remove hyperlink by None linkType, related issue #1940

The AddChart function support create combo chart with same types, related issue #1940

The AddChart function support set line type of scatter chart

An error will be return if column header cell is empty in pivot table data range when create pivot table by AddPivotTable function, related issue #1945

Add support for applying number format expression with language/location tags and ID

Add support for apply number format for time and duration cell value, related issue #2004

New support formula function: DOLLAR

Improve the Compatibility

Improve compatibility for apply number format, support apply number format with alignment, resolve issue #1847

Improvement compatibility for the workbook internal part with a spreadsheet namespace prefix, resolve issue #1886

Improve compatibility for the workbook internal media files with absolute path, resolve issue #1888

Bug Fixes

Fix a v2.8.1 regression bug, auto filter doesn't work in the LibreOffice, resolve issue #1830

Fix a v2.8.1 regression bug, support to adjust data validation with multiple cell range, resolve issue #1831

Fix a v2.8.1 regression bug, error on duplicate rows, if conditional formatting or data validation has multiple cell range reference

Fix a v2.8.1 regression bug, incorrect cell value written if save multiple times, resolve issue #1906

... (truncated)

Commits

f1d1a5d This closes #2004, support apply number format for time and duration cell value
b23e5a2 This closes #1076, add new function MoveSheet to support changing sheet order...
bebb802 This closes #1999, fix error on GetCellRichText function when read cell witho...
41c7dd3 This closes #1993, support to set and get pivot table classic layout
02189fb Ref #65, new formula function DOLLAR (#1992)
ad85417 This closes #1989, fix incorrect result of formula functions XIRR and XNPV
8c0ef7f This closes #1983, support create combo chart with same types
aca04ec This closes #1987, support absolute paths for pictures (#1988)
0447cb2 This close #1985, fix incorrect result of cell value after apply general numb...
29366fd Add new fields for pivot table options and pivot field options
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 show <dependency name> ignore conditions will show all of the ignore conditions of the specified dependency
@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)

_{🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.}

## 📋 Pull Request Information **Original PR:** https://github.com/NdoleStudio/httpsms/pull/553 **Author:** [@dependabot[bot]](https://github.com/apps/dependabot) **Created:** 11/1/2024 **Status:** ✅ Merged **Merged:** 11/1/2024 **Merged by:** [@AchoArnold](https://github.com/AchoArnold) **Base:** `main` ← **Head:** `dependabot/go_modules/api/github.com/xuri/excelize/v2-2.9.0` --- ### 📝 Commits (1) - [`ed33e85`](https://github.com/NdoleStudio/httpsms/commit/ed33e85d47363b9d68e93860dcc847ff32abfd7f) fix(deps): bump github.com/xuri/excelize/v2 from 2.8.1 to 2.9.0 in /api ### 📊 Changes **2 files changed** (+8 additions, -8 deletions) <details> <summary>View changed files</summary> 📝 `api/go.mod` (+2 -2) 📝 `api/go.sum` (+6 -6) </details> ### 📄 Description Bumps [github.com/xuri/excelize/v2](https://github.com/xuri/excelize) from 2.8.1 to 2.9.0. <details> <summary>Release notes</summary> <p><em>Sourced from <a href="https://github.com/xuri/excelize/releases">github.com/xuri/excelize/v2's releases</a>.</em></p> <blockquote> <h2>v2.9.0</h2> <p>We are pleased to announce the release of version 2.9.0. Featured are a handful of new areas of functionality and numerous bug fixes.</p> <p>A summary of changes is available in the <a href="https://github.com/xuri/excelize/releases/tag/v2.9.0">Release Notes</a>. A full list of changes is available in the <a href="https://github.com/xuri/excelize/compare/v2.8.1...v2.9.0">changelog</a>.</p> <h2>Release Notes</h2> <p>The most notable changes in this release are:</p> <h3>Breaking Change</h3> <ul> <li>Change the data type for the <code>ConditionalFormatOptions</code> structure field <code>Format</code> as a pointer, resolve issue <a href="https://redirect.github.com/xuri/excelize/issues/1867">#1867</a></li> </ul> <h3>Notable Features</h3> <ul> <li>Add new functions <code>DeleteSlicer</code> and <code>GetSlicers</code>, related issue <a href="https://redirect.github.com/xuri/excelize/issues/810">#810</a></li> <li>Add new function <code>MoveSheet</code> to support changing sheet order in the workbook, related issue <a href="https://redirect.github.com/xuri/excelize/issues/1076">#1076</a></li> <li>Add new <code>AutoFitIgnoreAspect</code> field in the <code>GraphicOptions</code> data type support for fill the cell with the image and ignore its aspect ratio</li> <li>Add new <code>TickLabelPosition</code> field in the <code>ChartAxis</code> data type support for set label position of the chart</li> <li>Add new fields <code>ShowAll</code>, <code>InsertBlankRow</code> and <code>NumFmt</code> field in the <code>PivotTableField</code> data type</li> <li>Add new fields <code>ClassicLayout</code>, <code>FieldPrintTitles</code> and <code>ItemPrintTitles</code> in the <code>PivotTableOptions</code> data type</li> <li>Introduce 2 new exported enumeration type <code>ChartTickLabelPositionType</code> and <code>PictureInsertType</code></li> <li>Introduce new exported <code>ChartLineUnset</code> enumeration value</li> <li>Introduce 4 constants <code>ExtURIDataField</code>, <code>ExtURIPivotField</code>, <code>ExtURIPivotFilter</code> and <code>ExtURIPivotHierarchy</code></li> <li>Introduce new exported error variable <code>ErrPivotTableClassicLayout</code></li> <li>The <code>MergeCell</code> function support clear slave cells value when merging cells</li> <li>The <code>AddDataValidation</code>, <code>DeleteDataValidation</code> and <code>GetCellStyle</code> functions support concurrency safe, related issues <a href="https://redirect.github.com/xuri/excelize/issues/1825">#1825</a></li> <li>The <code>GetDataValidations</code> function support get data validations which storage in the extension lists, related issue <a href="https://redirect.github.com/xuri/excelize/issues/1835">#1835</a></li> <li>The <code>SetSheetName</code> function support case sensitivity, related issue <a href="https://redirect.github.com/xuri/excelize/issues/1856">#1856</a></li> <li>The <code>GetPictureCells</code> and <code>GetPictures</code> functions support for get the cell images inserted by IMAGE formula function and absolute paths for pictures</li> <li>The <code>SetCellHyperLink</code> function support remove hyperlink by <code>None</code> linkType, related issue <a href="https://redirect.github.com/xuri/excelize/issues/1940">#1940</a></li> <li>The <code>AddChart</code> function support create combo chart with same types, related issue <a href="https://redirect.github.com/xuri/excelize/issues/1940">#1940</a></li> <li>The <code>AddChart</code> function support set line type of scatter chart</li> <li>An error will be return if column header cell is empty in pivot table data range when create pivot table by <code>AddPivotTable</code> function, related issue <a href="https://redirect.github.com/xuri/excelize/issues/1945">#1945</a></li> <li>Add support for applying number format expression with language/location tags and ID</li> <li>Add support for apply number format for time and duration cell value, related issue <a href="https://redirect.github.com/xuri/excelize/issues/2004">#2004</a></li> <li>New support formula function: DOLLAR</li> </ul> <h3>Improve the Compatibility</h3> <ul> <li>Improve compatibility for apply number format, support apply number format with alignment, resolve issue <a href="https://redirect.github.com/xuri/excelize/issues/1847">#1847</a></li> <li>Improvement compatibility for the workbook internal part with a spreadsheet namespace prefix, resolve issue <a href="https://redirect.github.com/xuri/excelize/issues/1886">#1886</a></li> <li>Improve compatibility for the workbook internal media files with absolute path, resolve issue <a href="https://redirect.github.com/xuri/excelize/issues/1888">#1888</a></li> </ul> <h3>Bug Fixes</h3> <ul> <li>Fix a v2.8.1 regression bug, auto filter doesn't work in the LibreOffice, resolve issue <a href="https://redirect.github.com/xuri/excelize/issues/1830">#1830</a></li> <li>Fix a v2.8.1 regression bug, support to adjust data validation with multiple cell range, resolve issue <a href="https://redirect.github.com/xuri/excelize/issues/1831">#1831</a></li> <li>Fix a v2.8.1 regression bug, error on duplicate rows, if conditional formatting or data validation has multiple cell range reference</li> <li>Fix a v2.8.1 regression bug, incorrect cell value written if save multiple times, resolve issue <a href="https://redirect.github.com/xuri/excelize/issues/1906">#1906</a></li> </ul>  </blockquote> <p>... (truncated)</p> </details> <details> <summary>Commits</summary> <ul> <li><a href="https://github.com/qax-os/excelize/commit/f1d1a5dc2b7f1e6a10a9275b2a6e392638457ee7"><code>f1d1a5d</code></a> This closes <a href="https://redirect.github.com/xuri/excelize/issues/2004">#2004</a>, support apply number format for time and duration cell value</li> <li><a href="https://github.com/qax-os/excelize/commit/b23e5a26df2a70102503fd73bf2f7ede38e189b8"><code>b23e5a2</code></a> This closes <a href="https://redirect.github.com/xuri/excelize/issues/1076">#1076</a>, add new function MoveSheet to support changing sheet order...</li> <li><a href="https://github.com/qax-os/excelize/commit/bebb8020699ee65bf39fa44380142f3a3d39bc5b"><code>bebb802</code></a> This closes <a href="https://redirect.github.com/xuri/excelize/issues/1999">#1999</a>, fix error on GetCellRichText function when read cell witho...</li> <li><a href="https://github.com/qax-os/excelize/commit/41c7dd30ce7efe4771624994918afa9cde6cbfd4"><code>41c7dd3</code></a> This closes <a href="https://redirect.github.com/xuri/excelize/issues/1993">#1993</a>, support to set and get pivot table classic layout</li> <li><a href="https://github.com/qax-os/excelize/commit/02189fb016fbc81328166b20ccca9e49922f0cef"><code>02189fb</code></a> Ref <a href="https://redirect.github.com/xuri/excelize/issues/65">#65</a>, new formula function DOLLAR (<a href="https://redirect.github.com/xuri/excelize/issues/1992">#1992</a>)</li> <li><a href="https://github.com/qax-os/excelize/commit/ad8541790df7d423803aca9851132639179ad8f2"><code>ad85417</code></a> This closes <a href="https://redirect.github.com/xuri/excelize/issues/1989">#1989</a>, fix incorrect result of formula functions XIRR and XNPV</li> <li><a href="https://github.com/qax-os/excelize/commit/8c0ef7f90dddf319770fef818caca445dfb642be"><code>8c0ef7f</code></a> This closes <a href="https://redirect.github.com/xuri/excelize/issues/1983">#1983</a>, support create combo chart with same types</li> <li><a href="https://github.com/qax-os/excelize/commit/aca04ecf57cd17efbb7d720e8508fa494c6b27aa"><code>aca04ec</code></a> This closes <a href="https://redirect.github.com/xuri/excelize/issues/1987">#1987</a>, support absolute paths for pictures (<a href="https://redirect.github.com/xuri/excelize/issues/1988">#1988</a>)</li> <li><a href="https://github.com/qax-os/excelize/commit/0447cb22c8e9a0fff4e76d4a499df65555a2de29"><code>0447cb2</code></a> This close <a href="https://redirect.github.com/xuri/excelize/issues/1985">#1985</a>, fix incorrect result of cell value after apply general numb...</li> <li><a href="https://github.com/qax-os/excelize/commit/29366fd126fe5c6df103c2392a59c3a16ebd5a69"><code>29366fd</code></a> Add new fields for pivot table options and pivot field options</li> <li>Additional commits viewable in <a href="https://github.com/xuri/excelize/compare/v2.8.1...v2.9.0">compare view</a></li> </ul> </details> <br /> [![Dependabot compatibility score](https://dependabot-badges.githubapp.com/badges/compatibility_score?dependency-name=github.com/xuri/excelize/v2&package-manager=go_modules&previous-version=2.8.1&new-version=2.9.0)](https://docs.github.com/en/github/managing-security-vulnerabilities/about-dependabot-security-updates#about-compatibility-scores) 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-automerge-start) [//]: # (dependabot-automerge-end) --- <details> <summary>Dependabot commands and options</summary> <br /> 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 show <dependency name> ignore conditions` will show all of the ignore conditions of the specified dependency - `@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) </details> --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>