Commit message (Collapse) | Author | Age | |
---|---|---|---|
* | 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 #1369, support set, and get font color with theme and tint (#1370) | GaoFei | 2022-10-15 |
| | |||
* | This closes #320, support custom chart axis font style | xuri | 2022-10-14 |
| | |||
* | This closes #1368, fixes number parsing issue, adds support for create a 3D ↵ | xuri | 2022-10-12 |
| | | | | line chart | ||
* | 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 #1290 and closes #1328 | xuri | 2022-08-24 |
| | | | | | - Add new smooth field in chart format parameter, support specify if smooth line chart - Fix decimal number format round issue with build-in number format | ||
* | This includes new formula functions support, dependencies upgrade, and bug fix | xuri | 2022-04-11 |
| | | | | | | | - Fix page setup fields parsing issue - Go Modules dependencies upgrade - Ref #65, CONFIDENCE.T and PHI - Ref #1198, Fix the issue that the chart axis maximum and minimum didn't work when the value is 0 | ||
* | This closes #1172, support set hole size for doughnut (#1173) | longphee | 2022-03-09 |
| | |||
* | 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` | ||
* | feat: add disable option for chart xAxis and yAxis | si9ma | 2021-05-27 |
| | |||
* | Support specifies that each data marker in the series has a different color | xuri | 2021-04-10 |
| | |||
* | 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 #756, not set the empty string for the cell when SetCellValue ↵ | xuri | 2021-01-08 |
| | | | | with nil | ||
* | This closes #657 and closes #748, AddChart support custom marker symbol and ↵ | xuri | 2020-12-14 |
| | | | | symbol size, fix AddPicture auto fit failure with multi merged cells | ||
* | support ECMA-376 document standard encryption, ref #199 | xuri | 2020-09-02 |
| | |||
* | Resolve #661 Add Logarithmic scale option support on Y axis (#662) | Huy Bui (Kevin) | 2020-07-11 |
| | | | | | | | | | | | | | | | | * Resolve #661 Add Logarithmic scale option support on Y axis Example usage: Add the following option into the format string when using AddChart: "y_axis":{"scaling":{"logbase":"10"}} * Change type of LogBase from attrValString to attrVarFloat * Add test case for testing Logarithmic Option in Y axis of charts * Move field `LogBase` in the format string up one level (remove `Scaling`) as suggested the owner Test cases are updated accordingly. | ||
* | Update docs and typo fixed | xuri | 2020-06-22 |
| | |||
* | Resolve #470, export Style structs to allow create the style for cells by ↵ | xuri | 2020-03-10 |
| | | | | given JSON or structure | ||
* | Make DeleteChart delete multiple charts located on the same cell | xuri | 2020-01-21 |
| | |||
* | Specified combo chart as variadic parameters | xuri | 2020-01-16 |
| | |||
* | Fix #554, init combo chart support, new chart pie of pie, bar of pie chart ↵ | xuri | 2020-01-14 |
| | | | | support | ||
* | Improve code coverage unit tests | xuri | 2019-12-29 |
| | |||
* | Fix #547 and #546, add default overlay element for the chart | xuri | 2019-12-28 |
| | |||
* | Fix #538, added setting a major unit and tick label skip support for the chart | xuri | 2019-12-25 |
| | |||
* | Improve compatibility, fix workbook's rels ID calc error | xuri | 2019-12-23 |
| | |||
* | Resolve #501, support set minor grid lines for the chart | xuri | 2019-10-27 |
| | |||
* | Fix #505, support set line width of the line chart | xuri | 2019-10-21 |
| | |||
* | Improve compatibility for charts | xuri | 2019-09-26 |
| | |||
* | Compatibility improvement | xuri | 2019-09-24 |
| | |||
* | Documentation updated, Go 1.10+ required | xuri | 2019-08-11 |
| | |||
* | Support to create bubble and 3D bubble chart | xuri | 2019-06-19 |
| | |||
* | Add surface 3D, wireframe Surface 3D, contour, and wireframe contour chart ↵ | xuri | 2019-06-15 |
| | | | | support | ||
* | support to create cone, pyramid and cylinder series chart for column and ↵ | xuri | 2019-06-14 |
| | | | | bar types | ||
* | Fix #424, refactor merged cells adjuster | xuri | 2019-06-12 |
| | |||
* | Fix #411, change font size to float type | xuri | 2019-06-07 |
| | |||
* | - Supplemental worksheet struct fields and field order adjustment | xuri | 2019-06-05 |
| | | | | | - Testing case for set and get doc properties - Update charts struct XML tags | ||
* | README updated | xuri | 2019-01-01 |
| | |||
* | Resolve #311, create 2D/3D area, stacked area, 100% stacked area chart support | xuri | 2018-12-23 |
| | |||
* | fix unknown option in JSON struct tag | tvso | 2018-10-27 |
| | |||
* | 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 |
| | |||
* | Use format string for chart dimension. | Eugene Dzhurinsky | 2018-05-09 |
| | | | | Signed-off-by: Eugene Dzhurinsky <jdevelop@gmail.com> | ||
* | - Add categories or values on reverse order (orientation of the chart) ↵ | Ri Xu | 2018-03-29 |
| | | | | | | support, and set auto or fixed maximum, minimum of the axis, relate issue #202; - go test and godoc has been updated | ||
* | Add stacked bar chart | Rohan Allison | 2017-11-24 |
| | |||
* | Golang 1.9 compatible, fix issue #111 | Ri Xu | 2017-09-01 |
| | |||
* | Simplify code and update unit tests. | Ri Xu | 2017-08-01 |
| |