summaryrefslogtreecommitdiff
path: root/drawing.go
Commit message (Collapse)AuthorAge
* 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
* 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
* This closes #1369, support set, and get font color with theme and tint (#1370)GaoFei2022-10-15
|
* This closes #320, support custom chart axis font stylexuri2022-10-14
|
* This closes #1368, fixes number parsing issue, adds support for create a 3D ↵xuri2022-10-12
| | | | line chart
* 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 #1345, support set custom line color in the charts (#1346)Artem Tarasenko2022-09-14
|
* This closes #1290 and closes #1328xuri2022-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 closes #849, add new function `DeleteComment` for delete comment (#1317)NaturalGao2022-08-19
| | | | - Update unit tests for the delete comment - Add 3 errors function for error messages
* 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
* 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>
* This includes new formula functions support, dependencies upgrade, and bug fixxuri2022-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
* Format code, update documentation and remove exported variable `XMLHeaderByte`xuri2022-03-24
|
* ref #65, new formula functions: GAMMA.INV and GAMMAINV and format codexuri2022-03-12
|
* This closes #1172, support set hole size for doughnut (#1173)longphee2022-03-09
|
* 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`
* Typo fix, rename exported constants, dependencies modules and copyright updatexuri2022-01-09
| | | | Rename exported constants `NameSpaceDublinCoreMetadataIntiative` to `NameSpaceDublinCoreMetadataInitiative`
* 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`
* feat: add disable option for chart xAxis and yAxissi9ma2021-05-27
|
* fixed the negative values series missing chart color, #65 fn: CUMIPMT and ↵xuri2021-04-11
| | | | CUMPRINC
* Support specifies that each data marker in the series has a different colorxuri2021-04-10
|
* 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
* This closes #785, support to change tab color; new formula function: FISHER, ↵xuri2021-02-16
| | | | FISHERINV, GAMMA, GAMMALN, MIN, MINA, PERMUT
* lint issue fixed and new formula function: ATAN, AVERAGE, AVERAGEA, CONCAT, ↵xuri2021-02-15
| | | | CONCATENATE, COUNT, COUNTBLANK, MAX
* This closes #756, not set the empty string for the cell when SetCellValue ↵xuri2021-01-08
| | | | with nil
* AddChart support disable legend of the chartxuri2020-12-27
|
* This closes #657 and closes #748, AddChart support custom marker symbol and ↵xuri2020-12-14
| | | | symbol size, fix AddPicture auto fit failure with multi merged cells
* Fix #724, standardize variable naming and update unit testsxuri2020-11-11
|
* Fix #706, #713 improve AddPicture performance, fix missing worksheet when ↵xuri2020-10-18
| | | | rename with same names
* - Resolve #627, improve multi-series line chart compatibility with KingSoft WPSxuri2020-10-11
| | | | | | - Avoid to create duplicate style - Update unit test for the auto filter - Init code scanning alerts
* support ECMA-376 document standard encryption, ref #199xuri2020-09-02
|
* Default row height compatibility with Apache OpenOffice and Kingsoft WPS, ↵xuri2020-08-22
| | | | unit test update and typo fixed
* support parse and generate XML element namespace dynamic, fix #651xuri2020-07-18
|
* update docs and improve compatibilityxuri2020-07-11
|
* 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 fixedxuri2020-06-22
|
* Replace bytes.NewReader(stringToBytes(s)) with strings.NewReader(s) (#610)Olivier Mengué2020-04-09
|
* Performance improvementsxuri2020-04-05
|
* Resolve #345, fix missing comments by GetCommentsxuri2020-03-31
|
* remove ineffectual variable assignments and simplify codexuri2020-03-29
|
* Resolve #451, support create chart sheetxuri2020-03-28
|
* Resolve #455, init delete picture from spreadsheet supportxuri2020-01-22
|
* Make DeleteChart delete multiple charts located on the same cellxuri2020-01-21
|
* Resolve #557, init delete chart supportxuri2020-01-19
generated by cgit v1.2.1 (git 2.18.0) at 2025-04-16 14:43:23 +0000