anyxcelize - A fork of excelize to be able to write non-strings.

	Commit message (Collapse)	Author	Age
*	excelize -> anyxcelizegetRowInterface	George Abbott	2023-06-15
\|
*	Support update column style when inserting or deleting columns	xuri	2022-11-11
\| \| \| \| \| \|	- Go Modules dependencies upgrade - Unify internal variable name - Unit test updated
*	Delete shared formula in calc chain when writing a formula cell (#1387)	March	2022-11-08
\|
*	Support get cell value which contains a date in the ISO 8601 format	xuri	2022-10-24
\| \| \| \| \| \| \| \|	- Support set and get font color with indexed color - New export variable `IndexedColorMapping` - Fix getting incorrect page margin settings when the margin is 0 - Update unit tests and comments typo fixes - ref #65, new formula functions: AGGREGATE and SUBTOTAL
*	Support to set summary columns to appear to the right of detail in an outline	xuri	2022-10-08
\| \| \| \| \| \|	- Simplify calculation engine code - Update documentation for the functions - Update dependencies module
*	This closes #1358, made a refactor with breaking changes, see details:	xuri	2022-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 #1244 and closes #1314, improving the compatibility with Google ↵	xuri	2022-08-13
\| \| \| \| \| \|	Sheet - Format code with `gofmt`
*	This closes #1312, #1313, fix number format issue	xuri	2022-08-12
\| \| \| \| \| \|	- Add supported options in the docs of the functions `SetSheetPrOptions` and `GetSheetPrOptions` - Add go1.19 unit test settings, and made the test case compatible with go1.19 - Update dependencies module
*	Add new exported `ColorMappingType` used for color transformation	xuri	2022-08-06
\| \| \| \|	Using `ColorMappingType` color transformation types enumeration for tab color index, ref #1285
*	This closes #1283, support set and get color index, theme and tint for sheet tab	Thomas Charbonnel	2022-07-26
\| \| \| \| \|	This commit renames `TabColor` into `TabColorRGB` (but keeps an alias for backwards compatibility), as well as adds support for more tab color options (Theme, Indexed and Tint). Signed-off-by: Thomas Charbonnel <github@charbonnel.email>
*	Fix potential file corrupted and change worksheet name case-insensitive	xuri	2022-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
*	This closes #1148, resolve limitations when adding VBA project to the workbook	xuri	2022-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 update	xuri	2022-01-09
\| \| \| \|	Rename exported constants `NameSpaceDublinCoreMetadataIntiative` to `NameSpaceDublinCoreMetadataInitiative`
*	Improve security and simplify code	xuri	2021-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
*	Go 1.15 and later required, #65 fn: IMABS, IMCOS, IMCOSH, IMCOT, IMCSC, ↵	xuri	2021-04-04
\| \| \| \|	IMCSCH, IMEXP, IMLN and IMLOG10
*	#65 fn: N, PERCENTILE.INC and T	xuri	2021-03-30
\| \| \| \|	typo fixed
*	This closes #785, support to change tab color; new formula function: FISHER, ↵	xuri	2021-02-16
\| \| \| \|	FISHERINV, GAMMA, GAMMALN, MIN, MINA, PERMUT
*	Update docs and typo fixed	xuri	2020-06-22
\|
*	- New API: SetSheetFormatPr and GetSheetFormatPr	xuri	2020-05-12
\| \| \| \|	- typo fix, resolve #635
*	Improve code coverage unit tests	xuri	2019-12-29
\|
*	Optimize code of Getting/Setting Page Margins	xuri	2019-10-17
\|
*	Documentation updated, Go 1.10+ required	xuri	2019-08-11
\|
*	Resolve #369,#370	xuri	2019-04-15
\| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \|	add error return value exported functions: GetMergeCells ProtectSheet UnprotectSheet UpdateLinkedValue GetMergeCells SetSheetVisible inner functions: workSheetReader copySheet
*	Resolve #318, add new functions and	zhangleijlu	2019-01-06
\|
*	README updated	xuri	2019-01-01
\|
*	Add support to flip outline summaries	Harris	2018-12-13
\| \| \| \| \| \| \| \| \|	This adds outlinePr support, with the summaryBelow attribute which defaults to true. Closes #304 Signed-off-by: Michael Harris
*	Comments style changed.	xuri	2018-09-14
\|
*	Comments style changed.	xuri	2018-09-14
\|
*	Comments style changed.	xuri	2018-09-14
\|
*	Fix golint errors under confidence 0.1	xuri	2018-09-12
\|
*	Fixes #256 and format document.	xuri	2018-08-06
\|
*	- 24 hour time format supported, relate issue #163;	Ri Xu	2017-12-01
\| \| \| \|	- godoc and go test updated
*	Add {G,S}etSheetPrOptions()	Olivier Mengué	2017-11-17
	Add SetSheetPrOptions and GetSheetPrOptions to allow to set options on <sheetPr> and <pageSetUpPr>. The following options are implemented: - CodeName (string) - EnableFormatConditionsCalculation (bool) - Published (bool) - FitToPage (bool) - AutoPageBreaks (bool)