summaryrefslogtreecommitdiff
path: root/xmlWorkbook.go
Commit message (Collapse)AuthorAge
* 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
* ref #65, #1196: fix the compatibility issue and added new formula functionxuri2022-04-06
| | | | - New formula functions: MODE and T.TEST
* This closes #1171, improve the compatibility and added new formula functionxuri2022-03-07
| | | | ref #65, added new formula function: FINV
* This closes #1162, improve the compatibility with alternate contentxuri2022-03-05
| | | | Preserve alternate content in the workbook, worksheet, and drawingML
* This closes #1160, and added 4 new formula functionsxuri2022-02-26
| | | | | * Fix show sheet tabs issue * Ref #65, new formula functions: ERROR.TYPE, HOUR, SECOND TIMEVALUE
* 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
* Typo fix, rename exported constants, dependencies modules and copyright updatexuri2022-01-09
| | | | Rename exported constants `NameSpaceDublinCoreMetadataIntiative` to `NameSpaceDublinCoreMetadataInitiative`
* Support concurrency add picturexuri2021-07-06
|
* Go 1.15 and later required, #65 fn: IMABS, IMCOS, IMCOSH, IMCOT, IMCSC, ↵xuri2021-04-04
| | | | IMCSCH, IMEXP, IMLN and IMLOG10
* #65 fn: N, PERCENTILE.INC and Txuri2021-03-30
| | | | typo fixed
* Fixed #766, change order, and added fields of workbook fieldsxuri2021-01-23
|
* update docs and improve compatibilityxuri2020-07-11
|
* Update docs and typo fixedxuri2020-06-22
|
* Improve code coverage unit testsxuri2019-12-29
|
* Improve code coverage unit testsxuri2019-12-22
|
* Fix #426, handle empty workbook viewxuri2019-12-16
|
* Combine functions:xuri2019-09-16
| | | | | | workBookRelsWriter, drawingRelsWriter into relsWriter; drawingRelsReader, workbookRelsReader, workSheetRelsReader into relsReader; addDrawingRelationships, addSheetRelationships into addRels
* Documentation updated, Go 1.10+ requiredxuri2019-08-11
|
* New functions: SetDefinedName and GetDefinedName addedxuri2019-06-18
|
* Fix #413, make pivot cache ID not omit emptyxuri2019-06-01
|
* Resolve #404, get sheet map by target rels.xuri2019-05-17
|
* README updatedxuri2019-01-01
|
* Fixes #308, refactor `NewSheet()`, `DeleteSheet()`, `SetActiveSheet()` and ↵xuri2018-12-15
| | | | `GetActiveSheetIndex()`
* Comments style changed.xuri2018-09-14
|
* Comments style changed.xuri2018-09-14
|
* Comments style changed.xuri2018-09-14
|
* Fix golint errors under confidence 0.1xuri2018-09-12
|
* Add missing XML attributes `customWorkbookViews` and `customWorkbookView` in ↵Ri Xu2017-11-16
| | | | | | the workbook, relate issue #152. Signed-off-by: Ri Xu <xuri.me@gmail.com>
* Trim blank cells which created by `completeCol()`, relate issue #81Ri Xu2017-07-16
|
* - Fix missing element in worksheet, workbook and styles. Related issue #81;Ri Xu2017-07-15
| | | | - Format code and update readme
* Code optimize.Ri Xu2017-05-24
|
* - Add hyperlink and set formula support for cell support;Ri Xu2017-01-19
| | | | | - Character limits for cells added; - Update go test and fix typo
* Format commants, break comments after 80 characters.Ri Xu2017-01-18
|
* - Performance improvement, remove `replaceRelationshipsID` and ↵Ri Xu2016-12-31
| | | | | | `workBookCompatibility` functions; - New functions `GetActiveSheetIndex`, `GetSheetName` and `GetSheetMap` added.
* - Fix issue: pivot cache and extending spreadsheetML missing;Ri Xu2016-12-26
| | | | - Compatibility improved: relationship namespace in `workbook.xml` has been changed (`xmlns:mc`, `xmlns:x15` and `mc:Ignorable` added)
* - Update maximum 31 characters allowed in sheet title;Ri Xu2016-12-23
| | | | | | | - Fix issue XML tag `headerFooter` and `sheetPr` element self-close errors cause file corruption; - Fix issue `Section` and `Pane` element order make file corruption in some case; - Change sheet `rId` calculation method in `/xl/workbook.xml`, fix makes file corruption in some case; - Compatibility improved: add `xlsxTabColor` struct and some XML element for worksheet
* - Fix issue comments missing after save;Ri Xu2016-12-22
| | | | | - Update import PKG syntax in struct; - Update test XLSX file (include table, charts, functions, comments and hyperlink on Sheet1)
* Update godoc of package.Ri Xu2016-10-19
|
* Use conjunction with strings.Map to split Axis and update godoc.Ri Xu2016-09-12
|
* Format code with golint rulesRi Xu2016-09-02
|
* 1) Update readme file credits and go report badge added; 2) Remove use less ↵Ri Xu2016-08-31
| | | | function; 3) Update test file.
* Init commit.Ri Xu2016-08-30
generated by cgit v1.2.1 (git 2.18.0) at 2025-04-16 00:24:24 +0000