Commit message (Collapse) | Author | Age | |
---|---|---|---|
* | This closes #1204, breaking changes for add comments | xuri | 2022-11-02 |
| | | | | | - Allowing insert SVG format images - Unit tests updated | ||
* | 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 | ||
* | 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 | ||
* | This closes #320, support custom chart axis font style | xuri | 2022-10-14 |
| | |||
* | 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 #744, the `Save`, `Write` and `WriteTo` function accept saving ↵ | xuri | 2022-09-08 |
| | | | | options | ||
* | This made library allowing insert EMZ and WMZ format image | xuri | 2022-08-21 |
| | | | | - Update dependencies module | ||
* | This closes #1296, add new function `GetRowOpts` for stream reader (#1297) | Thomas Charbonnel | 2022-08-11 |
| | | | | - Support get rows properties by `GetRowOpts` function - New exported constant `MaxCellStyles` | ||
* | Add new exported `ColorMappingType` used for color transformation | xuri | 2022-08-06 |
| | | | | Using `ColorMappingType` color transformation types enumeration for tab color index, ref #1285 | ||
* | adjust `ErrColumnNumber`, rename `TotalColumns` to `MaxColumns` and add new ↵ | MJacred | 2022-07-14 |
| | | | | | constant `MinColumns` (#1272) Signed-off-by: Benjamin Lösch <loesch.benny92@gmx.de> | ||
* | This fix formula calculation accuracy issue and panic when set pane | xuri | 2022-05-23 |
| | | | | | - Fix `GROWTH` and `TREND` calculation accuracy issue - Fix panic when add pane on empty sheet views worksheet - New exported constants `MinFontSize` | ||
* | This closes #1229, rename ErrMaxFileNameLength to ErrMaxFilePathLength (#1230) | sceneq | 2022-05-16 |
| | | | Co-authored-by: sceneq | ||
* | This made library allowing insert WMF format image | xuri | 2022-05-14 |
| | |||
* | This closes #1225, allowing insert EMF format images | xuri | 2022-05-13 |
| | |||
* | added macro functionality to shape (#1182) | David | 2022-04-15 |
| | |||
* | This closes #1162, improve the compatibility with alternate content | xuri | 2022-03-05 |
| | | | | Preserve alternate content in the workbook, worksheet, and drawingML | ||
* | 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 | ||
* | Fix file corrupted in some cases, check file extension and format code | xuri | 2022-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 update | xuri | 2022-01-09 |
| | | | | Rename exported constants `NameSpaceDublinCoreMetadataIntiative` to `NameSpaceDublinCoreMetadataInitiative` | ||
* | 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 | ||
* | This closes #1095, support to set and get document application properties | xuri | 2021-12-26 |
| | |||
* | 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 #262, support set line width of add the shape | xuri | 2021-09-08 |
| | |||
* | 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 | ||
* | Support concurrency add picture | xuri | 2021-07-06 |
| | |||
* | Fixe issue generated file corrupted caused by incorrect default XML ↵ | xuri | 2021-04-30 |
| | | | | namespace attributes | ||
* | 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 #804, fixes can't add timelines and slicers for a pivot table in ↵ | xuri | 2021-03-15 |
| | | | | generated spreadsheet | ||
* | Compatibility improvement: parse document core part (workbook) dynamically | xuri | 2020-11-04 |
| | |||
* | add checking and limits for the worksheet | xuri | 2020-09-18 |
| | |||
* | Default row height compatibility with Apache OpenOffice and Kingsoft WPS, ↵ | xuri | 2020-08-22 |
| | | | | unit test update and typo fixed | ||
* | Update test for addTable | xuri | 2020-07-19 |
| | |||
* | support parse and generate XML element namespace dynamic, fix #651 | xuri | 2020-07-18 |
| | |||
* | Update docs and typo fixed | xuri | 2020-06-22 |
| | |||
* | add limits for total columns, row and filename length | xuri | 2020-05-29 |
| | |||
* | Merge pull request #410 | xuri | 2020-05-17 |
| | |||
* | handle the cell without r attribute in a row element | xuri | 2020-04-24 |
| | |||
* | Resolve #172, init rich text support | xuri | 2020-04-06 |
| | |||
* | Resolve #451, support create chart sheet | xuri | 2020-03-28 |
| | |||
* | Resolve #470, export Style structs to allow create the style for cells by ↵ | xuri | 2020-03-10 |
| | | | | given JSON or structure | ||
* | Improve code coverage unit tests | xuri | 2019-12-29 |
| | |||
* | Resolve #511, allow empty columns in the pivot table | xuri | 2019-10-24 |
| | |||
* | Combine functions: | xuri | 2019-09-16 |
| | | | | | | workBookRelsWriter, drawingRelsWriter into relsWriter; drawingRelsReader, workbookRelsReader, workSheetRelsReader into relsReader; addDrawingRelationships, addSheetRelationships into addRels | ||
* | Documentation updated, Go 1.10+ required | xuri | 2019-08-11 |
| | |||
* | New feature: sparkline supported | xuri | 2019-08-04 |
| | |||
* | Add extensions URI of spreadsheetML | xuri | 2019-07-31 |
| | |||
* | Resolve #217, new function add VBA project supported. | xuri | 2019-07-21 |
| | |||
* | Add TIF, TIFF format images and more detailed error information when open ↵ | xuri | 2019-06-27 |
| | | | | the encrypted file | ||
* | - 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 |