| Commit message (Collapse) | Author | Age |
| |
|
|
|
|
|
| |
- 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
|
| |
|
|
| |
- Add JSON tags for `AppProperties`, `PivotTableOption` and `PivotTableField` structure
|
| | |
|
| |
|
| |
This use `InsertRows` instead of `InsertRow`, and using `InsertCols` instead of `InsertCol`
|
| | |
|
| |
|
|
|
|
| |
- Add supported options in the docs of the functions `SetSheetPrOptions` and `GetSheetPrOptions`
- Add go1.19 unit test settings, and made the test case compatible with go1.19
- Update dependencies module
|
| |
|
|
| |
- Support get rows properties by `GetRowOpts` function
- New exported constant `MaxCellStyles`
|
| |
|
|
|
| |
- Remove shared formula subsequent cell when setting the cell values
- Support adjust table range when removing and inserting column/row
|
| |
|
|
|
|
|
| |
1904 date system support
- Fix incorrect cell data types casting results when number formatting
- Support set cell value on 1904 date system enabled, ref #1212
- Improve performance for set sheet row and the merging cells, fix performance impact when resolving #1129
|
| |
|
| |
Ref #1129, make `SetRowStyle` overwrite style of the cells
|
| |
|
|
| |
* added 3 new formula functions: BETAINV, BETA.INV, F.INV.RT
|
| |
|
|
| |
Preserve alternate content in the workbook, worksheet, and drawingML
|
| |
|
|
|
|
| |
Correct cells style in merge range
Fix incorrect style ID returned on getting cell style in some cases
Unit test updated and simplified code
|
| |
|
|
|
|
| |
Fix file corrupted when save as in XLAM / XLSM / XLTM / XLTX extension in some case
New exported error ErrWorkbookExt has been added, and check file extension on save the workbook
Format source code with `gofumpt`
|
| |
|
|
| |
This removed 3 exported functions: `TotalCols`, `CurrentCol` and `CurrentRow`
|
| |
|
|
| |
Reduce allocation memory 20%, and 80% GC times for the row's iterator
|
| | |
|
| |
|
|
| |
Rename exported constants `NameSpaceDublinCoreMetadataIntiative` to `NameSpaceDublinCoreMetadataInitiative`
|
| |
|
|
|
|
|
|
| |
- Unzip shared string table to system temporary file when large inner XML, reduce memory usage about 70%
- Remove unnecessary exported variable `XMLHeader`, we can using `encoding/xml` package's `xml.Header` instead of it
- Using constant instead of inline text for default XML path
- Rename exported option field `WorksheetUnzipMemLimit` to `UnzipXMLSizeLimit`
- Unit test and documentation updated
|
| | |
|
| | |
|
| |
|
|
|
|
| |
- new formula function: YEARFRAC, ref #65
- update the codecov version
- remove unused variable
|
| |
|
|
|
|
| |
- Close spreadsheet and row's iterator required
- New options `WorksheetUnzipMemLimit` have been added
- Improve streaming reading performance, memory usage decrease about 93.7%
|
| |
|
|
|
|
|
| |
- 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`
|
| |
|
|
|
| |
New API: `SetRowStyle` support for set style for the rows
Update documentation for the `GetRows`, `SetCellStyle` and `SetColStyle`
|
| | |
|
| | |
|
| |
|
|
|
| |
- Rename exported field `File.XLSX` to `File.Pkg`
- Exported error message
|
| | |
|
| |
|
|
| |
writing mode, and export error message
|
| | |
|
| | |
|
| |
|
|
| |
precision process
|
| |
|
|
| |
formula function: LOWER, PROPER, UPPER
|
| | |
|
| |
|
|
| |
- Update unit test
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
* extend cell value load to support custom datetime format
* cleanup incorrect imports
* fix numeric values conversion as done in legacy Excel
* fix tests coverage
* revert temporary package name fix
* remove personal info from test XLSX files
* remove unused dependencies
* update format conversion in parseTime
* new UT to increase code coverage
* Resolve code review issue for PR #703
* Rename broken file name generated by unit test
Co-authored-by: xuri <xuri.me@gmail.com>
|
| | |
|
| |
|
|
| |
unit test update and typo fixed
|
| | |
|
| | |
|
| |
|
|
| |
- added 3 internal function: getSheetID, getActiveSheetID, getSheetNameByID
|
| |
|
|
| |
fields for better scalability
|
| | |
|
| | |
|
| | |
|
| | |
|
| | |
|
| | |
|
| | |
|