b19e5940b8
Fix GetStyle function can not get VertAlign format ( #2079 )
...
- Fix redundant cols element generated by stream writer
- Update dependencies module
- Update docs for the GetCellRichText function
- Move TestSetCellIntFunc function to cell_test.go
2025-01-25 10:01:27 +08:00
0e0e2dadcf
This close #2075 , add new function SetColStyle for streaming writer to support set columns style ( #2076 )
...
- Add new exported error variable ErrStreamSetColStyle
- Fix cell default style doesn't override by none-zero row style when set row by stream writer
- Update unit tests
Signed-off-by: mengzhongyuan <mengzhongyuan@bytedance.com>
2025-01-24 17:45:25 +08:00
7e614c5104
This closes #2072 , support adjust data validations cross multiple worksheets ( #2073 )
2025-01-22 18:54:04 +08:00
a45d47d57c
Fix: int overflow of function
2025-01-22 09:52:58 +08:00
xuri
b936343814
This closes #2068 , breaking changes: SetCellInt function required int64 data type parameter
...
- Update unit tests
2025-01-21 09:13:23 +08:00
e9efc47316
Correct comments of the internal function setSheetOutlineProps ( #2066 )
2025-01-14 19:19:16 +08:00
xuri
af422e1700
This closes #1954 and closes #2051 , fix get pivot tables panic in some case
2025-01-05 09:37:31 +08:00
4b4d4df76b
This closes #2061 , fix border styles missing after saved workbook ( #2064 )
...
- Using form template for GitHub issues
- Typo fix for comments of the getSupportedLanguageInfo function
2025-01-04 11:17:56 +08:00
xuri
caf22e4974
This closes #2059 , support delete one cell anchor image
...
- Fix delete wrong images in some case which caused by image reference detection issue
- Update unit tests
2025-01-02 07:32:49 +08:00
xuri
3f6ecffcca
This closes #2052 , support to sets the format of the chart series data label
...
- Add new field DataLabel in the ChartSeries data type
2024-12-29 12:30:28 +08:00
xuri
9934bf5c86
This closes #2046 , add new function AddIgnoredErrors support to ignored error for a range of cells
...
- Add new exported IgnoredErrorsType enumeration
- Change the type of DataValidationType, DataValidationErrorStyle, DataValidationOperator, PictureInsertType from int to byte
2024-12-21 15:11:17 +08:00
xuri
5ef4a360c1
This closes #2048 , fix missing vertical and horizontal border styles
...
- Update dependencies module
2024-12-20 09:43:44 +08:00
xuri
8e0490927e
Update unit test for internal function unzipToTemp
...
- Move security markdown into .github directory
- Fix incorrect docs of the AddChart function
- Update the CodeQL config
2024-12-14 09:45:36 +08:00
xuri
b53bad3541
Breaking changes: Go 1.20 and later required
...
- Update dependencies module
2024-12-12 16:43:48 +08:00
xuri
3ca60f8d23
This closes #2033 , support set gap width and overlap for column and bar chart
...
- Add new fields GapWidth and Overlap in the Chart data type
- Update unit tests
- Update dependencies modules
2024-12-08 11:39:54 +08:00
c93618856a
This closes #2029 , use a faster deepcopy library ( #2030 )
...
Signed-off-by: Eng Zer Jun <engzerjun@gmail.com>
2024-11-22 21:56:38 +08:00
xuri
5f446f25f0
This closes #2025 , support set chart axis text direction and rotation
...
- Add new field Alignment in the ChartAxis data type
- Update unit tests
- Update doc of the AddHeaderFooterImage function
2024-11-15 22:03:10 +08:00
30d3561d0e
Rename SetLegacyDrawingHF to AddHeaderFooterImage ( #2023 )
...
- Add new exported HeaderFooterImagePositionType enumeration
- An error will be return if the image format is unsupported
- Rename exported data type HeaderFooterGraphics to HeaderFooterImageOptions
- Support add and update exist header and footer images
- Changes the VML data ID to sheet ID
- Update unit tests
- Update dependencies modules
2024-11-09 18:36:42 +08:00
d2be5cdf8e
The SetPageLayout function support set page order of page layout ( #2022 )
...
- Add new fields PageOrder for PageLayoutOptions
- Add a new exported error variable ErrPageSetupAdjustTo
- An error will be return if the option value of the SetPageLayout function is invalid
- Updated unit tests
2024-11-08 16:59:07 +08:00
b7375bc6d4
This closes #1395 , add new function SetLegacyDrawingHF support to set graphics in a header/footer ( #2018 )
2024-11-04 10:39:55 +08:00
xuri
0d5d1c53b2
This closes #2015 , fix a v2.9.0 regression bug introduced by commit 7715c1462a
...
- Fix corrupted workbook generated by open the workbook generated by stream writer
- Update unit tests
2024-10-25 08:52:59 +08:00
xuri
af190c7fdc
This closes #2014 , fix redundant none type pattern fill generated
...
- Simplify unit tests
2024-10-23 22:07:25 +08:00
d1937a0cde
This closes #1885 , add new CultureNameJaJP, CultureNameKoKR and CultureNameZhTW enumeration values ( #1895 )
...
- Support apply number format for the Japanese calendar years, the Korean Danki calendar and the Republic of China year
- Update unit tests
Signed-off-by: wushiling50 <2531010934@qq.com>
2024-10-21 09:36:04 +08:00
xuri
f1d1a5dc2b
This closes #2004 , support apply number format for time and duration cell value
...
- Add unit tests
- Update dependencies modules
2024-10-10 22:44:38 +08:00
b23e5a26df
This closes #1076 , add new function MoveSheet to support changing sheet order in the workbook ( #1996 )
...
- Add unit tests
2024-09-30 21:00:59 +08:00
bebb802069
This closes #1999 , fix error on GetCellRichText function when read cell without SST index ( #2000 )
...
- Add unit test for get cell rich text when string item index is invalid
- Add comments for the variable ErrPasswordLengthInvalid
- Update dependencies modules
- Update GitHub Actions workflow configuration, test on Go 1.23.x
2024-09-27 14:58:18 +08:00
xuri
41c7dd30ce
This closes #1993 , support to set and get pivot table classic layout
...
- Add new field `ClassicLayout` in the `PivotTableOptions`
- Add a new exported error variable `ErrPivotTableClassicLayout`
- Update unit tests
- Add documentation for the SetDefinedName function, ref #1015
2024-09-21 15:39:36 +08:00
02189fb016
Ref #65 , new formula function DOLLAR ( #1992 )
...
- Update unit tests
2024-09-12 22:07:18 +08:00
xuri
ad8541790d
This closes #1989 , fix incorrect result of formula functions XIRR and XNPV
...
- Require number data type instead of string
- Fix incorrect formula error type
2024-09-08 12:19:58 +08:00
xuri
8c0ef7f90d
This closes #1983 , support create combo chart with same types
...
- Add new exported ChartLineUnset enumeration
- Fix set line type of line chart does not work
- Support set line type of scatter chart
2024-09-05 21:38:19 +08:00
aca04ecf57
This closes #1987 , support absolute paths for pictures ( #1988 )
2024-09-04 19:47:02 +08:00
0447cb22c8
This close #1985 , fix incorrect result of cell value after apply general number format ( #1986 )
...
- Update unit tests
2024-09-02 09:19:50 +08:00
xuri
29366fd126
Add new fields for pivot table options and pivot field options
...
- Add new fields FieldPrintTitles and ItemPrintTitles in the PivotTableOptions data type
- Add new fields ShowAll and InsertBlankRow in the PivotTableField data type
- Export 4 constants ExtURIDataField, ExtURIPivotField, ExtURIPivotFilter and ExtURIPivotHierarchy
- Update unit tests
- Update dependencies modules
2024-09-01 12:10:01 +08:00
8f87131608
This closes #1979 , fix decimal value round issue ( #1984 )
...
- Updated unit tests
2024-08-31 10:57:26 +08:00
9c460ffe6c
Add support for applying number format expression with language/location tags and ID ( #1951 )
...
- Update unit tests for specified date and time format code
2024-08-27 22:41:32 +08:00
c805be1f6f
This related for #810 , add new functions DeleteSlicer and GetSlicers ( #1943 )
...
- Update unit tests
2024-08-23 10:47:47 +08:00
xuri
9a38657515
This related for #720 and closes #1965 , add new NumFmt field in the PivotTableField data type
...
- Support set and get built-in number format of the pivot table data filed cells
- Update unit tests
- Fixed ineffectual assignment issue
2024-08-18 00:18:02 +08:00
xuri
d21b598235
This closes #1968 , closes #1969
...
- Fix missing conditional formatting after remove column
- Fix the SetSheetVisible function panic on none views sheet
- Updated unit tests
2024-07-31 09:10:05 +08:00
xuri
30c4cd70e0
This close #1963 , prevent the GetStyle function panic when theme without sysClr
2024-07-23 21:48:17 +08:00
xuri
d81b4c8661
This closes #1957 , fix missing shape macro missing after adjusted drawing object
2024-07-19 22:22:47 +08:00
xuri
4dd34477f7
This closes #1955 , refs #119 , support to set cell value with an IEEE 754 "not-a-number" value or infinity
2024-07-18 21:05:36 +08:00
68a1704900
This fix missing horizontal axis in scatter chart with negative values ( #1953 )
...
Co-authored-by: Simmons <1815481@qq.com>
2024-07-17 08:44:16 +08:00
xuri
9c278365f2
This closes #1945 , an error will be return if column header cell is empty in pivot table data range
...
- Update unit tests
2024-07-13 10:41:57 +08:00
307e533061
This closes #1942 , fix percent sign missing in formatted result for zero numeric cell value ( #1947 )
...
- Updated unit tests
2024-07-12 08:07:19 +08:00
431c31029e
This closes #1944 , add new TickLabelPosition field in the ChartAxis data type ( #1946 )
...
- Introduce new exported ChartTickLabelPositionType enumeration
- Update unit tests
2024-07-11 14:39:16 +08:00
xuri
53b65150ce
This closes #1940 , SetCellHyperLink function now support remove hyperlink by None linkType
...
- Update unit tests
2024-07-07 17:22:13 +08:00
7999a492a4
This closes #1937 , fix GetPivotTables returns incorrect data range ( #1941 )
...
- Add unit test for get pivot table with across worksheet data range, update dependencies package and updated comments of the GetMergeCells function
2024-07-06 09:25:09 +08:00
b18b48099b
Optimize ColumnNumberToName function performance, reduce about 50% memory usage and 50% time cost ( #1935 )
...
Co-authored-by: zhayt <zaibek@wtotem.com>
2024-07-05 14:34:02 +08:00
4e6457accd
This closes #1926 , fix secondary vertical axis title is not displayed ( #1928 )
2024-06-21 08:13:12 +08:00
f04aa8dd31
Add new AutoFitIgnoreAspect field in the GraphicOptions data type ( #1923 )
...
- Support fill the cell with the image and ignore its aspect ratio
- Update the unit tests
2024-06-19 20:45:25 +08:00
hly-717
xuri