api #692

New issue

Closed

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

kerem commented

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

Owner

📋 Pull Request Information

Original PR: https://github.com/NdoleStudio/httpsms/pull/687
Author: @dependabot[bot]
Created: 6/1/2025
Status: ✅ Merged
Merged: 6/2/2025
Merged by: @AchoArnold

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

📝 Commits (1)

6ecbb30 fix(deps): bump github.com/xuri/excelize/v2 from 2.9.0 to 2.9.1 in /api

📊 Changes

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

View changed files

📝 api/go.mod (+9 -9)
📝 api/go.sum (+20 -20)

📄 Description

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

Release notes

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

v2.9.1

We are pleased to announce the release of version 2.9.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.23 or later, for upgrade of dependency package golang.org/x/crypto

Change the data type of DataValidationType, DataValidationErrorStyle, DataValidationOperator, PictureInsertType from int to byte

SetCellInt function required int64 data type parameter, resolve issue #2068

When adding drawing objects such as pictures, charts, shapes, and form controls, the offset setting will no longer affect the size of the drawing object, related issue #2001

Notable Features

Add new fields GapWidth and Overlap in the Chart data type

Add new fields ShowDataTable and ShowDataTableKeys fields in the ChartPlotArea data type

Add new field Alignment in the ChartAxis data type

Add new field DataLabel in the ChartSeries data type

Add new field PageOrder for PageLayoutOptions data type

Add 2 new exported error variables: ErrPageSetupAdjustTo and ErrStreamSetColStyle

Add 2 new exported enumerations: HeaderFooterImagePositionType and IgnoredErrorsType

Add 2 new exported data types: CalcPropsOptions and HeaderFooterImageOptions

Add 2 new functions: SetCalcProps and GetCalcProps support setting and getting workbook calculation properties

Add new CultureNameJaJP, CultureNameKoKR and CultureNameZhTW enumeration values, support apply number format for the Japanese calendar years, the Korean Danki calendar and the Republic of China year, related issue #1885

Add new function AddHeaderFooterImage to support set graphics in a header and footer, related issue #1395

Add new function AddIgnoredErrors support to ignored error for a range of cells, related issue #2046

Add new function SetColStyle for streaming writer to support set columns style, related issue #2075

The AddChart and AddChartSheet function support set chart axis text direction and rotation, related issue #2025

The AddChart and AddChartSheet function support set gap width and overlap for column and bar chart, related issue #2033

The AddChart and AddChartSheet function support set the format of the chart series data label, related issue #2052

The AddChart and AddChartSheet function support set data table for chart, related issue #2117

The AddFormControl function support set cell link for check box, related issue #2113

The SetPageLayout function support set page order of page layout

The DeletePicture function support delete one cell anchor image, related issue #2059

An error will be return if the option value of the SetPageLayout function is invalid

Support adjust data validations cross multiple worksheets, related issue #2072

Support apply number format with hash and zero place holder, related issue #2058

Support apply number format with ? symbol

Support to insert one cell anchor drawing object when specified the positioning as "oneCell", related issue #2002

Bug Fixes

Fix a v2.9.0 regression bug, corrupted workbook generated by open the workbook generated by stream writer, resolve issue #2015

Fix redundant none type pattern fill generated, resolve issue #2014

Fix missing vertical and horizontal border styles in some case, resolve issue #2048

Fix conditional format's border styles missing in some case, resolve issue #2061

... (truncated)

Commits

