p30928647
/
excelize
1
0
Fork 1
Code Issues Pull Requests Projects Releases 23 Wiki Activity
1,290 Commits 2 Branches 23 Tags 21 MiB
Commit Graph

1290 Commits

Author SHA1 Message Date
xuri 3ccbdaa9cc
Clean shared formula cell cache on remove formula and simplify adjust formula reference code 2025-04-27 10:16:57 +08:00
shcabin b9f2c9e005
This closes #1961, add shared formula cell cache for speedup calculation (#2118) 
- Reuse formula shared index when update refer cell formula
- Fix shared cell not been updated on update refer cell formula with new range
- Upgrade dependencies package go-deepcopy to v1.5.2
- Update unit tests
 2025-04-26 17:29:33 +08:00
xuri 0f19d7fcd7
This closes #2117, support add data table for chart 
- Add ShowDataTable and ShowDataTableKeys fields in the ChartPlotArea data type
- Update unit tests
 2025-04-22 07:59:52 +08:00
shcabin 55cf0d42a7
Improve cell read performance by optimizing XML parsing (#2116) 
- Rows iterator speedup about 20%, memory allocation reduce about 10%
- Update unit test
- Extends time out to 50 minutes in GitHub Action for made TestZip64 stable
 2025-04-18 19:52:59 +08:00
xuri ce9061fe46
This fix corrupted workbook generated when any inner ZIP64 file's size exceeds 4GB 
- Update unit tests
- Support set version required to 4.5 in local file header
- Note that this fix not work on Office 2010
 2025-04-16 19:54:32 +08:00
xuri f85dae6cfa
This closes #2113, AddFormControl function support set cell link for check box 2025-04-11 14:45:48 +08:00
timesince 6007d25231
Simplifying code with directly swap the values of two variables (#2114) 2025-04-09 16:02:53 +08:00
xuri e12da49e38
This fixes #2056, fix incorrect formula calculation result caused by shared formula parsed error 
- Also reference #844
- Update unit test
- Update documentation of the SheetPropsOptions data structure
- Update dependencies modules
 2025-04-04 17:50:18 +08:00
Paolo Barbolini 3650e5c58d
Avoid looking up absent cells in `rangeResolver` (#2111) 2025-03-29 22:51:05 +08:00
Artur Chopikian 91d36ccf7c
Fix performance regression in v2.9.0, reduce trim cell value memory allocation for blank cells (#2100) 2025-03-25 12:41:15 +08:00
Moises P. Sena e9d27c7fab
This closes #2108, Add docs to SheetPropsOptions function for how to set 4 kinds of scaling options (#2109) 2025-03-23 19:58:06 +08:00
hm3248 d399e7bc3e
Breaking changes: Go 1.23 and later required for upgrade of dependency package `golang.org/x/crypto` (#2104) 
- Fix panic on delete calc chain
- Remove XML tags for the CalcPropsOptions data structure
- Update dependencies modules
- Update the godoc
 2025-03-17 00:04:03 +08:00
LZCZ 2bb89f4bd9
This closes #2102, fix panic on set chart title font (#2103) 
- Update unit tests
 2025-03-16 22:00:30 +08:00
xuri d6931a8f3e
Add optional value checking for CalcMode and RefMode calculation properties 
- Add valid optional value prompt in error message for the functions: `AddFormControl`, `AddPicture` and `AddPictureFromBytes`
- Rename the internal error message function `newInvalidPageLayoutValueError` to `newInvalidOptionalValue`
- Update unit tests
 2025-03-06 19:47:10 +08:00
Roman Shevelev aef20e226c
Introduce 2 new functions SetCalcProps and GetCalcProps (#2098) 
- Add new CalcPropsOptions data type
- Support assign exported data structure fields value to internal data structure fields dynamically by specified fields name list
- Simplify code for function SetAppProps, SetDocProps, SetWorkbookProps, GetWorkbookProps and getPivotTable
- Update unit tests
 2025-03-04 21:23:33 +08:00
Artur Chopikian c6d161fc76
Reduce trim cell value memory allocation for blank cells (#2096) 2025-03-02 11:24:49 +08:00
xuri 5264285441
This closes #2091, update GitHub Actions workflow configuration, test on Go 1.24.x 
- Update dependencies modules
 2025-02-19 14:12:59 +08:00
Ivan Hristov 718417e15e
This closes #2083, fix subexpression calculation (#2084) 
Co-authored-by: Ivan Hristov <ivan.hristov@abraxa.com>
 2025-02-08 09:40:36 +08:00
Kurt Inge Smådal 05ed940040
Handle the format '?' in number formatting (#2080) 2025-02-07 09:01:27 +08:00
xuri 432462292a
This closes #2058, support apply number format with hash and zero place holder 
- Update unit tests
- Disable blank issue creation
 2025-01-26 19:53:30 +08:00
hly-717 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
MengZhongYuan 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
gypsy1234 7e614c5104
This closes #2072, support adjust data validations cross multiple worksheets (#2073) 2025-01-22 18:54:04 +08:00
xxf0512 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
ZhuHaiCheng 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
Arpelicy 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
Eng Zer Jun 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
Ilia Mirkin 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
Ilia Mirkin 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
Ilia Mirkin 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
wushiling50 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
Jian Yu, Chen 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
liuwangchao 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
ArcholSevier 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