Commit message (Collapse) | Author | Age | |
---|---|---|---|
* | Remove internal error log print, throw XML deserialize error | xuri | 2022-11-13 |
| | |||
* | This is a breaking change, remove partial internal error log print, throw ↵ | xuri | 2022-11-12 |
| | | | | | | | XML deserialize error - Add error return value for the `GetComments`, `GetDefaultFont` and `SetDefaultFont` functions - Update unit tests | ||
* | Fix the error on getting the range of merged cells on the worksheet which ↵ | xuri | 2022-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 | ||
* | 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 #1323, an error will be returned when set the not exist style ID | xuri | 2022-09-01 |
| | |||
* | This closes #1330 update non existing sheet error messages (#1331) | davidborry | 2022-08-28 |
| | |||
* | This closes #827, add new functions `GetDataValidations` and ↵ | chenliu1993 | 2022-08-27 |
| | | | | | `GetConditionalFormats` (#1315) Signed-off-by: chenliu1993 <13630583107@163.com> | ||
* | This closes #1211, improve the compatibility with invalid internal styles count | xuri | 2022-04-28 |
| | |||
* | Format code, update documentation and remove exported variable `XMLHeaderByte` | xuri | 2022-03-24 |
| | |||
* | Ref: #660, #764, #1093, #1112, #1133 This improve number format support | xuri | 2022-02-13 |
| | | | | | | - Introduced NFP (number format parser) dependencies module - Initialize custom dates and times number format support - Dependencies module upgraded | ||
* | This closes #1096, memory usage optimization and another 4 changes | xuri | 2021-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 test | xuri | 2021-12-03 |
| | | | | | Improve unit test coverage for the functions: `NewStyle`, `SetActiveSheet`, `SearchSheet` and `deleteAndAdjustDefinedNames` Simplify code and add comments for the function: `deleteAndAdjustDefinedNames` | ||
* | Fix call getNumFmtID with builtInNumFmt return -1 | Dokiy | 2021-12-01 |
| | |||
* | This closes #1060, fix build-in time number format parse error | xuri | 2021-11-20 |
| | |||
* | This closes #1061, support multi-byte language on set header footer | xuri | 2021-11-16 |
| | | | | typo fixed and simplify code for read the data values arguments of formula functions | ||
* | This closes #1027 and closes #1028 | xuri | 2021-09-28 |
| | | | | | * Fix build-in scientific number format failed * An error will be returned if given an invalid custom number format when creating a new style | ||
* | - Support concurrency iterate rows and columns | xuri | 2021-07-05 |
| | | | | | - Rename exported field `File.XLSX` to `File.Pkg` - Exported error message | ||
* | * This closes #841, fix incorrect build number format in PR #839 | ice | 2021-05-15 |
| | |||
* | #65 fn: N, PERCENTILE.INC and T | xuri | 2021-03-30 |
| | | | | typo fixed | ||
* | Fix #724, standardize variable naming and update unit tests | xuri | 2020-11-11 |
| | |||
* | Update conversion between integer types and unit tests | xuri | 2020-10-23 |
| | |||
* | extend cell value load to support custom datetime format (#703) | Artem Kustikov | 2020-10-04 |
| | | | | | | | | | | | | | | | | | | | | | | | | | * extend cell value load to support custom datetime format * cleanup incorrect imports * fix numeric values conversion as done in legacy Excel * fix tests coverage * revert temporary package name fix * remove personal info from test XLSX files * remove unused dependencies * update format conversion in parseTime * new UT to increase code coverage * Resolve code review issue for PR #703 * Rename broken file name generated by unit test Co-authored-by: xuri <xuri.me@gmail.com> | ||
* | add checking and limits for the worksheet | xuri | 2020-09-18 |
| | |||
* | Resolve #643, avoid creating duplicate style | xuri | 2020-05-24 |
| | |||
* | - formula engine: reduce cyclomatic complexity | xuri | 2020-05-10 |
| | | | | - styles: allow empty and default cell formats, #628 | ||
* | Resolve #172, init rich text support | xuri | 2020-04-06 |
| | |||
* | Resolve #470, export Style structs to allow create the style for cells by ↵ | xuri | 2020-03-10 |
| | | | | given JSON or structure | ||
* | Resolve #571, init remove conditional format support | xuri | 2020-03-03 |
| | |||
* | Improve code coverage unit tests | xuri | 2019-12-29 |
| | |||
* | Improve compatibility, fix workbook's rels ID calc error | xuri | 2019-12-23 |
| | |||
* | Update the Godoc | xuri | 2019-08-21 |
| | |||
* | Add the ability to change the default font | Harris | 2019-05-23 |
| | | | | Closes #390 | ||
* | add unit tests to functions | xuri | 2019-04-16 |
| | |||
* | Resolve #369,#370 | xuri | 2019-04-15 |
| | | | | | | | | | | | | | | | | | | add error return value exported functions: GetMergeCells ProtectSheet UnprotectSheet UpdateLinkedValue GetMergeCells SetSheetVisible inner functions: workSheetReader copySheet | ||
* | Do not create a blank fill if no fill is specified in the style format | Michael W. Mitton | 2019-01-09 |
| | |||
* | Use min/mid/max value for 2 and 3 color scale conditional formatting | Alex Whitney | 2018-07-25 |
| | |||
* | Add failing unit tests for issue-252 | Alex Whitney | 2018-07-25 |