summaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
* Stream writer support to set inline rich text cell (#1121)charles.deng2022-10-10
| | | Co-authored-by: zhengchao.deng <zhengchao.deng@meican.com>
* Support to set summary columns to appear to the right of detail in an outlinexuri2022-10-08
| | | | | | - Simplify calculation engine code - Update documentation for the functions - Update dependencies module
* This closes #1365, normalize the sheet name (#1366)Joseph Watson2022-10-07
| | | Signed-off-by: Joseph Watson <jtwatson@linux-consulting.us>
* 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 #1360, closes #1361xuri2022-09-28
| | | | | | | - Fix default number format parse issue with a long string of digits - Fix creating a sheet with an empty name cause a corrupted file - The `GetCellStyle` function no longer return master cell style of the merge cell range - Using the specialized name in variables and functions
* Fix cpu usage problem of stream writer when merging cells (#1359)Zitao2022-09-23
| | | Co-authored-by: zzt <zhangzitao@meican.com>
* This closes #1354, stream writer will apply style in `RowOpts` for each cell ↵invzhi2022-09-21
| | | | | (#1355) Co-authored-by: Tianzhi Jin <tianzhi.jin@iglooinsure.com>
* Using the specialized name in a variable and making comments clearxuri2022-09-18
| | | | - Add JSON tags for `AppProperties`, `PivotTableOption` and `PivotTableField` structure
* This closes #1345, support set custom line color in the charts (#1346)Artem Tarasenko2022-09-14
|
* This makes 6 functions concurrency safetyxuri2022-09-11
| | | | - These 6 functions now support concurrency safe: SetColWidth, GetColWidth, SetColVisible, GetColVisible, SetColStyle and GetColStyle
* Fix DeleteComment slice bounds out of range (#1343)dafengge09132022-09-10
|
* This closes #744, the `Save`, `Write` and `WriteTo` function accept saving ↵xuri2022-09-08
| | | | options
* This closes #1293, add new function `GetColStyle`xuri2022-09-07
| | | | | | - Fix generate workbook corruption after insert cols/rows in some case - Update unit tests - Update dependencies module
* Fix get image content was empty after inserting imagexuri2022-09-06
|
* This closes #1338, fix apply AM/PM format issuexuri2022-09-03
|
* This closes #1323, an error will be returned when set the not exist style IDxuri2022-09-01
|
* This is a breaking change closes #1332 (#1333)Kostya Privezentsev2022-08-31
| | | This use `InsertRows` instead of `InsertRow`, and using `InsertCols` instead of `InsertCol`
* This closes #1330 update non existing sheet error messages (#1331)davidborry2022-08-28
|
* This closes #827, add new functions `GetDataValidations` and ↵chenliu19932022-08-27
| | | | | `GetConditionalFormats` (#1315) Signed-off-by: chenliu1993 <13630583107@163.com>
* This closes #1247, add new function `SetSheetCol` for set worksheet column ↵Cooper de Nicola2022-08-25
| | | | | | values (#1320) Signed-off-by: cdenicola <cooper.denicola@instabase.com> Co-authored-by: cdenicola <cooper.denicola@instabase.com>
* 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 made library allowing insert EMZ and WMZ format imagexuri2022-08-21
| | | | - Update dependencies module
* Support encrypt workbook with password #199 (#1324)Sangua6332022-08-20
|
* 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
* This closes #1319, fix calculate error for formula with negative symbolxuri2022-08-17
| | | - Update unit test and comment for the functions
* This closes #1244 and closes #1314, improving the compatibility with Google ↵xuri2022-08-13
| | | | | | Sheet - Format code with `gofmt`
* This closes #1312, #1313, fix number format issuexuri2022-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
* This closes #1296, add new function `GetRowOpts` for stream reader (#1297)Thomas Charbonnel2022-08-11
| | | | - Support get rows properties by `GetRowOpts` function - New exported constant `MaxCellStyles`
* This reduces memory usage and speedup the `AddComment` function (#1311)EE2022-08-10
| | | By load only once for existing comment shapes, improving performance for adding comments in the worksheet
* Add new exported `ColorMappingType` used for color transformationxuri2022-08-06
| | | | Using `ColorMappingType` color transformation types enumeration for tab color index, ref #1285
* This closes #1299 skip write nil values in SetRow (#1301)Thomas Charbonnel2022-08-04
| | | Co-authored-by: Thomas Charbonnel <github@charbonnel.email>
* This closes #1298, fix doc properties missing after creating new worksheetxuri2022-08-03
|
* This closes #1283, support set and get color index, theme and tint for sheet tabThomas Charbonnel2022-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-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
* Optimizing line breaks for comments (#1281)Regan Yue2022-07-17
|
* Fix potential file corrupted when changing cell value or the col/rowxuri2022-07-16
| | | | | - Remove shared formula subsequent cell when setting the cell values - Support adjust table range when removing and inserting column/row
* adjust `ErrColumnNumber`, rename `TotalColumns` to `MaxColumns` and add new ↵MJacred2022-07-14
| | | | | constant `MinColumns` (#1272) Signed-off-by: Benjamin Lösch <loesch.benny92@gmx.de>
* This fix potential panic and file corruptedxuri2022-07-14
| | | | | | - Fix the panic when set or get sheet view options on the sheet without views options - Fix generated workbook corruption caused by empty created or modified dcterms in the document core properties - Update the unit tests
* This closes #1262, support for dependence formulas calculationxuri2022-07-10
| | | | | - Add export option `MaxCalcIterations` for specifies the maximum iterations for iterative calculation - Update unit test for the database formula functions
* This closes #1269, made the `NewStreamWriter` function case insensitive to ↵Eagle Xiang2022-07-06
| | | | | worksheet name Co-authored-by: xiangyz <xiangyz@dustess.com>
* ref #65, new formula function: DGETxuri2022-07-03
|
* ref #65, new formula functions: DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, and DVARPxuri2022-07-02
|
* Fix CONTRIBUTING doc typo issues (#1266)yeshu2022-07-02
|
* This closes #1264, fix can't modify cell content issue in some casesyeshu2022-07-01
| | | Remove inline rich text when setting cell value and cell formulas
* ref #65, new formula function: DAVERAGExuri2022-07-01
|
* ref #65, new formula functions: DMAX and DMINxuri2022-06-28
|
* This closes #1260, fixes compiling issue under 32-bit, and new formula functionsxuri2022-06-27
| | | | | | - ref #65, new formula functions: DCOUNT and DCOUNTA - support percentile symbol in condition criteria expression - this update dependencies module
* ref #65, new formula function: HYPERLINKxuri2022-06-24
|
* ref #65, new formula function: EUROCONVERTxuri2022-06-22
|
* This closes #1257, fix incorrect worksheet header footer fields orderxuri2022-06-21
|
generated by cgit v1.2.1 (git 2.18.0) at 2025-04-19 14:14:47 +0000