| Commit message (Collapse) | Author | Age |
| |
|
|
|
|
|
|
|
| |
XML deserialize error
- Add error return value for the `GetComments`, `GetDefaultFont` and `SetDefaultFont` functions
- Update unit tests
|
|
|
|
| |
file size
|
|
|
|
|
|
|
|
| |
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
|
|
|
|
| |
- 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
|
|
|
|
|
|
| |
- Improving performance for stream writer `SetRow` function, reduces memory usage over and speedup about 19%
- Update dependencies module
- Update GitHub workflow
|
|
|
|
|
|
|
| |
- 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
|
|
|
|
| |
- These 6 functions now support concurrency safe: SetColWidth, GetColWidth, SetColVisible, GetColVisible, SetColStyle and GetColStyle
|
| |
|
|
|
| |
This use `InsertRows` instead of `InsertRow`, and using `InsertCols` instead of `InsertCol`
|
| |
|
|
|
| |
- Update unit test and comment for the functions
|
|
|
|
|
|
| |
Sheet
- Format code with `gofmt`
|
|
|
|
| |
- Support get rows properties by `GetRowOpts` function
- New exported constant `MaxCellStyles`
|
|
|
|
|
|
| |
- Using sheet ID instead of sheet index when delete the cell in calculation chain
- Update documentation for exported functions
- Using `sheet` represent the sheet name in the function parameters
|
| |
|
|
|
| |
Ref #1129, make `SetRowStyle` overwrite style of the cells
|
| |
|
|
|
|
| |
format support
|
| |
|
|
|
|
| |
* added 3 new formula functions: BETAINV, BETA.INV, F.INV.RT
|
|
|
|
|
|
|
|
| |
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
|
|
|
|
|
|
| |
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
|
|
|
|
|
| |
ref #65: new formula functions DURATION and MDURATION
fix incorrect example in SetSheetStyle docs
|
| |
|
|
|
|
|
|
| |
- 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
|
|
|
|
|
| |
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
|
| |
|
|
|
|
| |
comment: use rows number instead of rows index.
|
| |
|
| |
|
| |
|
|
|
|
| |
writing mode, and export error message
|
|
|
|
| |
IMCSCH, IMEXP, IMLN and IMLOG10
|
|
|
|
| |
typo fixed
|