| Commit message (Collapse) | Author | Age |
|
|
|
|
|
| |
- Add nil pointer guard in cell format
- Add tests to verify the nil checks in formattedValue
Co-authored-by: Zach Clark <zachmclark@gmail.com>
|
|
|
|
| |
- Add `CellTypeFormula`, `CellTypeInlineString`, `CellTypeSharedString` and remove `CellTypeString` in `CellType` enumeration
- Unit tests updated
|
|
|
|
|
|
|
|
| |
- 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
|
| |
|
|
|
|
| |
line chart
|
|
|
|
|
|
|
| |
- 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
|
|
|
|
| |
- These 6 functions now support concurrency safe: SetColWidth, GetColWidth, SetColVisible, GetColVisible, SetColStyle and GetColStyle
|
| |
|
|
|
|
|
| |
- 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
|
|
|
| |
check vertical align enumeration, update set rich text docs and test
|
| |
|
|
|
|
|
|
|
| |
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
|
|
|
|
| |
type checking
|
| |
|
| |
|
|
|
|
|
|
| |
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`
|
| |
|
| |
|
|
|
|
|
| |
- Make unit test on Go 1.7
- API documentation updated
|
| |
|
|
|
|
|
|
|
| |
- support escaped string literal
- maximum character limit added
- fix missing preserve character in some case
Co-authored-by: xuri <xuri.me@gmail.com>
|
| |
|
|
|
|
| |
safety
|
| |
|
|
|
|
|
| |
- Rename exported field `File.XLSX` to `File.Pkg`
- Exported error message
|
|
|
|
| |
internal function `getSheetNameByID`
|
| |
|
| |
|
|
|
|
| |
CONCATENATE, COUNT, COUNTBLANK, MAX
|
| |
|
|
|
|
| |
with nil
|
|
|
|
|
| |
* fix UT-generated file names to be ignored
* fix cell value load with invalid number format ID
* fix PR issues
|
| |
|
|
|
|
| |
NewSheet in some case, fix panic on formatted value with no built-in number format ID
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
* 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
|