summaryrefslogtreecommitdiff
path: root/sheet.go
Commit message (Collapse)AuthorAge
* Remove internal error log print, throw XML deserialize errorxuri2022-11-13
|
* This is a breaking change, remove partial internal error log print, throw ↵xuri2022-11-12
| | | | | | | XML deserialize error - Add error return value for the `GetComments`, `GetDefaultFont` and `SetDefaultFont` functions - Update unit tests
* This closes #1383, skip empty rows when saving the spreadsheet to reduce ↵xuri2022-11-03
| | | | file size
* Fix the error on getting the range of merged cells on the worksheet which ↵xuri2022-10-28
| | | | | | | | contains one cell merged cell range - Parse workbook default theme for custom theme color support in the feature - Variables name typo fix - Add system foreground and background color as RGB in the IndexedColorMapping list
* Go 1.16 and later required, migration of deprecation package `ioutil`xuri2022-10-13
| | | | | | - Improving performance for stream writer `SetRow` function, reduces memory usage over and speedup about 19% - Update dependencies module - Update GitHub workflow
* This closes #1047, stream writer support set panes (#1123)Harrison2022-10-11
| | | - New exported error `ErrStreamSetPanes` has been added
* Support to set summary columns to appear to the right of detail in an outlinexuri2022-10-08
| | | | | | - Simplify calculation engine code - Update documentation for the functions - Update dependencies module
* This closes #1365, normalize the sheet name (#1366)Joseph Watson2022-10-07
| | | Signed-off-by: Joseph Watson <jtwatson@linux-consulting.us>
* This closes #1358, made a refactor with breaking changes, see details:xuri2022-09-29
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | This made a refactor with breaking changes: Motivation and Context When I decided to add set horizontal centered support for this library to resolve #1358, the reason I made this huge breaking change was: - There are too many exported types for set sheet view, properties, and format properties, although a function using the functional options pattern can be optimized by returning an anonymous function, these types or property set or get function has no binding categorization, so I change these functions like `SetAppProps` to accept a pointer of options structure. - Users can not easily find out which properties should be in the `SetSheetPrOptions` or `SetSheetFormatPr` categories - Nested properties cannot proceed modify easily Introduce 5 new export data types: `HeaderFooterOptions`, `PageLayoutMarginsOptions`, `PageLayoutOptions`, `SheetPropsOptions`, and `ViewOptions` Rename 4 exported data types: - Rename `PivotTableOption` to `PivotTableOptions` - Rename `FormatHeaderFooter` to `HeaderFooterOptions` - Rename `FormatSheetProtection` to `SheetProtectionOptions` - Rename `SparklineOption` to `SparklineOptions` Remove 54 exported types: `AutoPageBreaks`, `BaseColWidth`, `BlackAndWhite`, `CodeName`, `CustomHeight`, `Date1904`, `DefaultColWidth`, `DefaultGridColor`, `DefaultRowHeight`, `EnableFormatConditionsCalculation`, `FilterPrivacy`, `FirstPageNumber`, `FitToHeight`, `FitToPage`, `FitToWidth`, `OutlineSummaryBelow`, `PageLayoutOption`, `PageLayoutOptionPtr`, `PageLayoutOrientation`, `PageLayoutPaperSize`, `PageLayoutScale`, `PageMarginBottom`, `PageMarginFooter`, `PageMarginHeader`, `PageMarginLeft`, `PageMarginRight`, `PageMarginsOptions`, `PageMarginsOptionsPtr`, `PageMarginTop`, `Published`, `RightToLeft`, `SheetFormatPrOptions`, `SheetFormatPrOptionsPtr`, `SheetPrOption`, `SheetPrOptionPtr`, `SheetViewOption`, `SheetViewOptionPtr`, `ShowFormulas`, `ShowGridLines`, `ShowRowColHeaders`, `ShowRuler`, `ShowZeros`, `TabColorIndexed`, `TabColorRGB`, `TabColorTheme`, `TabColorTint`, `ThickBottom`, `ThickTop`, `TopLeftCell`, `View`, `WorkbookPrOption`, `WorkbookPrOptionPtr`, `ZeroHeight` and `ZoomScale` Remove 2 exported constants: `OrientationPortrait` and `OrientationLandscape` Change 8 functions: - Change the `func (f *File) SetPageLayout(sheet string, opts ...PageLayoutOption) error` to `func (f *File) SetPageLayout(sheet string, opts *PageLayoutOptions) error` - Change the `func (f *File) GetPageLayout(sheet string, opts ...PageLayoutOptionPtr) error` to `func (f *File) GetPageLayout(sheet string) (PageLayoutOptions, error)` - Change the `func (f *File) SetPageMargins(sheet string, opts ...PageMarginsOptions) error` to `func (f *File) SetPageMargins(sheet string, opts *PageLayoutMarginsOptions) error` - Change the `func (f *File) GetPageMargins(sheet string, opts ...PageMarginsOptionsPtr) error` to `func (f *File) GetPageMargins(sheet string) (PageLayoutMarginsOptions, error)` - Change the `func (f *File) SetSheetViewOptions(sheet string, viewIndex int, opts ...SheetViewOption) error` to `func (f *File) SetSheetView(sheet string, viewIndex int, opts *ViewOptions) error` - Change the `func (f *File) GetSheetViewOptions(sheet string, viewIndex int, opts ...SheetViewOptionPtr) error` to `func (f *File) GetSheetView(sheet string, viewIndex int) (ViewOptions, error)` - Change the `func (f *File) SetWorkbookPrOptions(opts ...WorkbookPrOption) error` to `func (f *File) SetWorkbookProps(opts *WorkbookPropsOptions) error` - Change the `func (f *File) GetWorkbookPrOptions(opts ...WorkbookPrOptionPtr) error` to `func (f *File) GetWorkbookProps() (WorkbookPropsOptions, error)` Introduce new function to instead of existing functions: - New function `func (f *File) SetSheetProps(sheet string, opts *SheetPropsOptions) error` instead of `func (f *File) SetSheetPrOptions(sheet string, opts ...SheetPrOption) error` and `func (f *File) SetSheetFormatPr(sheet string, opts ...SheetFormatPrOption
* This closes #1360, closes #1361xuri2022-09-28
| | | | | | | - Fix default number format parse issue with a long string of digits - Fix creating a sheet with an empty name cause a corrupted file - The `GetCellStyle` function no longer return master cell style of the merge cell range - Using the specialized name in variables and functions
* Using the specialized name in a variable and making comments clearxuri2022-09-18
| | | | - Add JSON tags for `AppProperties`, `PivotTableOption` and `PivotTableField` structure
* This closes #1244 and closes #1314, improving the compatibility with Google ↵xuri2022-08-13
| | | | | | Sheet - Format code with `gofmt`
* This closes #1296, add new function `GetRowOpts` for stream reader (#1297)Thomas Charbonnel2022-08-11
| | | | - Support get rows properties by `GetRowOpts` function - New exported constant `MaxCellStyles`
* This closes #1298, fix doc properties missing after creating new worksheetxuri2022-08-03
|
* Fix potential file corrupted and change worksheet name case-insensitivexuri2022-07-18
| | | | | | - Using sheet ID instead of sheet index when delete the cell in calculation chain - Update documentation for exported functions - Using `sheet` represent the sheet name in the function parameters
* Fix potential file corrupted when changing cell value or the col/rowxuri2022-07-16
| | | | | - Remove shared formula subsequent cell when setting the cell values - Support adjust table range when removing and inserting column/row
* adjust `ErrColumnNumber`, rename `TotalColumns` to `MaxColumns` and add new ↵MJacred2022-07-14
| | | | | constant `MinColumns` (#1272) Signed-off-by: Benjamin Lösch <loesch.benny92@gmx.de>
* This closes #1269, made the `NewStreamWriter` function case insensitive to ↵Eagle Xiang2022-07-06
| | | | | worksheet name Co-authored-by: xiangyz <xiangyz@dustess.com>
* This closes #1257, fix incorrect worksheet header footer fields orderxuri2022-06-21
|
* refactor: replace strings.Replace with strings.ReplaceAll (#1250)Eng Zer Jun2022-06-12
| | | | | | | strings.ReplaceAll(s, old, new) is a wrapper function for strings.Replace(s, old, new, -1). But strings.ReplaceAll is more readable and removes the hardcoded -1. Signed-off-by: Eng Zer Jun <engzerjun@gmail.com>
* Improves the calculation engine, docs update, and adds the dependabotxuri2022-05-26
| | | | | | - Initialize array formula support for the formula calculation engine - Update example and unit test of `AddPivotTable` - Update the supported hash algorithm of ProtectSheet
* This fix formula calculation accuracy issue and panic when set panexuri2022-05-23
| | | | | - Fix `GROWTH` and `TREND` calculation accuracy issue - Fix panic when add pane on empty sheet views worksheet - New exported constants `MinFontSize`
* This closes #1225, allowing insert EMF format imagesxuri2022-05-13
|
* Format code, update documentation and remove exported variable `XMLHeaderByte`xuri2022-03-24
|
* This closes #1162, improve the compatibility with alternate contentxuri2022-03-05
| | | | Preserve alternate content in the workbook, worksheet, and drawingML
* This closes #1148, resolve limitations when adding VBA project to the workbookxuri2022-02-17
| | | | | | | | Added two exported functions `SetWorkbookPrOptions` and `GetWorkbookPrOptions` to support setting and getting the code name property of the workbook Re-order fields of the workbook properties group to improve the compatibility Go Modules dependencies upgrade Put workbook related operating in new `workbook.go` source code Library introduction docs block updated
* Fix file corrupted in some cases, check file extension and format codexuri2022-01-23
| | | | | | Fix file corrupted when save as in XLAM / XLSM / XLTM / XLTX extension in some case New exported error ErrWorkbookExt has been added, and check file extension on save the workbook Format source code with `gofumpt`
* Breaking change for data validation and fixed #1117xuri2022-01-12
| | | | | - Remove second useless parameter `isCurrentSheet` of the function `SetSqrefDropList` - Fix missing page setup of worksheet after re-saving the spreadsheet
* Typo fix, rename exported constants, dependencies modules and copyright updatexuri2022-01-09
| | | | Rename exported constants `NameSpaceDublinCoreMetadataIntiative` to `NameSpaceDublinCoreMetadataInitiative`
* feat: implement SHA-512 algorithm to ProtectSheet (#1115)Jonham.Chen2022-01-08
|
* This closes #1096, memory usage optimization and another 4 changesxuri2021-12-27
| | | | | | | | - Unzip shared string table to system temporary file when large inner XML, reduce memory usage about 70% - Remove unnecessary exported variable `XMLHeader`, we can using `encoding/xml` package's `xml.Header` instead of it - Using constant instead of inline text for default XML path - Rename exported option field `WorksheetUnzipMemLimit` to `UnzipXMLSizeLimit` - Unit test and documentation updated
* Simplify code and update unit testxuri2021-12-03
| | | | | Improve unit test coverage for the functions: `NewStyle`, `SetActiveSheet`, `SearchSheet` and `deleteAndAdjustDefinedNames` Simplify code and add comments for the function: `deleteAndAdjustDefinedNames`
* refactor DeleteSheet for better readability (#1078)Michael Wiesenbauer2021-12-02
| | | | Signed-off-by: Michael Wiesenbauer <michael.wiesenbauer@ambos.io> Co-authored-by: Michael Wiesenbauer <michael.wiesenbauer@fau.de>
* Fix sheet deletion fail in some casexuri2021-11-18
|
* ref #65: new formula function PRICExuri2021-11-17
| | | | | - fix COUPPCD result accuracy issue - update close spreadsheet example in documentation and README
* This closes #1061, support multi-byte language on set header footerxuri2021-11-16
| | | | typo fixed and simplify code for read the data values arguments of formula functions
* This closes #1057, merge column styles to reduce spreadsheet sizexuri2021-11-14
|
* return immediately when matched for efficiency (#1049)Sean Liang2021-11-03
|
* This closes #833, closes #845, and closes #1022, breaking changesxuri2021-09-19
| | | | | | - Close spreadsheet and row's iterator required - New options `WorksheetUnzipMemLimit` have been added - Improve streaming reading performance, memory usage decrease about 93.7%
* This closes #998xuri2021-09-05
| | | | | | | - Support text comparison in the formula, also ref #65 - `GetCellValue`, `GetRows`, `GetCols`, `Rows` and `Cols` support to specify read cell with raw value, ref #621 - Add missing properties for the cell formula - Update the unit test for the `CalcCellValue`
* Improve security and simplify codexuri2021-08-15
| | | | | | | - Make variable name more semantic - Reduce cyclomatic complexities for the formula calculate function - Support specified unzip size limit on open file options, avoid zip bombs vulnerability attack - Typo fix for documentation and error message
* Speed up merge cellsthree2021-08-13
|
* This closes #971, closes #972 and closes #974xuri2021-07-29
| | | | | | | | - Escape XML character in the drop list - Fix incorrect character count limit in the drop list - Fix Excel time parse issue in some case - Fix custom number format month parse issue in some case - Fix corrupted file generated caused by concurrency adding pictures
* Improvement compatibility with invalid first-page number attribute in the ↵xuri2021-07-21
| | | | page layout
* This closes #879, fix delete defined name failed in some casexuri2021-07-15
|
* This closes #873, make the sheet names are not case sensitive for ↵xuri2021-07-10
| | | | `NewSheet`, `GetSheetIndex`, `DeleteSheet`
* Make the functions `SetSheetRow`, `New Style` and `SetCellStyle` concurrency ↵xuri2021-07-07
| | | | safety
* Support concurrency add picturexuri2021-07-06
|
* - Support concurrency iterate rows and columnsxuri2021-07-05
| | | | | - Rename exported field `File.XLSX` to `File.Pkg` - Exported error message
* This closes #861, support concurrency get cell picture and remove unused ↵xuri2021-07-04
| | | | internal function `getSheetNameByID`
generated by cgit v1.2.1 (git 2.18.0) at 2025-04-16 12:51:09 +0000