- 03 4月, 2024 1 次提交
-
-
由 xurime 提交于
This closes #1867, breaking changes: change the data type for the ConditionalFormatOptions structure field Format as a pointer
-
- 15 3月, 2024 1 次提交
-
-
由 铁面无情哈士奇 提交于
Co-authored-by: Nchun.zhang2 <chun.zhang2@geely.com> - This fix speed slowdown and memory usage increase base on the reverts commit 6220a798 - Fix panic on read workbook with internal row element without r attribute - Update the unit tests
-
- 06 3月, 2024 1 次提交
-
-
由 Evan lu 提交于
-
- 18 1月, 2024 1 次提交
-
-
由 微普拉斯 提交于
- Initial formula array calculation support - Update unit test and documentation
-
- 09 1月, 2024 1 次提交
-
-
由 xurime 提交于
This closes #1777, fix the GetStyle or GetConditionalStyle function to returns incorrect DecimalPlaces field value - Update documentation for the NewStyle function - Update unit tests - Update dependencies Go module - Update GitHub workflow dependencies package version - Update copyright agreement statement
-
- 28 12月, 2023 1 次提交
-
-
由 xurime 提交于
- Update the unit tests
-
- 18 11月, 2023 1 次提交
-
-
由 lujin 提交于
- Fix panic on read workbook with internal row element without r attribute - Check worksheet XML before get all cell value by column or row - Update the unit tests
-
- 11 11月, 2023 1 次提交
-
-
由 xurime 提交于
-
- 16 9月, 2023 1 次提交
-
-
由 xurime 提交于
- Fix a v2.8.0 regression bug, generate workbook corruption caused by incorrect MRU colors style parts - Fix corrupted workbooks generated when adding tables in some cases - Added several exported extension list child element URI constants - Move part of the internal constant and variables definition to the template source code file - Updated unit tests
-
- 09 9月, 2023 1 次提交
-
-
由 xurime 提交于
- Breaking changes, change the data type for the `HeaderFooterOptions` structure fields `AlignWithMargins` and `ScaleWithDoc` as a pointer - Fixed panic on `AutoFilter` by adding nil pointer guard for local sheet ID - Allow dot character in the defined name, table name, or pivot table name - Update the unit tests
-
- 08 6月, 2023 1 次提交
-
-
由 vb6iscool 提交于
- Breaking changes: rename exported type `PaneOptions` to `Selection` - Update unit tests - Upgrade dependencies package - Add internal error variables - Simplify variable declarations
-
- 30 5月, 2023 1 次提交
-
-
由 xurime 提交于
- Simplify and remove duplicate code for optimization - Update documentation comments with typo fix - Handle error return to save the workbook - Add file path length limitation details in the error message
-
- 24 4月, 2023 1 次提交
-
-
由 xurime 提交于
-
- 19 4月, 2023 1 次提交
-
-
由 xurime 提交于
- Simplify variable declaration and error return statements - Remove the internal `xlsxTabColor` data type - Using the `xlsxColor` data type instead of `xlsxTabColor` - Update unit test, improve code coverage
-
- 22 2月, 2023 1 次提交
-
-
由 xurime 提交于
- Remove Minimum, Maximum, MinLength, and MaxLength fields from the type `ConditionalFormatOptions` - Update unit tests and format code
-
- 13 2月, 2023 1 次提交
-
-
由 xurime 提交于
- XML Structure field typo fixed - Update documentation for the `AddChart` function - Update unit test
-
- 08 2月, 2023 1 次提交
-
-
由 xurime 提交于
- Improvement compatibility for the worksheet extension lists - Update unit test
-
- 07 2月, 2023 1 次提交
-
-
由 xurime 提交于
- Support creating a conditional format with a "stop if true" rule - Support set border color and create solid color for the color data bar - Fix incorrect cell type when modifying string cell with the time number - Update unit test for the add pivot table to avoid pivot table range overlap
-
- 03 2月, 2023 1 次提交
-
-
由 xurime 提交于
- Increase max cell styles to 65430 - Add new exported error variable `ErrCellStyles` - Update unit tests, support test under Go 1.20.x
-
- 02 1月, 2023 1 次提交
-
-
由 xurime 提交于
- Update example code in the documentation - Update unit tests - Rename `PictureOptions` to `GraphicOptions` - Adjust partial options fields data types for the `PictureOptions` and `Shape` structure - Update dependencies module
-
- 30 12月, 2022 1 次提交
-
-
由 xurime 提交于
* Change `func (f *File) NewConditionalStyle(style string) (int, error)` to `func (f *File) NewConditionalStyle(style *Style) (int, error)` * Change `func (f *File) NewStyle(style interface{}) (int, error)` to `func (f *File) NewStyle(style *Style) (int, error)` * Change `func (f *File) AddChart(sheet, cell, opts string, combo ...string) error` to `func (f *File) AddChart(sheet, cell string, chart *ChartOptions, combo ...*ChartOptions) error` * Change `func (f *File) AddChartSheet(sheet, opts string, combo ...string) error` to `func (f *File) AddChartSheet(sheet string, chart *ChartOptions, combo ...*ChartOptions) error` * Change `func (f *File) AddShape(sheet, cell, opts string) error` to `func (f *File) AddShape(sheet, cell string, opts *Shape) error` * Change `func (f *File) AddPictureFromBytes(sheet, cell, opts, name, extension string, file []byte) error` to `func (f *File) AddPictureFromBytes(sheet, cell, name, extension string, file []byte, opts *PictureOptions) error` * Change `func (f *File) AddTable(sheet, hCell, vCell, opts string) error` to `func (f *File) AddTable(sheet, reference string, opts *TableOptions) error` * Change `func (sw *StreamWriter) AddTable(hCell, vCell, opts string) error` to `func (sw *StreamWriter) AddTable(reference string, opts *TableOptions) error` * Change `func (f *File) AutoFilter(sheet, hCell, vCell, opts string) error` to `func (f *File) AutoFilter(sheet, reference string, opts *AutoFilterOptions) error` * Change `func (f *File) SetPanes(sheet, panes string) error` to `func (f *File) SetPanes(sheet string, panes *Panes) error` * Change `func (sw *StreamWriter) AddTable(hCell, vCell, opts string) error` to `func (sw *StreamWriter) AddTable(reference string, opts *TableOptions) error` * Change `func (f *File) SetConditionalFormat(sheet, reference, opts string) error` to `func (f *File) SetConditionalFormat(sheet, reference string, opts []ConditionalFormatOptions) error` * Add exported types: * AutoFilterListOptions * AutoFilterOptions * Chart * ChartAxis * ChartDimension * ChartLegend * ChartLine * ChartMarker * ChartPlotArea * ChartSeries * ChartTitle * ConditionalFormatOptions * PaneOptions * Panes * PictureOptions * Shape * ShapeColor * ShapeLine * ShapeParagraph * TableOptions * This added support for set sheet visible as very hidden * Return error when missing required parameters for set defined name * Update unit test and comments
-
- 16 11月, 2022 1 次提交
-
-
由 renxiaotu 提交于
-
- 10 10月, 2022 1 次提交
-
-
由 charles.deng 提交于
Co-authored-by: Nzhengchao.deng <zhengchao.deng@meican.com>
-
- 08 10月, 2022 1 次提交
-
-
由 xurime 提交于
- Simplify calculation engine code - Update documentation for the functions - Update dependencies module
-
- 29 9月, 2022 1 次提交
-
-
由 xurime 提交于
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
-
- 27 8月, 2022 1 次提交
-
-
由 johnnihao 提交于
Signed-off-by: chenliu1993 <13630583107@163.com>
-
- 13 8月, 2022 1 次提交
-
-
由 xurime 提交于
- Format code with `gofmt`
-
- 18 7月, 2022 1 次提交
-
-
由 xurime 提交于
- 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
-
- 21 6月, 2022 1 次提交
-
-
由 xurime 提交于
-
- 11 4月, 2022 1 次提交
-
-
由 xurime 提交于
- 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
-
- 05 4月, 2022 1 次提交
-
-
由 xurime 提交于
ref #65, new formula functions: TINV and TTEST
-
- 18 3月, 2022 1 次提交
-
-
由 xurime 提交于
-
- 05 3月, 2022 1 次提交
-
-
由 xurime 提交于
Preserve alternate content in the workbook, worksheet, and drawingML
-
- 17 2月, 2022 1 次提交
-
-
由 xurime 提交于
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
-
- 06 2月, 2022 1 次提交
-
-
由 David 提交于
-
- 15 1月, 2022 1 次提交
-
-
由 xurime 提交于
-
- 12 1月, 2022 1 次提交
-
-
由 xurime 提交于
- Remove second useless parameter `isCurrentSheet` of the function `SetSqrefDropList` - Fix missing page setup of worksheet after re-saving the spreadsheet
-
- 09 1月, 2022 1 次提交
-
-
由 xurime 提交于
Rename exported constants `NameSpaceDublinCoreMetadataIntiative` to `NameSpaceDublinCoreMetadataInitiative`
-
- 08 1月, 2022 1 次提交
-
-
由 Jonham_Chen 提交于
-
- 05 9月, 2021 1 次提交
-
-
由 xurime 提交于
- Support text comparison in the formula, also ref #65 - `GetCellValue`, `GetRows`, `GetCols`, `Rows` and `Cols` support to specify read cell with raw value, ref #621 - Add missing properties for the cell formula - Update the unit test for the `CalcCellValue`
-