1. 08 10月, 2022 1 次提交
  2. 29 9月, 2022 1 次提交
    • xurime's avatar
      This closes #1358, made a refactor with breaking changes, see details: · 53a49556
      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
      53a49556
  3. 27 8月, 2022 1 次提交
  4. 13 8月, 2022 1 次提交
  5. 18 7月, 2022 1 次提交
  6. 21 6月, 2022 1 次提交
  7. 11 4月, 2022 1 次提交
  8. 05 4月, 2022 1 次提交
  9. 18 3月, 2022 1 次提交
  10. 05 3月, 2022 1 次提交
  11. 17 2月, 2022 1 次提交
    • xurime's avatar
      This closes #1148, resolve limitations when adding VBA project to the workbook · f87c39c4
      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
      f87c39c4
  12. 06 2月, 2022 1 次提交
  13. 15 1月, 2022 1 次提交
  14. 12 1月, 2022 1 次提交
  15. 09 1月, 2022 1 次提交
  16. 08 1月, 2022 1 次提交
  17. 05 9月, 2021 1 次提交
    • xurime's avatar
      This closes #998 · 32b23ef4
      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`
      32b23ef4
  18. 03 9月, 2021 1 次提交
  19. 13 8月, 2021 1 次提交
  20. 31 7月, 2021 1 次提交
    • A
      Fix data validation issues (#975) · 7ac37edf
      Arnie97 提交于
      * 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.
      7ac37edf
  21. 29 7月, 2021 1 次提交
    • xurime's avatar
      This closes #971, closes #972 and closes #974 · 7dbf88f2
      xurime 提交于
      - 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
      7dbf88f2
  22. 21 7月, 2021 1 次提交
  23. 16 7月, 2021 1 次提交
  24. 24 5月, 2021 1 次提交
  25. 07 5月, 2021 1 次提交
  26. 04 4月, 2021 1 次提交
  27. 30 3月, 2021 1 次提交
  28. 03 3月, 2021 1 次提交
  29. 17 1月, 2021 1 次提交
  30. 16 1月, 2021 1 次提交
  31. 04 11月, 2020 2 次提交
  32. 03 11月, 2020 1 次提交
    • T
      optimize memory allocation (#722) · fcca8a38
      Ted 提交于
      * optimize marshal
      
      * optimize mem alloc
      
      * add benchmark testing
      
      * add NewSheetWithRowNum testing
      
      * sync struct fields order
      
      * add BenchmarkNewSheetWithStreamWriter
      
      * delete NewSheetWithRowNum and benchmark test
      fcca8a38
  33. 03 9月, 2020 1 次提交
  34. 16 8月, 2020 1 次提交
  35. 15 8月, 2020 1 次提交
  36. 11 7月, 2020 1 次提交
  37. 22 6月, 2020 1 次提交
  38. 28 3月, 2020 1 次提交
  39. 01 3月, 2020 1 次提交