1. 06 3月, 2024 1 次提交
  2. 18 1月, 2024 1 次提交
  3. 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
  4. 11 11月, 2023 1 次提交
  5. 10 11月, 2023 1 次提交
  6. 09 11月, 2023 1 次提交
  7. 29 3月, 2023 1 次提交
  8. 25 3月, 2023 1 次提交
    • xurime's avatar
      Breaking changes: changed the function signature for 4 exported functions · 60b9d029
      xurime 提交于
      - Change
          `func (f *File) AddVBAProject(bin string) error`
          to
          `func (f *File) AddVBAProject(file []byte) error`
      - Change
          `func (f *File) GetComments() (map[string][]Comment, error)`
          to
          `func (f *File) GetComments(sheet string) ([]Comment, error)`
      - Change
          `func (f *File) AddTable(sheet, rangeRef string, opts *TableOptions) error`
          to
          `func (f *File) AddTable(sheet string, table *Table) error`
      - Change
          `func (sw *StreamWriter) AddTable(rangeRef string, opts *TableOptions) error`
          to
          `func (sw *StreamWriter) AddTable(table *Table) error`
      - Rename exported data type `TableOptions` to `Table`
      - Simplify the assert statements in the unit tests
      - Update documents for the functions
      - Update unit tests
      60b9d029
  9. 01 3月, 2023 1 次提交
  10. 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
  11. 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
  12. 23 12月, 2022 1 次提交
    • guoweikuang's avatar
      This closes #1425, breaking changes for sheet name (#1426) · 6a5ee811
      guoweikuang 提交于
      - Checking and return error for invalid sheet name instead of trim invalid characters
      - Add error return for the 4 functions: `DeleteSheet`, `GetSheetIndex`, `GetSheetVisible` and `SetSheetName`
      - Export new error 4 constants: `ErrSheetNameBlank`, `ErrSheetNameInvalid`, `ErrSheetNameLength` and `ErrSheetNameSingleQuote`
      - Rename exported error constant `ErrExistsWorksheet` to `ErrExistsSheet`
      - Update unit tests for 90 functions: `AddChart`,  `AddChartSheet`, `AddComment`, `AddDataValidation`, `AddPicture`, `AddPictureFromBytes`, `AddPivotTable`, `AddShape`, `AddSparkline`, `AddTable`, `AutoFilter`, `CalcCellValue`, `Cols`, `DeleteChart`, `DeleteComment`, `DeleteDataValidation`, `DeletePicture`, `DeleteSheet`, `DuplicateRow`, `DuplicateRowTo`, `GetCellFormula`, `GetCellHyperLink`, `GetCellRichText`, `GetCellStyle`, `GetCellType`, `GetCellValue`, `GetColOutlineLevel`, `GetCols`, `GetColStyle`, `GetColVisible`, `GetColWidth`, `GetConditionalFormats`, `GetDataValidations`, `GetMergeCells`, `GetPageLayout`, `GetPageMargins`, `GetPicture`, `GetRowHeight`, `GetRowOutlineLevel`, `GetRows`, `GetRowVisible`, `GetSheetIndex`, `GetSheetProps`, `GetSheetVisible`, `GroupSheets`, `InsertCol`, `InsertPageBreak`, `InsertRows`, `MergeCell`, `NewSheet`, `NewStreamWriter`, `ProtectSheet`, `RemoveCol`, `RemovePageBreak`, `RemoveRow`, `Rows`, `SearchSheet`, `SetCellBool`, `SetCellDefault`, `SetCellFloat`, `SetCellFormula`, `SetCellHyperLink`, `SetCellInt`, `SetCellRichText`, `SetCellStr`, `SetCellStyle`, `SetCellValue`, `SetColOutlineLevel`, `SetColStyle`, `SetColVisible`, `SetColWidth`, `SetConditionalFormat`, `SetHeaderFooter`, `SetPageLayout`, `SetPageMargins`, `SetPanes`, `SetRowHeight`, `SetRowOutlineLevel`, `SetRowStyle`, `SetRowVisible`, `SetSheetBackground`, `SetSheetBackgroundFromBytes`, `SetSheetCol`, `SetSheetName`, `SetSheetProps`, `SetSheetRow`, `SetSheetVisible`, `UnmergeCell`, `UnprotectSheet` and
      `UnsetConditionalFormat`
      - Update documentation of the set style functions
      Co-authored-by: Nguoweikuang <weikuang.guo@shopee.com>
      6a5ee811
  13. 28 8月, 2022 1 次提交
  14. 27 8月, 2022 1 次提交
  15. 16 6月, 2022 1 次提交
  16. 15 6月, 2022 1 次提交
  17. 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
  18. 12 1月, 2022 1 次提交
  19. 09 1月, 2022 1 次提交
  20. 08 1月, 2022 1 次提交
  21. 07 12月, 2021 1 次提交
  22. 16 11月, 2021 1 次提交
  23. 26 8月, 2021 1 次提交
  24. 15 8月, 2021 1 次提交
    • xurime's avatar
      Improve security and simplify code · 48c16de8
      xurime 提交于
      - Make variable name more semantic
      - Reduce cyclomatic complexities for the formula calculate function
      - Support specified unzip size limit on open file options, avoid zip bombs vulnerability attack
      - Typo fix for documentation and error message
      48c16de8
  25. 06 8月, 2021 1 次提交
  26. 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
  27. 04 4月, 2021 1 次提交
  28. 30 3月, 2021 1 次提交
  29. 13 3月, 2020 1 次提交
  30. 29 12月, 2019 1 次提交
  31. 24 12月, 2019 1 次提交
  32. 22 12月, 2019 1 次提交
  33. 11 8月, 2019 1 次提交
  34. 05 5月, 2019 1 次提交
  35. 23 1月, 2019 1 次提交
  36. 10 1月, 2019 1 次提交
    • V
      New feature: File.DuplicateRowTo() duplicate row to specified row position. · 725c1a0c
      Veniamin Albaev 提交于
      DuplicateRowTo() is similar to DuplicateRow() but copies specified row not just after specified source row
      but to any other specified position below or above source row.
      
      Also I made minor modifications of tests: using filepath.Join() instead of direct unix-way paths strings
      to avoid possible tests fails on other OS.
      725c1a0c
  37. 01 1月, 2019 1 次提交
  38. 27 12月, 2018 1 次提交
    • V
      Tests refactoring · 35426ed5
      Veniamin Albaev 提交于
      Primary motivation: Avoid statefull tests with not ignorable git file tree changes.
      Multiple tests reads and overwrites signle file for won needs.
      Multiple tests reads and overwrites file under version control.
      
      Secondary motivation: Minimal tests logic aligment, separate error expectation
      and not error expectation tests. Introduce sub-test over test data sets and so far.
      
      This commit is not ideal but necessary (IMHO)
      35426ed5
  39. 14 9月, 2018 2 次提交