This website requires JavaScript.
a33bd1aa5b
This closes #2019 , closes #2150 , fix panic on get string item with invalid offset range
xuri
2025-06-04 09:19:31 +0800
c5934ea0e7
Update number format parser, fix parser dropped empty literals in the end of the number format (#2149 )
2025-06-02 15:17:12 +0800
c46099ee67
This closes #2145 , remove all leading equal symbol when set cell formula, for improve compatibility with Apple Numbers
xuri
2025-05-27 09:16:56 +0800
5bd9647dbe
Skip fallback to default font size when create style if font size less than minimum size (#2143 )
2025-05-26 10:13:13 +0800
b65c16b3cd
Add set and get `Charset` and `VertAlign` to font definitions (#2141 )
2025-05-25 06:57:12 +0330
c85311368e
Update comment for xlsxDataValidation data structure (#2142 )
2025-05-24 10:21:45 +0800
bb1105b089
This closes #2133 , support delete data validations in the ext list (#2137 )
2025-05-18 01:32:08 +0800
72b731a04d
This closes #2132 , fix a v2.9.1 regression bug introduced by commit ce9061fe46
xuri
2025-05-14 14:46:21 +0800
4180c2082e
This closes #2130 , remove shared formula in calculation chain when remove row
xuri
2025-05-13 00:11:29 +0800
2c3d13fe8b
Using binary search instead of sequential search for cell (#2129 )
2025-05-12 13:37:33 +0800
094ff396fe
This related with #2123 , made editAs attribute value empty for one cell anchor drawing object (#2128 )
2025-05-10 00:03:03 +0800
d230ecdb48
This closes #2126 , fix sheet name error in defined name after rename sheet (#2127 )
2025-05-08 13:58:30 +0200
8fdc26e286
This fixes #2001 and fixes #2002 . Breaking changes: offsets no longer affect the image size (#2123 )
2025-05-07 03:35:32 +0200
efdfc52252
This closes #2119 , remove all temporary files on close workbook (#2120 )
2025-04-28 01:43:13 +0000
3ccbdaa9cc
Clean shared formula cell cache on remove formula and simplify adjust formula reference code
xuri
2025-04-27 10:16:57 +0800
b9f2c9e005
This closes #1961 , add shared formula cell cache for speedup calculation (#2118 )
2025-04-26 17:29:33 +0800
0f19d7fcd7
This closes #2117 , support add data table for chart
xuri
2025-04-22 07:59:52 +0800
55cf0d42a7
Improve cell read performance by optimizing XML parsing (#2116 )
2025-04-18 19:52:59 +0800
ce9061fe46
This fix corrupted workbook generated when any inner ZIP64 file's size exceeds 4GB
xuri
2025-04-16 19:54:32 +0800
f85dae6cfa
This closes #2113 , AddFormControl function support set cell link for check box
xuri
2025-04-11 14:45:48 +0800
6007d25231
Simplifying code with directly swap the values of two variables (#2114 )
2025-04-09 16:02:53 +0800
e12da49e38
This fixes #2056 , fix incorrect formula calculation result caused by shared formula parsed error
xuri
2025-04-04 17:50:18 +0800
3650e5c58d
Avoid looking up absent cells in `rangeResolver` (#2111 )
2025-03-29 15:51:05 +0100
91d36ccf7c
Fix performance regression in v2.9.0, reduce trim cell value memory allocation for blank cells (#2100 )
2025-03-25 06:41:15 +0200
e9d27c7fab
This closes #2108 , Add docs to SheetPropsOptions function for how to set 4 kinds of scaling options (#2109 )
2025-03-23 08:58:06 -0300
d399e7bc3e
Breaking changes: Go 1.23 and later required for upgrade of dependency package `golang.org/x/crypto` (#2104 )
2025-03-16 12:04:03 -0400
2bb89f4bd9
This closes #2102 , fix panic on set chart title font (#2103 )
2025-03-16 14:00:30 +0000
d6931a8f3e
Add optional value checking for CalcMode and RefMode calculation properties
xuri
2025-03-06 19:47:10 +0800
aef20e226c
Introduce 2 new functions SetCalcProps and GetCalcProps (#2098 )
2025-03-04 18:20:24 +0500
c6d161fc76
Reduce trim cell value memory allocation for blank cells (#2096 )
2025-03-02 05:24:49 +0200
5264285441
This closes #2091 , update GitHub Actions workflow configuration, test on Go 1.24.x
xuri
2025-02-19 14:12:59 +0800
718417e15e
This closes #2083 , fix subexpression calculation (#2084 )
2025-02-08 03:40:36 +0200
05ed940040
Handle the format '?' in number formatting (#2080 )
2025-02-07 02:01:27 +0100
432462292a
This closes #2058 , support apply number format with hash and zero place holder
xuri
2025-01-26 19:53:30 +0800
b19e5940b8
Fix GetStyle function can not get VertAlign format (#2079 )
2025-01-25 10:01:27 +0800
0e0e2dadcf
This close #2075 , add new function SetColStyle for streaming writer to support set columns style (#2076 )
2025-01-24 17:45:25 +0800
7e614c5104
This closes #2072 , support adjust data validations cross multiple worksheets (#2073 )
2025-01-22 19:54:04 +0900
a45d47d57c
Fix: int overflow of function
2024-11-26 22:58:19 +0800
b936343814
This closes #2068 , breaking changes: SetCellInt function required int64 data type parameter
xuri
2025-01-21 09:13:23 +0800
e9efc47316
Correct comments of the internal function setSheetOutlineProps (#2066 )
2025-01-14 19:19:16 +0800
af422e1700
This closes #1954 and closes #2051 , fix get pivot tables panic in some case
xuri
2025-01-05 09:37:31 +0800
4b4d4df76b
This closes #2061 , fix border styles missing after saved workbook (#2064 )
2025-01-04 11:17:56 +0800
caf22e4974
This closes #2059 , support delete one cell anchor image
xuri
2025-01-02 07:32:49 +0800
3f6ecffcca
This closes #2052 , support to sets the format of the chart series data label
xuri
2024-12-29 12:30:28 +0800
9934bf5c86
This closes #2046 , add new function AddIgnoredErrors support to ignored error for a range of cells
xuri
2024-12-21 15:11:17 +0800
5ef4a360c1
This closes #2048 , fix missing vertical and horizontal border styles
xuri
2024-12-20 09:43:44 +0800
8e0490927e
Update unit test for internal function unzipToTemp
xuri
2024-12-14 09:45:36 +0800
b53bad3541
Breaking changes: Go 1.20 and later required
xuri
2024-12-12 16:43:48 +0800
3ca60f8d23
This closes #2033 , support set gap width and overlap for column and bar chart
xuri
2024-12-08 11:39:54 +0800
c93618856a
This closes #2029 , use a faster deepcopy library (#2030 )
2024-11-22 21:56:38 +0800
5f446f25f0
This closes #2025 , support set chart axis text direction and rotation
xuri
2024-11-15 22:03:10 +0800
30d3561d0e
Rename SetLegacyDrawingHF to AddHeaderFooterImage (#2023 )
2024-11-09 05:36:42 -0500
d2be5cdf8e
The SetPageLayout function support set page order of page layout (#2022 )
2024-11-08 03:59:07 -0500
b7375bc6d4
This closes #1395 , add new function SetLegacyDrawingHF support to set graphics in a header/footer (#2018 )
2024-11-03 21:39:55 -0500
0d5d1c53b2
This closes #2015 , fix a v2.9.0 regression bug introduced by commit 7715c1462a
xuri
2024-10-25 08:52:59 +0800
af190c7fdc
This closes #2014 , fix redundant none type pattern fill generated
xuri
2024-10-23 21:52:32 +0800
d1937a0cde
This closes #1885 , add new CultureNameJaJP, CultureNameKoKR and CultureNameZhTW enumeration values (#1895 )
2024-10-21 09:36:04 +0800
f1d1a5dc2b
This closes #2004 , support apply number format for time and duration cell value
xuri
2024-10-10 22:44:38 +0800
b23e5a26df
This closes #1076 , add new function MoveSheet to support changing sheet order in the workbook (#1996 )
2024-09-30 21:00:59 +0800
bebb802069
This closes #1999 , fix error on GetCellRichText function when read cell without SST index (#2000 )
2024-09-27 14:58:18 +0800
41c7dd30ce
This closes #1993 , support to set and get pivot table classic layout
xuri
2024-09-21 15:39:36 +0800
02189fb016
Ref #65 , new formula function DOLLAR (#1992 )
2024-09-12 22:07:18 +0800
ad8541790d
This closes #1989 , fix incorrect result of formula functions XIRR and XNPV
xuri
2024-09-08 12:19:58 +0800
8c0ef7f90d
This closes #1983 , support create combo chart with same types
xuri
2024-09-05 21:38:19 +0800
aca04ecf57
This closes #1987 , support absolute paths for pictures (#1988 )
2024-09-04 14:47:02 +0300
0447cb22c8
This close #1985 , fix incorrect result of cell value after apply general number format (#1986 )
2024-09-02 09:19:50 +0800
29366fd126
Add new fields for pivot table options and pivot field options
xuri
2024-09-01 12:10:01 +0800
8f87131608
This closes #1979 , fix decimal value round issue (#1984 )
2024-08-31 10:57:26 +0800
9c460ffe6c
Add support for applying number format expression with language/location tags and ID (#1951 )
2024-08-27 22:41:32 +0800
c805be1f6f
This related for #810 , add new functions DeleteSlicer and GetSlicers (#1943 )
2024-08-23 10:47:47 +0800
9a38657515
This related for #720 and closes #1965 , add new NumFmt field in the PivotTableField data type
xuri
2024-08-18 00:18:02 +0800
d21b598235
This closes #1968 , closes #1969
xuri
2024-07-31 09:10:05 +0800
30c4cd70e0
This close #1963 , prevent the GetStyle function panic when theme without sysClr
xuri
2024-07-23 21:48:17 +0800
d81b4c8661
This closes #1957 , fix missing shape macro missing after adjusted drawing object
xuri
2024-07-19 22:22:47 +0800
4dd34477f7
This closes #1955 , refs #119 , support to set cell value with an IEEE 754 "not-a-number" value or infinity
xuri
2024-07-18 21:05:36 +0800
68a1704900
This fix missing horizontal axis in scatter chart with negative values (#1953 )
2024-07-17 08:44:16 +0800
9c278365f2
This closes #1945 , an error will be return if column header cell is empty in pivot table data range
xuri
2024-07-13 10:41:57 +0800
307e533061
This closes #1942 , fix percent sign missing in formatted result for zero numeric cell value (#1947 )
2024-07-12 08:07:19 +0800
431c31029e
This closes #1944 , add new TickLabelPosition field in the ChartAxis data type (#1946 )
2024-07-11 14:39:16 +0800
53b65150ce
This closes #1940 , SetCellHyperLink function now support remove hyperlink by None linkType
xuri
2024-07-07 17:22:13 +0800
7999a492a4
This closes #1937 , fix GetPivotTables returns incorrect data range (#1941 )
2024-07-06 09:25:09 +0800
b18b48099b
Optimize ColumnNumberToName function performance, reduce about 50% memory usage and 50% time cost (#1935 )
2024-07-05 11:34:02 +0500
4e6457accd
This closes #1926 , fix secondary vertical axis title is not displayed (#1928 )
2024-06-20 20:13:12 -0400
f04aa8dd31
Add new AutoFitIgnoreAspect field in the GraphicOptions data type (#1923 )
2024-06-19 20:45:25 +0800
1a99dd4a23
This closes #1921 , fix set axis format doesn't work in combo chart (#1924 )
2024-06-17 21:54:15 +0800
c349313850
This closes #1910 , fix a v2.8.1 regression bug introduced by commit 866f3086cd
xuri
2024-05-29 21:05:34 +0800
08d25006f9
This fixed can not found code coverage on Windows (#1908 )
2024-05-27 20:45:37 +0800
0c3dfb1605
This closes #1903 , made GetCellStyle function concurrency safe
xuri
2024-05-25 14:54:59 +0800
42ad4d6959
This closes #1906 , fix a v2.8.1 regression bug introduced by commit d9a0da7b48
xuri
2024-05-24 22:05:07 +0800
5f583549f4
Add unit test for the stream writer to improved line of code coverage (#1898 )
2024-05-14 12:06:10 +0800
a64efca31f
This fixes #1888 , read internal media files with absolute path
xuri
2024-05-03 10:16:00 +0000
781c38481d
This closes #1889 , refs #1732 and #1735 (#1890 )
2024-04-30 19:05:05 +0300
7715c1462a
This closes #1886 , remove the namespace prefix for the default spreadsheet namespace
xuri
2024-04-27 20:13:43 +0800
055349d8a6
Fix a v2.8.1 regression bug, error on duplicate rows, if conditional formatting or data validation has multiple cell range reference
xuri
2024-04-26 00:23:10 +0800
f8487a68a8
This closes #1879 , compatible with the escaped quote symbol in none formula data validation rules (#1880 )
2024-04-18 13:21:46 +0800
3e636ae7b2
This closes #1874 , reduces memory usage for the GetRows function (#1875 )
2024-04-11 18:42:56 +0330
5f8a5b8690
This closes #1867 , breaking changes: change the data type for the ConditionalFormatOptions structure field Format as a pointer
xuri
2024-04-03 08:44:46 +0800
5dc22e874b
Support get the cell images inserted by IMAGE formula function
xuri
2024-04-02 08:47:57 +0800
9999221450
This closes #1865 , unescape newline character in stream writer
xuri
2024-04-01 08:49:21 +0800
ffad7aecb5
Support get rich data value rels index from rich value part (#1866 )
2024-03-28 16:37:35 +0800
xuri
Now-Shimmer