api #399

New issue

Closed

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

kerem commented

2026-03-03 16:38:12 +03:00

Owner

📋 Pull Request Information

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

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

📝 Commits (1)

5499b4d fix(deps): bump github.com/xuri/excelize/v2 from 2.8.0 to 2.8.1 in /api

📊 Changes

2 files changed (+4 additions, -15 deletions)

View changed files

📝 api/go.mod (+1 -1)
📝 api/go.sum (+3 -14)

📄 Description

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

Release notes

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

v2.8.1

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

Upgrade requirements Go language version is 1.18 or later, for upgrade of dependency package golang.org/x/net

Change the data type for the HeaderFooterOptions structure fields AlignWithMargins and ScaleWithDoc as a pointer, resolve issue #1645

Remove unused exported data structure ShapeColor

Notable Features

Add new exported function SetCellUint, related issue #1681

Add new exported function GetPictureCells for get all picture cells, related issue #1218

Add new exported function GetConditionalStyle for get the conditional format style definition, related issue #1690

Add new exported function GetHeaderFooter for get the worksheet header and footer

Add new exported function AddSlicer for adding table and pivot table slicers

Add new exported function GetPivotTables for get pivot tables

Add new exported function DeletePivotTable for delete pivot table

Add a new Name field in the PivotTableOptions to support specify pivot table name

New support 7 formula functions: DBCS, SEARCH, SEARCHB, TEXT, TEXTAFTER, TEXTBEFORE and xlfn.ANCHORARRAY

Add export ChartLineType enumeration to specify the chart line type, related issue #1706

Add new Border field in the Chart data type to set the chart area border

Add new Type field in the ChartLine type to set the line type

Add new exported source relationship and namespace NameSpaceSpreadSheetXR10, ContentTypeSlicer, ContentTypeSlicerCache, and SourceRelationshipSlicer

Add new exported extended URI ExtURIPivotCacheDefinition

Allow dot character in the defined name, table name, or pivot table name

Keep all cells value in the table range when deleting table

Support format cell value with fraction number format code

Support delete image files from the workbook internally when deleting pictures to reduce generated workbook size and resolve potential security issues

Support set the height and width for the comment box, related issue #1688

Support update conditional formatting, data validations, defined names, drawing objects, formula reference and volatile dependencies on inserting/deleting columns/rows, related issues #1306 and #1615

Support 6 new kinds of conditional formatting types: text, blanks, no blanks, errors, no errors and time period

Support calculate formula with multiple dash arithmetic symbol

Support copy conditional format and data validation on duplicate row, related issue #1729

Support unset custom row height if the height value is -1 when using the SetRowHeight function

The SetRowHeight function will return an error if given an invalid row height value

The AddChart function support set the data labels position for the chart, related issue #1704

The AddChart function support set solid color or transparent fill for chart area, plot area, and maker, add a new field Fill in Chart, ChartPlotArea, and ChartMarker data type, related issue #1786

The AddChart function support set chart axis font family, size and strike style, related issue #1809

Add new field DataLabelPosition in the ChartSeries data type, support to sets the position of the chart series data label

Add new field BubbleSize in the Chart data type, support set the bubble size in all data series for the bubble chart or 3D bubble chart

Add new exported ChartDataLabelPositionType data type

The GetPictureCells and GetPictures function support get embedded cell images created by Kingsoft WPS™ Office, related issue #664

The SetConditionalFormat function support set conditional formatting with multiple cell ranges, related issue #1783

... (truncated)

Commits

