| Commit message (Collapse) | Author | Age | |
|---|---|---|---|
| * | Stream writer support to set inline rich text cell (#1121) | charles.deng | 2022-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 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 #827, add new functions `GetDataValidations` and ↵ | chenliu1993 | 2022-08-27 |
| | | | | | | `GetConditionalFormats` (#1315) Signed-off-by: chenliu1993 <13630583107@163.com> | ||
| * | 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 | ||
| * | This closes #1257, fix incorrect worksheet header footer fields order | xuri | 2022-06-21 |
| | | |||
| * | This includes new formula functions support, dependencies upgrade, and bug fix | xuri | 2022-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 | ||
| * | This closes #1196, fix the compatibility issue and added new formula function | xuri | 2022-04-05 |
| | | | | | ref #65, new formula functions: TINV and TTEST | ||
| * | This fix scientific notation and page setup fields parsing issue | xuri | 2022-03-18 |
| | | |||
| * | 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 | ||
| * | Support workbook views Showruler settings (#1138) | David | 2022-02-06 |
| | | |||
| * | This closes #1119, style parsing issue fixed | xuri | 2022-01-15 |
| | | |||
| * | Breaking change for data validation and fixed #1117 | xuri | 2022-01-12 |
| | | | | | | - Remove second useless parameter `isCurrentSheet` of the function `SetSqrefDropList` - Fix missing page setup of worksheet after re-saving the spreadsheet | ||
| * | Typo fix, rename exported constants, dependencies modules and copyright update | xuri | 2022-01-09 |
| | | | | | Rename exported constants `NameSpaceDublinCoreMetadataIntiative` to `NameSpaceDublinCoreMetadataInitiative` | ||
| * | feat: implement SHA-512 algorithm to ProtectSheet (#1115) | Jonham.Chen | 2022-01-08 |
| | | |||
| * | This closes #998 | xuri | 2021-09-05 |
| | | | | | | | | - 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` | ||
| * | Add set shared formula support and documentation for the `SetCellFormula` | xuri | 2021-09-03 |
| | | |||
| * | Speed up merge cells | three | 2021-08-13 |
| | | |||
| * | Fix data validation issues (#975) | Arnie97 | 2021-07-31 |
| | | | | | | | | | | | | | | | | | | | | | | | * Fix `SetDropList` to allow XML special characters * This closes #971, allow quotation marks in SetDropList() This patch included a XML entity mapping table instead of xml.EscapeText() to be fully compatible with Microsoft Excel. * This closes #972, allow more than 255 bytes of validation formulas This patch changed the string length calculation unit of data validation formulas from UTF-8 bytes to UTF-16 code units. * Add unit tests for SetDropList() * Fix: allow MaxFloat64 to be used in validation range 17 decimal significant digits should be more than enough to represent every IEEE-754 double-precision float number without losing precision, and numbers in this form will never reach the Excel limitation of 255 UTF-16 code units. | ||
| * | This closes #971, closes #972 and closes #974 | xuri | 2021-07-29 |
| | | | | | | | | | - Escape XML character in the drop list - Fix incorrect character count limit in the drop list - Fix Excel time parse issue in some case - Fix custom number format month parse issue in some case - Fix corrupted file generated caused by concurrency adding pictures | ||
| * | Improvement compatibility with invalid first-page number attribute in the ↵ | xuri | 2021-07-21 |
| | | | | | page layout | ||
| * | This closes #883, fix missing pivot attribute of conditional formatting | xuri | 2021-07-16 |
| | | |||
| * | fix the bug when there was no count attribute in sharedStrings file | william | 2021-05-24 |
| | | |||
| * | compatibility with non-standard page setup attributes | xuri | 2021-05-07 |
| | | |||
| * | 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 | ||
| * | Add support for setting hyperlink display & tooltip (closes #790) (#794) | James Allen | 2021-03-03 |
| | | |||
| * | support to set print black and white and specified the first printed page number | xuri | 2021-01-17 |
| | | |||
| * | Support to adjust print scaling of the worksheet | xuri | 2021-01-16 |
| | | |||
| * | Fix race conditions | xuri | 2020-11-04 |
| | | |||
| * | Compatibility improvement: parse document core part (workbook) dynamically | xuri | 2020-11-04 |
| | | |||
| * | optimize memory allocation (#722) | Ted | 2020-11-03 |
| | | | | | | | | | | | | | | | | * optimize marshal * optimize mem alloc * add benchmark testing * add NewSheetWithRowNum testing * sync struct fields order * add BenchmarkNewSheetWithStreamWriter * delete NewSheetWithRowNum and benchmark test | ||
| * | improve compatibility for phonetic hint and sheet tab color | xuri | 2020-09-03 |
| | | |||
| * | using Mutex lock and update benchmark | xuri | 2020-08-16 |
| | | |||
| * | Compatible with Go 1.15, fix unit test failed on Windows and fixed #689 ↵ | xuri | 2020-08-15 |
| | | | | | potential race condition | ||
| * | update docs and improve compatibility | xuri | 2020-07-11 |
| | | |||
| * | Update docs and typo fixed | xuri | 2020-06-22 |
| | | |||
| * | Resolve #451, support create chart sheet | xuri | 2020-03-28 |
| | | |||
| * | Resolve #492, init support for insert and remove page break | xuri | 2020-03-01 |
| | | |||
| * | Fix #578, escape character in the formula | xuri | 2020-02-15 |
| | | |||
| * | Resolve #570, flat columns for the column's operation | xuri | 2020-02-07 |
| | | |||
| * | Improve code coverage unit tests | xuri | 2019-12-29 |
| | | |||
| * | Fix #547 and #546, add default overlay element for the chart | xuri | 2019-12-28 |
| | | |||
| * | Improve compatibility, fix workbook's rels ID calc error | xuri | 2019-12-23 |
| | | |||
| * | Improve code coverage unit tests | xuri | 2019-12-22 |
| | | |||
| * | Update comments for the xmlNewDecoder (#542) | match-meng | 2019-12-20 |
| | | |||
| * | Fix #426, handle empty workbook view | xuri | 2019-12-16 |
| | | |||
| * | Fix #533, add support overlapped mergecells | xuri | 2019-12-14 |
| | | |||
 |
index : anyxcelize | |
| A fork of excelize to be able to write non-strings. |
| summaryrefslogtreecommitdiff |
path: root/xmlWorksheet.go