schbook
4ff4208b3c
Add unit test for formula calculation engine ( #209 )
2025-12-05 09:04:52 +08:00
Zhu Zhengyang
72169352d1
This closes #2139 , avoid lookupLinearSearch malloc slice ( #2140 )
...
- Reduce memory and time cost about 50%
Co-authored-by: zhengyang.zhu <zhengyang.zhu@centurygame.com >
2025-12-04 10:51:39 +08:00
Kingson4Wu
f1ac51e63b
Refs #2144 , remove calcCacheMu field in the File data structure ( #1440 )
...
- Increase unit test time out to 1 hour
2025-11-28 08:41:24 +08:00
Yi Deng
899080077c
This closes #2057 , support calculation cache to improve CalcCellValue performance ( #2144 )
2025-11-27 21:19:09 +08:00
Yasar Luo
8a99debc18
This closes #1862 , closes #1904 and closes #1948 ( #1742 )
...
- Support set the data point color for doughnut, pie and 3D pie chart
- Add new ChartDataPoint data type
- Add new field DataPoint in the ChartSeries data type
- Automating dependabot tasks with GitHub Actions
- Upgrade GitHub Action tool chains version
2025-11-26 08:50:18 +08:00
xuri
97fd800edb
Add unit tests for the formula function UNIQUE
...
- Update dependencies modules
2025-11-21 10:06:15 +08:00
Ivan Hristov
8c97b95202
This closes #2165 , add formula function UNIQUE support ( #2166 )
...
- Update unit tests
---------
Co-authored-by: Ivan Hristov <ivan.hristov@abraxa.com >
2025-11-20 09:58:30 +08:00
sqdtss
e799e95bab
This closes #2237 , fix panic when open encrypted workbook in some cases ( #2238 )
...
- Add more unit test for crypt, improve test code coverage
Co-authored-by: shuotan <shuotan@tencent.com >
2025-11-14 09:09:11 +08:00
radam9
8bf639c3ad
Fix: skipped column style bug in StreamWriter's SetRow ( #2235 )
2025-11-13 10:29:25 +08:00
xuri
bfa81ac875
This closes #2234 , allowing insert ICO format images
2025-11-12 11:27:15 +08:00
shcabin
3d23585cf1
optimize: convert using continued fractions fundamental recurrence formulas ( #2220 )
2025-11-10 11:09:04 +08:00
jesusfelix951-lang
d97f1a31cc
Return error if adding comment on a cell which already exist comment ( #2227 )
...
Co-authored-by: felixdevelopper-hue <felixdevelopper@gmail.com >
2025-11-09 00:12:28 +08:00
pegasscience-cyber
8325cf6f17
Update TIF image for fix generated TestSetSheetBackgroundFromBytes.xlsx can not open in Office 2007( #2232 )
2025-11-02 12:30:24 +08:00
Roman Sergeev
541ca7c1b9
Use tab instead of space indent in doc code block ( #2230 )
...
Co-authored-by: r.sergeev <r.sergeev@yadro.com >
2025-10-29 10:24:20 +08:00
Roman Sergeev
78a8a43268
Update docs for the SetDefinedName function ( #2229 )
...
Co-authored-by: r.sergeev <r.sergeev@yadro.com >
2025-10-28 19:19:23 +08:00
wangacc
f0a56d6b45
This closes #2226 , optimize overlap merged cell ranges check ( #2228 )
...
- Update unit tests
- Remove empty row on saving, reduce generated workbook file size
2025-10-25 10:53:52 +08:00
SangHyuk
896a086a3a
This closes #2224 , fix apply number format code panic cause by Chinese month name index overflow ( #2225 )
2025-10-23 17:25:39 +08:00
Simmons25
ccaddf2dd5
Fix extractPivotTableField function panic on invalid data type reflection ( #2221 )
...
Co-authored-by: jh_peng <jh_peng@tkplusemi.com >
2025-10-22 11:36:20 +08:00
xuri
5252183afd
Update docs for Go version 1.24.0 required
...
- Add docs for fill type
- Update dependencies modules
- Upgrade GitHub Action tool chains version
- New Excelize logo
v2.10.0
2025-10-14 00:03:30 +08:00
shcabin
c12dca0397
This related to #2080 , support blank padding in number formatting ( #2216 )
2025-10-05 10:35:27 +08:00
OliverX
a44e440be5
Breaking changes: Go 1.24.0 and later required for upgrade of dependency package golang.org/x/crypto ( #2214 )
...
- Speedup UTF16 string length count, back port countUTF16String function from PR 2206
- Update dependencies modules
- Update docs for the AddChart function
2025-10-03 22:32:31 +08:00
zhang-lun
42840b3fd5
Update GitHub Actions workflow configuration, test on Go 1.25.x ( #2213 )
2025-09-16 19:10:53 +08:00
zhuyanhuazhuyanhua
aca295923b
Add unit tests for the BAHTTEXT formula function ( #2148 )
...
- Fix code lint issue
2025-09-04 11:06:45 +08:00
Now-Shimmer
c95ba17206
Add formula function BAHTTEXT support ( #2187 )
...
- Update unit tests
2025-09-04 09:42:10 +08:00
crush-wu
9e0c94e17a
Add 4 stock chart support for AddChart and AddChartSheet function ( #2177 )
...
- Support create 4 kinds of box and whisker stock charts: "High-Low-Close", "Open-High-Low-Close", "Volume-High-Low-Close", "Volume-Open-High-Low-Close"
- Add new ChartUpDownBar data type
- Add 2 new fields UpBars and DownBars in the ChartPlotArea type
- Update unit tests
2025-09-02 09:56:10 +08:00
torotake
2e1d05feed
This closes #2205 , fix string counting and truncation for cell length limitation ( #2206 )
2025-09-01 14:32:03 +08:00
a2659802
845a2746d7
This closes #2199 , add new function SetZipWriter for custom ZIP writer support ( #2200 )
...
- Add new ZipWriter data type
- Add new field ZipWriter in the File data type
- Made the CharsetTranscoder function parameter does not use the internal data type charsetTranscoderFn
- Update unit tests
2025-08-20 07:30:21 +08:00
Leo012345678
b372bd3d2e
Add check transparency value when create chart ( #2198 )
...
- Update unit tests
2025-08-09 14:03:00 +08:00
Copilot
5d2ee53bff
This closes #2192 , made special date format result consistent with Excel ( #2193 )
...
- Update unit tests
2025-08-06 00:18:58 +08:00
xuri
11dcc8f0db
Support apply number format with the Dutch language
...
- Update unit tests
2025-08-01 09:16:02 +08:00
Neugls
ce06e700d1
Optimize the GetSheetDimension function by parse worksheet XML in stream mode ( #2188 )
2025-07-31 10:21:37 +08:00
black-butler
d13cd9128c
Add optional parameter withoutValues for the GetMergeCells function ( #2184 )
...
- Update dependencies modules
- Update unit tests
2025-07-30 10:12:19 +08:00
juefeng
b674220b76
Using relative sheet target path in the internal workbook relationship parts ( #2185 )
2025-07-29 08:15:05 +08:00
xuri
4a354cbc1b
Support apply number format with the Danish and Divehi language
...
- Update unit tests
2025-07-28 00:19:18 +08:00
xuri
fa4906aa8a
Support apply number format with the Czech and Danish language
...
- Replace URL escape code by ASCII character
- Using uppercase for Unicode
2025-07-27 13:40:26 +08:00
xuri
7e71d921a9
This improvement number format support
...
- Alignment number format code mapping for LCID protocol revision 16.0
- Support apply number format with the Corsican, Croatian, Croatian (Latin) and Dzongkha language
- Fix incorrect month name abbreviations in the Tibetan language
- Update unit tests
2025-07-26 14:18:18 +08:00
Hong Jiarong
fbcf6573d7
This closes #2180 , fix add pivot table caused workbook corrupted on Excel for Mac ( #2182 )
2025-07-25 09:41:45 +08:00
xuri
dd07139785
This closes #2176 , support set transparency for chart and shape
...
- Add Transparency field in the Fill data type
- Add a new exported error variable ErrTransparency
- Update error message for more clear
- Update unit tests
2025-07-17 08:07:17 +08:00
Copilot
249b593d21
This closes #2169 , support to set font for chart legends ( #2171 )
...
- Add Font field in the ChartLegend data type
- Add Legend field in the ChartSeries data type
- Update documentation for legend font support
- Update unit tests
2025-07-10 08:15:08 +08:00
xuri
f47b3df731
This closes #2167 , count characters as single runes in characters length limitation checking
2025-07-07 09:17:27 +08:00
xuri
38f11c476a
Support set dash line and marker border type of charts
...
- Add Dash and Fill fields in the ChartLine data type
- Add Border field in the ChartMarker data type
- Add new ChartDashType data type
- Support setting dash type of line charts
- Update unit tests
2025-07-06 16:01:43 +08:00
Leopard31415926
4ac39a83f9
This closes #2161 , fix panic on read unsupported pivot table cache source types ( #2168 )
...
- GetPivotTables function return error on read unsupported pivot table cache source types
- Update docs for the AddChart function
- Update unit tests
2025-07-05 11:31:43 +08:00
MengZhongYuan
55e152f849
This closes #2024 , add TempDir field in the Options data type ( #2024 ) ( #2163 )
2025-06-25 15:44:05 +08:00
MengZhongYuan
d434acdde4
This closes #2146 , introduce 2 new functions GetCustomProps and SetCustomProps ( #2147 )
...
- Add new CustomProperty data type
- Support setting excel custom properties
- Update unit tests
2025-06-15 07:58:56 +08:00
Jameshu0513
9fe3a9250f
Update dependencies modules ( #2156 )
2025-06-14 13:45:08 +08:00
xuri
a33bd1aa5b
This closes #2019 , closes #2150 , fix panic on get string item with invalid offset range
...
- Update unit test
2025-06-04 09:19:31 +08:00
Now-Shimmer
c5934ea0e7
Update number format parser, fix parser dropped empty literals in the end of the number format ( #2149 )
...
- Add Hijri and Gregorian calender code support
- Update unit test
2025-06-02 15:17:12 +08:00
xuri
c46099ee67
This closes #2145 , remove all leading equal symbol when set cell formula, for improve compatibility with Apple Numbers
2025-05-27 09:16:56 +08:00
xiaoq898
5bd9647dbe
Skip fallback to default font size when create style if font size less than minimum size ( #2143 )
...
- Update comment for add form control function
- Update README for minimum Go language required version
2025-05-26 10:13:13 +08:00
Ali Vatandoost
b65c16b3cd
Add set and get Charset and VertAlign to font definitions ( #2141 )
...
- Added `Charset` field to `Font` struct
- Allows developers to explicitly specify font encodings when generating spreadsheets
- Simplify code by combine set and get font from `Font` to `xlsxFont` and `xlsxRPr`
- Update unit tests covering different charset values
2025-05-25 11:27:12 +08:00