1. 09 1月, 2024 1 次提交
    • xurime's avatar
      This closes #1777, fix the GetStyle or GetConditionalStyle function to returns... · 79265655
      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
      79265655
  2. 25 12月, 2023 1 次提交
  3. 14 12月, 2023 1 次提交
    • Y
      This closes # 1704, support set the data labels position for the chart (#1755) · dfaf418f
      yuegu520 提交于
      - Breaking change: remove the Sizes field in the ChartSeries data type
      - Add new field DataLabelPosition in the ChartSeries data type, support to sets the position of the chart series data label
      - Add new field BubbleSize in the Chart data type, support set the bubble size in all data series for the bubble chart or 3D bubble chart
      - Add new exported ChartDataLabelPositionType data type
      - Update docs and unit test for the AddChart function
      - Fix a v2.7.1 regression bug, the bubble is hidden in the bubble or 3D bubble chart, commit ID: c2d6707a
      dfaf418f
  4. 03 11月, 2023 1 次提交
    • xurime's avatar
      This closes #1706 and closes #1708 · 4e936daf
      xurime 提交于
      - Add export ChartLineType enumeration to specify the chart line type
      - Add new Border field in the Chart type to set the chart area border
      - Add new Type field in the ChartLine type to set the line type
      - Fix some format missing on get style definition
      - Update the unit tests
      4e936daf
  5. 09 10月, 2023 1 次提交
  6. 21 9月, 2023 1 次提交
    • xurime's avatar
      This fix #1665, supports getting formula string cell value · 9c079e5e
      xurime 提交于
      - Improve compatibility for absolute path drawing part
      - Fix incorrect table ID generated in the workbook which contains single table cells
      - Fix missing relationship parts in the content types in some cases
      - Upgrade number format parser to fix missing literal tokens in some cases
      - Update built-in zh-cn and zh-tw language number format
      - Ref #65, init new formula function: TEXT
      - Remove duplicate style-related variables
      - Update the unit tests
      9c079e5e
  7. 16 9月, 2023 1 次提交
    • xurime's avatar
      Introduce the new exported function `AddSlicer` for adding table slicer · e3b7dad6
      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
      e3b7dad6
  8. 09 8月, 2023 1 次提交
  9. 28 7月, 2023 1 次提交
    • xurime's avatar
      This closes #1588, closes #1591, breaking changes for the `AddChart` function · a07c8cd0
      xurime 提交于
      - Removed exported `ChartTitle` data type
      - The `AddChart` function now supports formatting and setting rich text titles for the chart
      - New exported function `GetFormControl` for getting form control
      - Made case in-sensitive for internal worksheet XML path to improve compatibility
      - Update the unit tests
      - Update the documentation and internal comments on the codes
      a07c8cd0
  10. 07 7月, 2023 1 次提交
  11. 18 6月, 2023 1 次提交
  12. 14 6月, 2023 1 次提交
  13. 24 4月, 2023 1 次提交
  14. 01 4月, 2023 1 次提交
  15. 18 3月, 2023 1 次提交
  16. 19 2月, 2023 1 次提交
  17. 17 2月, 2023 1 次提交
  18. 02 1月, 2023 1 次提交
    • xurime's avatar
      This fixed worksheet protection issue · b39626fa
      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
      b39626fa
  19. 30 12月, 2022 1 次提交
    • xurime's avatar
      Breaking change: changed the function signature for 11 exported functions · f58dabd4
      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
      f58dabd4
  20. 12 11月, 2022 1 次提交
  21. 28 10月, 2022 1 次提交
    • xurime's avatar
      Fix the error on getting the range of merged cells on the worksheet which... · a410b22b
      xurime 提交于
      Fix the error on getting the range of merged cells on the worksheet which contains one cell merged cell range
      
      - Parse workbook default theme for custom theme color support in the feature
      - Variables name typo fix
      - Add system foreground and background color as RGB in the IndexedColorMapping list
      a410b22b
  22. 15 10月, 2022 1 次提交
  23. 14 10月, 2022 1 次提交
  24. 12 10月, 2022 1 次提交
  25. 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
  26. 14 9月, 2022 1 次提交
  27. 24 8月, 2022 1 次提交
    • xurime's avatar
      This closes #1290 and closes #1328 · cb8bca0e
      xurime 提交于
      - 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
      cb8bca0e
  28. 19 8月, 2022 1 次提交
  29. 18 7月, 2022 1 次提交
  30. 12 6月, 2022 1 次提交
  31. 11 4月, 2022 1 次提交
  32. 24 3月, 2022 1 次提交
  33. 12 3月, 2022 1 次提交
  34. 09 3月, 2022 1 次提交
  35. 05 3月, 2022 1 次提交
  36. 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
  37. 23 1月, 2022 1 次提交
  38. 09 1月, 2022 1 次提交
  39. 06 7月, 2021 1 次提交
  40. 05 7月, 2021 1 次提交