688808b This closes #1819, formula calculation engine support array formulas
02b84a9 This closes #1820, converted styleFillVariants from slice to func (#1821)
ee2ef15 This closes #1815, cell value reading functions inherit the Options settings ...
9cbe3b6 This closes #1807, calculation engine support date and formula type cell (#1810)
bba155e This closes #1805, support set chart axis font family, size and strike style ...
a258e3d Fix CalcCellValue does not return raw value when enable RawCellValue (#1803)
99e91e1 This closes #1794, add new GetBaseColor function (#1798)
9a68553 This closes #1792, support to update defined names reference when rename work...
e4497c4 ref #65, new formula function: DBCS (#1791)
9b07898 This closes #1789, delete VML shape on delete comment (#1790)
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/376 **Author:** [@dependabot[bot]](https://github.com/apps/dependabot) **Created:** 3/1/2024 **Status:** ✅ Merged **Merged:** 3/1/2024 **Merged by:** [@AchoArnold](https://github.com/AchoArnold) **Base:** `main` ← **Head:** `dependabot/go_modules/api/github.com/xuri/excelize/v2-2.8.1` --- ### 📝 Commits (1) - [`5499b4d`](https://github.com/NdoleStudio/httpsms/commit/5499b4db1cb1d4f244212d4cfc264d7123702a17) fix(deps): bump github.com/xuri/excelize/v2 from 2.8.0 to 2.8.1 in /api ### 📊 Changes **2 files changed** (+4 additions, -15 deletions) <details> <summary>View changed files</summary> 📝 `api/go.mod` (+1 -1) 📝 `api/go.sum` (+3 -14) </details> ### 📄 Description Bumps [github.com/xuri/excelize/v2](https://github.com/xuri/excelize) from 2.8.0 to 2.8.1. <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.8.1</h2> <p>We are pleased to announce the release of version 2.8.1. 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.8.1">Release Notes</a>. A full list of changes is available in the <a href="https://github.com/xuri/excelize/compare/v2.8.0...v2.8.1">changelog</a>.</p> <h2>Release Notes</h2> <p>The most notable changes in this release are:</p> <h3>Breaking Change</h3> <ul> <li>Upgrade requirements Go language version is 1.18 or later, for upgrade of dependency package <code>golang.org/x/net</code></li> <li>Change the data type for the <code>HeaderFooterOptions</code> structure fields <code>AlignWithMargins</code> and <code>ScaleWithDoc</code> as a pointer, resolve issue <a href="https://redirect.github.com/xuri/excelize/issues/1645">#1645</a></li> <li>Remove unused exported data structure <code>ShapeColor</code></li> </ul> <h3>Notable Features</h3> <ul> <li>Add new exported function <code>SetCellUint</code>, related issue <a href="https://redirect.github.com/xuri/excelize/issues/1681">#1681</a></li> <li>Add new exported function <code>GetPictureCells</code> for get all picture cells, related issue <a href="https://redirect.github.com/xuri/excelize/issues/1218">#1218</a></li> <li>Add new exported function <code>GetConditionalStyle</code> for get the conditional format style definition, related issue <a href="https://redirect.github.com/xuri/excelize/issues/1690">#1690</a></li> <li>Add new exported function <code>GetHeaderFooter</code> for get the worksheet header and footer</li> <li>Add new exported function <code>AddSlicer</code> for adding table and pivot table slicers</li> <li>Add new exported function <code>GetPivotTables</code> for get pivot tables</li> <li>Add new exported function <code>DeletePivotTable</code> for delete pivot table</li> <li>Add a new <code>Name</code> field in the <code>PivotTableOptions</code> to support specify pivot table name</li> <li>New support 7 formula functions: DBCS, SEARCH, SEARCHB, TEXT, TEXTAFTER, TEXTBEFORE and xlfn.ANCHORARRAY</li> <li>Add export <code>ChartLineType</code> enumeration to specify the chart line type, related issue <a href="https://redirect.github.com/xuri/excelize/issues/1706">#1706</a></li> <li>Add new <code>Border</code> field in the <code>Chart</code> data type to set the chart area border</li> <li>Add new <code>Type</code> field in the <code>ChartLine</code> type to set the line type</li> <li>Add new exported source relationship and namespace <code>NameSpaceSpreadSheetXR10</code>, <code>ContentTypeSlicer</code>, <code>ContentTypeSlicerCache</code>, and <code>SourceRelationshipSlicer</code></li> <li>Add new exported extended URI <code>ExtURIPivotCacheDefinition</code></li> <li>Allow dot character in the defined name, table name, or pivot table name</li> <li>Keep all cells value in the table range when deleting table</li> <li>Support format cell value with fraction number format code</li> <li>Support delete image files from the workbook internally when deleting pictures to reduce generated workbook size and resolve potential security issues</li> <li>Support set the height and width for the comment box, related issue <a href="https://redirect.github.com/xuri/excelize/issues/1688">#1688</a></li> <li>Support update conditional formatting, data validations, defined names, drawing objects, formula reference and volatile dependencies on inserting/deleting columns/rows, related issues <a href="https://redirect.github.com/xuri/excelize/issues/1306">#1306</a> and <a href="https://redirect.github.com/xuri/excelize/issues/1615">#1615</a></li> <li>Support 6 new kinds of conditional formatting types: text, blanks, no blanks, errors, no errors and time period</li> <li>Support calculate formula with multiple dash arithmetic symbol</li> <li>Support copy conditional format and data validation on duplicate row, related issue <a href="https://redirect.github.com/xuri/excelize/issues/1729">#1729</a></li> <li>Support unset custom row height if the height value is -1 when using the <code>SetRowHeight</code> function</li> <li>The <code>SetRowHeight</code> function will return an error if given an invalid row height value</li> <li>The <code>AddChart</code> function support set the data labels position for the chart, related issue <a href="https://redirect.github.com/xuri/excelize/issues/1704">#1704</a></li> <li>The <code>AddChart</code> function support set solid color or transparent fill for chart area, plot area, and maker, add a new field <code>Fill</code> in <code>Chart</code>, <code>ChartPlotArea</code>, and <code>ChartMarker</code> data type, related issue <a href="https://redirect.github.com/xuri/excelize/issues/1786">#1786</a></li> <li>The <code>AddChart</code> function support set chart axis font family, size and strike style, related issue <a href="https://redirect.github.com/xuri/excelize/issues/1809">#1809</a></li> <li>Add new field <code>DataLabelPosition</code> in the <code>ChartSeries</code> data type, support to sets the position of the chart series data label</li> <li>Add new field <code>BubbleSize</code> in the <code>Chart</code> data type, support set the bubble size in all data series for the bubble chart or 3D bubble chart</li> <li>Add new exported <code>ChartDataLabelPositionType</code> data type</li> <li>The <code>GetPictureCells</code> and <code>GetPictures</code> function support get embedded cell images created by Kingsoft WPS™ Office, related issue <a href="https://redirect.github.com/xuri/excelize/issues/664">#664</a></li> <li>The <code>SetConditionalFormat</code> function support set conditional formatting with multiple cell ranges, related issue <a href="https://redirect.github.com/xuri/excelize/issues/1783">#1783</a></li> </ul>  </blockquote> <p>... (truncated)</p> </details> <details> <summary>Commits</summary> <ul> <li><a href="https://github.com/qax-os/excelize/commit/688808b2b4f7bb1f338991c810cd2ee6a7bb1451"><code>688808b</code></a> This closes <a href="https://redirect.github.com/xuri/excelize/issues/1819">#1819</a>, formula calculation engine support array formulas</li> <li><a href="https://github.com/qax-os/excelize/commit/02b84a906cb6adc54c0616080cc334a7af05d69d"><code>02b84a9</code></a> This closes <a href="https://redirect.github.com/xuri/excelize/issues/1820">#1820</a>, converted styleFillVariants from slice to func (<a href="https://redirect.github.com/xuri/excelize/issues/1821">#1821</a>)</li> <li><a href="https://github.com/qax-os/excelize/commit/ee2ef152d939c6a5bdd703167a58ba22a866f06b"><code>ee2ef15</code></a> This closes <a href="https://redirect.github.com/xuri/excelize/issues/1815">#1815</a>, cell value reading functions inherit the Options settings ...</li> <li><a href="https://github.com/qax-os/excelize/commit/9cbe3b6bd085a5b45ade85ba70ef578ab31a0b0f"><code>9cbe3b6</code></a> This closes <a href="https://redirect.github.com/xuri/excelize/issues/1807">#1807</a>, calculation engine support date and formula type cell (<a href="https://redirect.github.com/xuri/excelize/issues/1810">#1810</a>)</li> <li><a href="https://github.com/qax-os/excelize/commit/bba155e06da987f631278dba8c80545713b4a3b7"><code>bba155e</code></a> This closes <a href="https://redirect.github.com/xuri/excelize/issues/1805">#1805</a>, support set chart axis font family, size and strike style ...</li> <li><a href="https://github.com/qax-os/excelize/commit/a258e3d8580c5a4d16454bc4642d2a1704dd0ed9"><code>a258e3d</code></a> Fix CalcCellValue does not return raw value when enable RawCellValue (<a href="https://redirect.github.com/xuri/excelize/issues/1803">#1803</a>)</li> <li><a href="https://github.com/qax-os/excelize/commit/99e91e19efc562828af58fb9fde33b2e5d01f9a0"><code>99e91e1</code></a> This closes <a href="https://redirect.github.com/xuri/excelize/issues/1794">#1794</a>, add new GetBaseColor function (<a href="https://redirect.github.com/xuri/excelize/issues/1798">#1798</a>)</li> <li><a href="https://github.com/qax-os/excelize/commit/9a6855375e81067021ff0808f3b7a0c36d68afca"><code>9a68553</code></a> This closes <a href="https://redirect.github.com/xuri/excelize/issues/1792">#1792</a>, support to update defined names reference when rename work...</li> <li><a href="https://github.com/qax-os/excelize/commit/e4497c494d0150c9e5c4c58e948743dadbf219fb"><code>e4497c4</code></a> ref <a href="https://redirect.github.com/xuri/excelize/issues/65">#65</a>, new formula function: DBCS (<a href="https://redirect.github.com/xuri/excelize/issues/1791">#1791</a>)</li> <li><a href="https://github.com/qax-os/excelize/commit/9b078980df40dc6877f7057b113b3f999f57adee"><code>9b07898</code></a> This closes <a href="https://redirect.github.com/xuri/excelize/issues/1789">#1789</a>, delete VML shape on delete comment (<a href="https://redirect.github.com/xuri/excelize/issues/1790">#1790</a>)</li> <li>Additional commits viewable in <a href="https://github.com/xuri/excelize/compare/v2.8.0...v2.8.1">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.0&new-version=2.8.1)](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>