1349 Commits

Author SHA1 Message Date
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