1. 15 12月, 2023 1 次提交
  2. 13 11月, 2023 1 次提交
    • xurime's avatar
      Support 5 new kinds of conditional formatting types · 2499bf6b
      xurime 提交于
      - New conditional formatting types: text, blanks, no blanks, errors, and no errors
      - Support calculate formula with multiple dash arithmetic symbol
      - Fix empty calculate result with numeric arguments in LEN, LOWER, PROPER, REPT, UPPER, and IF formula functions
      - Uniform double quote in calculation unit tests
      - Update unit tests
      2499bf6b
  3. 24 10月, 2023 1 次提交
  4. 08 10月, 2023 1 次提交
    • xurime's avatar
      This closes #1681, closes #1683 · 99df1a73
      xurime 提交于
      - Fix incorrect formula calculation result
      - Introduce new exported function `SetCellUint`
      - Updates unit test
      - Typo fixed
      99df1a73
  5. 01 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. 14 9月, 2023 1 次提交
    • xurime's avatar
      This fixes #1658 · 5a039f30
      xurime 提交于
      - Fix a v2.8.0 regression bug, number format code apply result was empty
      - Fix calculate formula functions CHITEST and MMULT panic in some cases
      - Updated unit tests
      5a039f30
  8. 08 9月, 2023 1 次提交
    • xurime's avatar
      This fixes #1643, fixes #1647 and fixes #1653 · ae64bcaa
      xurime 提交于
      - Correction cell type when formatting date type cell value
      - Add check for MID and MIDB formula functions num_chars arguments, prevent panic on specifying a negative number
      - Ref #65, add support for 2 formula functions: SEARCH and SEARCHB
      - Fix a v2.8.0 regression bug, error on set print area and print titles with built-in special defined name
      - Add new exported function `GetPivotTables` for get pivot tables
      - Add a new `Name` field in the `PivotTableOptions` to support specify pivot table name
      - Using relative cell reference in the pivot table docs and unit tests
      - Support adding slicer content type part internally
      - Add new exported source relationship and namespace `NameSpaceSpreadSheetXR10`, `ContentTypeSlicer`, `ContentTypeSlicerCache`, and `SourceRelationshipSlicer`
      - Add new exported extended URI `ExtURIPivotCacheDefinition`
      - Fix formula argument wildcard match issues
      - Update GitHub Actions configuration, test on Go 1.21.x with 1.21.1 and later
      - Avoid corrupted workbooks generated by improving compatibility with internally indexed color styles
      ae64bcaa
  9. 26 8月, 2023 1 次提交
    • F
      ref #65, add support for 10 formula functions · 4957ee9a
      fsfsx 提交于
      - Add support for 10 formula functions: ARRAYTOTEXT, FORECAST, FORECAST.LINEAR, FREQUENCY, INTERCEPT, ODDFYIELD, ODDLPRICE, ODDLYIELD, PROB and VALUETOTEXT
      - Update unit tests
      4957ee9a
  10. 06 8月, 2023 1 次提交
    • xurime's avatar
      This fixes #1599, and improve date and time number format · eb175906
      xurime 提交于
      - Fix basic arithmetic operator priority issues
      - Support apply date and time number format with 52 languages: Estonian, Faroese, Filipino, Finnish, Frisian, Fulah, Galician, Georgian, Greek, Greenlandic, Guarani, Gujarati, Hausa, Hawaiian, Hebrew, Hindi, Hungarian, Icelandic, Igbo, Indonesian, Inuktitut, Kannada, Kashmiri, Kazakh, Khmer, Kiche, Kinyarwanda, Kiswahili, Konkani, Kyrgyz, Lao, Latin, Latvian, Lithuanian, Luxembourgish, Macedonian, Malay, Malayalam, Maltese, Maori, Mapudungun, Marathi, Mohawk, Morocco, Nepali, Nigeria, Norwegian, Occitan, Odia, Oromo, Pashto and Syllabics
      - Support apply the Chinese weekdays' number formats
      - Update the unit test and dependencies modules
      eb175906
  11. 21 7月, 2023 1 次提交
    • xurime's avatar
      This closes #1582, fixes the formula calculation bug, and improves form controls · 8d996ca1
      xurime 提交于
      - Fix incorrect formula calculate results on a nested argument function which returns a numeric result
      - Add a new exported error variable `ErrorFormControlValue`
      - Rename exported enumeration `FormControlCheckbox` to `FormControlCheckBox`
      - Rename exported enumeration `FormControlRadio` to `FormControlOptionButton`
      - The `AddFormControl` function supports new 5 form controls: spin button, check box, group box, label, and scroll bar
      - Update documentation for the `GraphicOptions` data type, `AddFormControl` and `NewStreamWriter` functions
      - Update the unit tests
      8d996ca1
  12. 06 7月, 2023 1 次提交
  13. 03 7月, 2023 1 次提交
  14. 30 5月, 2023 1 次提交
  15. 17 5月, 2023 1 次提交
  16. 15 3月, 2023 1 次提交
  17. 21 2月, 2023 1 次提交
  18. 20 2月, 2023 1 次提交
  19. 15 2月, 2023 1 次提交
  20. 08 1月, 2023 1 次提交
  21. 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
  22. 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
  23. 22 11月, 2022 1 次提交
  24. 25 10月, 2022 1 次提交
  25. 24 10月, 2022 1 次提交
    • xurime's avatar
      Support get cell value which contains a date in the ISO 8601 format · 14c6a198
      xurime 提交于
      - Support set and get font color with indexed color
      - New export variable `IndexedColorMapping`
      - Fix getting incorrect page margin settings when the margin is 0
      - Update unit tests and comments typo fixes
      - ref #65, new formula functions: AGGREGATE and SUBTOTAL
      14c6a198
  26. 21 10月, 2022 1 次提交
  27. 28 9月, 2022 1 次提交
    • xurime's avatar
      This closes #1360, closes #1361 · efcf599d
      xurime 提交于
      - 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
      efcf599d
  28. 28 8月, 2022 1 次提交
  29. 17 8月, 2022 1 次提交
  30. 10 7月, 2022 1 次提交
  31. 03 7月, 2022 1 次提交
  32. 02 7月, 2022 1 次提交
  33. 01 7月, 2022 1 次提交
  34. 28 6月, 2022 1 次提交
  35. 27 6月, 2022 1 次提交
  36. 24 6月, 2022 1 次提交
  37. 22 6月, 2022 1 次提交
  38. 20 6月, 2022 1 次提交
  39. 17 6月, 2022 1 次提交
  40. 16 6月, 2022 1 次提交