4180c20 This closes #2130, remove shared formula in calculation chain when remove row
2c3d13f Using binary search instead of sequential search for cell (#2129)
094ff39 This related with #2123, made editAs attribute value empty for one cell ancho...
d230ecd This closes #2126, fix sheet name error in defined name after rename sheet (#...
8fdc26e This fixes #2001 and fixes #2002. Breaking changes: offsets no longer affect ...
efdfc52 This closes #2119, remove all temporary files on close workbook (#2120)
3ccbdaa Clean shared formula cell cache on remove formula and simplify adjust formula...
b9f2c9e This closes #1961, add shared formula cell cache for speedup calculation (#2118)
0f19d7f This closes #2117, support add data table for chart
55cf0d4 Improve cell read performance by optimizing XML parsing (#2116)
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/687 **Author:** [@dependabot[bot]](https://github.com/apps/dependabot) **Created:** 6/1/2025 **Status:** ✅ Merged **Merged:** 6/2/2025 **Merged by:** [@AchoArnold](https://github.com/AchoArnold) **Base:** `main` ← **Head:** `dependabot/go_modules/api/github.com/xuri/excelize/v2-2.9.1` --- ### 📝 Commits (1) - [`6ecbb30`](https://github.com/NdoleStudio/httpsms/commit/6ecbb30286f2343ec26891bfb7ffa28fa495c14a) fix(deps): bump github.com/xuri/excelize/v2 from 2.9.0 to 2.9.1 in /api ### 📊 Changes **2 files changed** (+29 additions, -29 deletions) <details> <summary>View changed files</summary> 📝 `api/go.mod` (+9 -9) 📝 `api/go.sum` (+20 -20) </details> ### 📄 Description Bumps [github.com/xuri/excelize/v2](https://github.com/xuri/excelize) from 2.9.0 to 2.9.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.9.1</h2> <p>We are pleased to announce the release of version 2.9.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.9.1">Release Notes</a>. A full list of changes is available in the <a href="https://github.com/xuri/excelize/compare/v2.9.0...v2.9.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.23 or later, for upgrade of dependency package <code>golang.org/x/crypto</code></li> <li>Change the data type of <code>DataValidationType</code>, <code>DataValidationErrorStyle</code>, <code>DataValidationOperator</code>, <code>PictureInsertType</code> from <code>int</code> to <code>byte</code></li> <li>SetCellInt function required <code>int64</code> data type parameter, resolve issue <a href="https://redirect.github.com/xuri/excelize/issues/2068">#2068</a></li> <li>When adding drawing objects such as pictures, charts, shapes, and form controls, the offset setting will no longer affect the size of the drawing object, related issue <a href="https://redirect.github.com/xuri/excelize/issues/2001">#2001</a></li> </ul> <h3>Notable Features</h3> <ul> <li>Add new fields <code>GapWidth</code> and <code>Overlap</code> in the <code>Chart</code> data type</li> <li>Add new fields <code>ShowDataTable</code> and <code>ShowDataTableKeys</code> fields in the <code>ChartPlotArea</code> data type</li> <li>Add new field <code>Alignment</code> in the <code>ChartAxis</code> data type</li> <li>Add new field <code>DataLabel</code> in the <code>ChartSeries</code> data type</li> <li>Add new field <code>PageOrder</code> for <code>PageLayoutOptions</code> data type</li> <li>Add 2 new exported error variables: <code>ErrPageSetupAdjustTo</code> and <code>ErrStreamSetColStyle</code></li> <li>Add 2 new exported enumerations: <code>HeaderFooterImagePositionType</code> and <code>IgnoredErrorsType</code></li> <li>Add 2 new exported data types: <code>CalcPropsOptions</code> and <code>HeaderFooterImageOptions</code></li> <li>Add 2 new functions: <code>SetCalcProps</code> and <code>GetCalcProps</code> support setting and getting workbook calculation properties</li> <li>Add new <code>CultureNameJaJP</code>, <code>CultureNameKoKR</code> and <code>CultureNameZhTW</code> enumeration values, support apply number format for the Japanese calendar years, the Korean Danki calendar and the Republic of China year, related issue <a href="https://redirect.github.com/xuri/excelize/issues/1885">#1885</a></li> <li>Add new function <code>AddHeaderFooterImage</code> to support set graphics in a header and footer, related issue <a href="https://redirect.github.com/xuri/excelize/issues/1395">#1395</a></li> <li>Add new function <code>AddIgnoredErrors</code> support to ignored error for a range of cells, related issue <a href="https://redirect.github.com/xuri/excelize/issues/2046">#2046</a></li> <li>Add new function <code>SetColStyle</code> for streaming writer to support set columns style, related issue <a href="https://redirect.github.com/xuri/excelize/issues/2075">#2075</a></li> <li>The <code>AddChart</code> and <code>AddChartSheet</code> function support set chart axis text direction and rotation, related issue <a href="https://redirect.github.com/xuri/excelize/issues/2025">#2025</a></li> <li>The <code>AddChart</code> and <code>AddChartSheet</code> function support set gap width and overlap for column and bar chart, related issue <a href="https://redirect.github.com/xuri/excelize/issues/2033">#2033</a></li> <li>The <code>AddChart</code> and <code>AddChartSheet</code> function support set the format of the chart series data label, related issue <a href="https://redirect.github.com/xuri/excelize/issues/2052">#2052</a></li> <li>The <code>AddChart</code> and <code>AddChartSheet</code> function support set data table for chart, related issue <a href="https://redirect.github.com/xuri/excelize/issues/2117">#2117</a></li> <li>The <code>AddFormControl</code> function support set cell link for check box, related issue <a href="https://redirect.github.com/xuri/excelize/issues/2113">#2113</a></li> <li>The <code>SetPageLayout</code> function support set page order of page layout</li> <li>The <code>DeletePicture</code> function support delete one cell anchor image, related issue <a href="https://redirect.github.com/xuri/excelize/issues/2059">#2059</a></li> <li>An error will be return if the option value of the <code>SetPageLayout</code> function is invalid</li> <li>Support adjust data validations cross multiple worksheets, related issue <a href="https://redirect.github.com/xuri/excelize/issues/2072">#2072</a></li> <li>Support apply number format with hash and zero place holder, related issue <a href="https://redirect.github.com/xuri/excelize/issues/2058">#2058</a></li> <li>Support apply number format with <code>?</code> symbol</li> <li>Support to insert one cell anchor drawing object when specified the positioning as "oneCell", related issue <a href="https://redirect.github.com/xuri/excelize/issues/2002">#2002</a></li> </ul> <h3>Bug Fixes</h3> <ul> <li>Fix a v2.9.0 regression bug, corrupted workbook generated by open the workbook generated by stream writer, resolve issue <a href="https://redirect.github.com/xuri/excelize/issues/2015">#2015</a></li> <li>Fix redundant none type pattern fill generated, resolve issue <a href="https://redirect.github.com/xuri/excelize/issues/2014">#2014</a></li> <li>Fix missing vertical and horizontal border styles in some case, resolve issue <a href="https://redirect.github.com/xuri/excelize/issues/2048">#2048</a></li> <li>Fix conditional format's border styles missing in some case, resolve issue <a href="https://redirect.github.com/xuri/excelize/issues/2061">#2061</a></li> </ul>  </blockquote> <p>... (truncated)</p> </details> <details> <summary>Commits</summary> <ul> <li><a href="https://github.com/qax-os/excelize/commit/4180c2082e5b79c4d7ac7e8877c9159ae9c9fad3"><code>4180c20</code></a> This closes <a href="https://redirect.github.com/xuri/excelize/issues/2130">#2130</a>, remove shared formula in calculation chain when remove row</li> <li><a href="https://github.com/qax-os/excelize/commit/2c3d13fe8b492892671798fa90a85de1a04dc796"><code>2c3d13f</code></a> Using binary search instead of sequential search for cell (<a href="https://redirect.github.com/xuri/excelize/issues/2129">#2129</a>)</li> <li><a href="https://github.com/qax-os/excelize/commit/094ff396fe73233056a3c87da554b80b4c9d9bb7"><code>094ff39</code></a> This related with <a href="https://redirect.github.com/xuri/excelize/issues/2123">#2123</a>, made editAs attribute value empty for one cell ancho...</li> <li><a href="https://github.com/qax-os/excelize/commit/d230ecdb48b77450baa5fe664f5681ef3ad38360"><code>d230ecd</code></a> This closes <a href="https://redirect.github.com/xuri/excelize/issues/2126">#2126</a>, fix sheet name error in defined name after rename sheet (#...</li> <li><a href="https://github.com/qax-os/excelize/commit/8fdc26e286734b808dcab1546760768b60045e67"><code>8fdc26e</code></a> This fixes <a href="https://redirect.github.com/xuri/excelize/issues/2001">#2001</a> and fixes <a href="https://redirect.github.com/xuri/excelize/issues/2002">#2002</a>. Breaking changes: offsets no longer affect ...</li> <li><a href="https://github.com/qax-os/excelize/commit/efdfc52252a3f9a840e47da0c8bd4017845eef7a"><code>efdfc52</code></a> This closes <a href="https://redirect.github.com/xuri/excelize/issues/2119">#2119</a>, remove all temporary files on close workbook (<a href="https://redirect.github.com/xuri/excelize/issues/2120">#2120</a>)</li> <li><a href="https://github.com/qax-os/excelize/commit/3ccbdaa9cc8c0f0c94f0445da3a3097c19fd2d78"><code>3ccbdaa</code></a> Clean shared formula cell cache on remove formula and simplify adjust formula...</li> <li><a href="https://github.com/qax-os/excelize/commit/b9f2c9e0055d7e95755d71f3f9861aa090d8eb81"><code>b9f2c9e</code></a> This closes <a href="https://redirect.github.com/xuri/excelize/issues/1961">#1961</a>, add shared formula cell cache for speedup calculation (<a href="https://redirect.github.com/xuri/excelize/issues/2118">#2118</a>)</li> <li><a href="https://github.com/qax-os/excelize/commit/0f19d7fcd7c7c6ab3f25a363ced93896a4d323e8"><code>0f19d7f</code></a> This closes <a href="https://redirect.github.com/xuri/excelize/issues/2117">#2117</a>, support add data table for chart</li> <li><a href="https://github.com/qax-os/excelize/commit/55cf0d42a76bc4f8d8810d4d8dcc5017debe1082"><code>55cf0d4</code></a> Improve cell read performance by optimizing XML parsing (<a href="https://redirect.github.com/xuri/excelize/issues/2116">#2116</a>)</li> <li>Additional commits viewable in <a href="https://github.com/xuri/excelize/compare/v2.9.0...v2.9.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.9.0&new-version=2.9.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>