| Commit message (Collapse) | Author | Age | |
|---|---|---|---|
| * | Remove internal error log print, throw XML deserialize error | xuri | 2022-11-13 |
| | | |||
| * | Support to set summary columns to appear to the right of detail in an outline | xuri | 2022-10-08 |
| | | | | | | | - Simplify calculation engine code - Update documentation for the functions - Update dependencies module | ||
| * | 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 #1360, closes #1361 | xuri | 2022-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 | ||
| * | Using the specialized name in a variable and making comments clear | xuri | 2022-09-18 |
| | | | | | - Add JSON tags for `AppProperties`, `PivotTableOption` and `PivotTableField` structure | ||
| * | This closes #1330 update non existing sheet error messages (#1331) | davidborry | 2022-08-28 |
| | | |||
| * | This closes #1244 and closes #1314, improving the compatibility with Google ↵ | xuri | 2022-08-13 |
| | | | | | | | Sheet - Format code with `gofmt` | ||
| * | Fix potential file corrupted and change worksheet name case-insensitive | xuri | 2022-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 Jun | 2022-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> | ||
| * | Improves the calculation engine, docs update, and adds the dependabot | xuri | 2022-05-26 |
| | | | | | | | - Initialize array formula support for the formula calculation engine - Update example and unit test of `AddPivotTable` - Update the supported hash algorithm of ProtectSheet | ||
| * | This closes #1203, supporting same field used for pivot table data and rows/cols | xuri | 2022-04-19 |
| | | |||
| * | Format code, update documentation and remove exported variable `XMLHeaderByte` | xuri | 2022-03-24 |
| | | |||
| * | 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 | ||
| * | Ref: #660, #764, #1093, #1112, #1133 This improve number format support | xuri | 2022-02-13 |
| | | | | | | | - Introduced NFP (number format parser) dependencies module - Initialize custom dates and times number format support - Dependencies module upgraded | ||
| * | Typo fix, rename exported constants, dependencies modules and copyright update | xuri | 2022-01-09 |
| | | | | | Rename exported constants `NameSpaceDublinCoreMetadataIntiative` to `NameSpaceDublinCoreMetadataInitiative` | ||
| * | 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 #1029, support specify compact and outline for the pivot table | xuri | 2021-10-11 |
| | | |||
| * | Speed up merge cells | three | 2021-08-13 |
| | | |||
| * | This closes #979, fix the data validation deletion issue and tidy the ↵ | xuri | 2021-08-06 |
| | | | | | internal function in the source code | ||
| * | change go module import path to github.com/xuri/excelize | xuri | 2021-07-28 |
| | | |||
| * | - Support concurrency iterate rows and columns | xuri | 2021-07-05 |
| | | | | | | - Rename exported field `File.XLSX` to `File.Pkg` - Exported error message | ||
| * | This closes #866, support use the defined name to reference the data range ↵ | xuri | 2021-06-29 |
| | | | | | | | | in pivot table options - Fix incorrect scope when getting defined name - Update docs: use column number instead of index on get column width | ||
| * | 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 | ||
| * | support ShowError option in Pivot table (#802) | jinhyuk-kim-ca | 2021-03-13 |
| | | |||
| * | lint issue fixed and new formula function: ATAN, AVERAGE, AVERAGEA, CONCAT, ↵ | xuri | 2021-02-15 |
| | | | | | CONCATENATE, COUNT, COUNTBLANK, MAX | ||
| * | new formula func CLEAN and TRIM, change import path to v2 (#747) | Zhang Zhipeng | 2020-12-14 |
| | | |||
| * | using POSIX directory separator in zip path with Windows | xuri | 2020-11-06 |
| | | |||
| * | Compatibility improvement: parse document core part (workbook) dynamically | xuri | 2020-11-04 |
| | | |||
| * | fix pivot fails in case of multi columns and multi data | Ludovic Braconnier | 2020-09-30 |
| | | |||
| * | Pivot table generation fails when no Columns and multiple Data are provided. ↵ | jinhyuk-kim-ca | 2020-09-27 |
| | | | | | | | | | (#708) fix to create pivot table in case there is no input from Columns Co-authored-by: Jin Kim <jinhyuk.kim@cerence.com> Co-authored-by: xuri <xuri.me@gmail.com> | ||
| * | Update docs and test case for the pivot table | xuri | 2020-09-15 |
| | | |||
| * | Extend pivot table funtionality (#692) | Eugene Androsov | 2020-09-11 |
| | | | | | | Add different pivot options Add header options to pivot table opts Add Style name options to pivot table opts | ||
| * | Update docs and typo fixed | xuri | 2020-06-22 |
| | | |||
| * | - Resolve #611, fix failure BenchmarkSetCellValue | xuri | 2020-04-10 |
| | | | | | | - Allow empty filter, data, and rows in the pivot table - Add more test case for pivot table | ||
| * | Resolve #598, filter support for AddPivotTable | xuri | 2020-04-09 |
| | | |||
| * | AddPivotTable API changed: new structure PivotTableField to hold pivot table ↵ | xuri | 2020-02-26 |
| | | | | | fields for better scalability | ||
| * | Resolve #582, support to set date field subtotal and names for pivot table | xuri | 2020-02-21 |
| | | | | | - typo fixed and update do.dev badge in the README. | ||
| * | Resolve #580, revert commit ↵ | xuri | 2020-02-19 |
| | | | | | https://github.com/360EntSecGroup-Skylar/excelize/commit/5ca7231ed408ac264f509ff52b5d28ff4fbda757 | ||
| * | Fix #551, handle empty rows in streaming reading | xuri | 2019-12-31 |
| | | |||
| * | Improve code coverage unit tests | xuri | 2019-12-29 |
| | | |||
| * | Resolve #511, allow empty columns in the pivot table | xuri | 2019-10-24 |
| | | |||
| * | Resolve #40, init pivot table support | xuri | 2019-09-20 |
 |
index : anyxcelize | |
| A fork of excelize to be able to write non-strings. |
| summaryrefslogtreecommitdiff |
path: root/pivotTable.go