summaryrefslogtreecommitdiff
path: root/rows.go
Commit message (Collapse)AuthorAge
* Remove internal error log print, throw XML deserialize errorxuri2022-11-13
|
* This is a breaking change, remove partial internal error log print, throw ↵xuri2022-11-12
| | | | | | | XML deserialize error - Add error return value for the `GetComments`, `GetDefaultFont` and `SetDefaultFont` functions - Update unit tests
* This closes #1383, skip empty rows when saving the spreadsheet to reduce ↵xuri2022-11-03
| | | | file size
* Fix the error on getting the range of merged cells on the worksheet which ↵xuri2022-10-28
| | | | | | | | 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
* This closes #1377, stream writer writes inline string type for string cell valuexuri2022-10-25
| | | | - Add `CellTypeFormula`, `CellTypeInlineString`, `CellTypeSharedString` and remove `CellTypeString` in `CellType` enumeration - Unit tests updated
* Support get cell value which contains a date in the ISO 8601 formatxuri2022-10-24
| | | | | | | | - 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
* Go 1.16 and later required, migration of deprecation package `ioutil`xuri2022-10-13
| | | | | | - Improving performance for stream writer `SetRow` function, reduces memory usage over and speedup about 19% - Update dependencies module - Update GitHub workflow
* This closes #1360, closes #1361xuri2022-09-28
| | | | | | | - 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
* This makes 6 functions concurrency safetyxuri2022-09-11
| | | | - These 6 functions now support concurrency safe: SetColWidth, GetColWidth, SetColVisible, GetColVisible, SetColStyle and GetColStyle
* This closes #1323, an error will be returned when set the not exist style IDxuri2022-09-01
|
* This is a breaking change closes #1332 (#1333)Kostya Privezentsev2022-08-31
| | | This use `InsertRows` instead of `InsertRow`, and using `InsertCols` instead of `InsertCol`
* This closes #1330 update non existing sheet error messages (#1331)davidborry2022-08-28
|
* This closes #1319, fix calculate error for formula with negative symbolxuri2022-08-17
| | | - Update unit test and comment for the functions
* This closes #1244 and closes #1314, improving the compatibility with Google ↵xuri2022-08-13
| | | | | | Sheet - Format code with `gofmt`
* This closes #1296, add new function `GetRowOpts` for stream reader (#1297)Thomas Charbonnel2022-08-11
| | | | - Support get rows properties by `GetRowOpts` function - New exported constant `MaxCellStyles`
* Fix potential file corrupted and change worksheet name case-insensitivexuri2022-07-18
| | | | | | - 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 #65, new formula functions: NETWORKDAYS, NETWORKDAYS.INTL, and WORKDAYxuri2022-06-16
|
* This closes #1217, support update cell hyperlinkxuri2022-05-01
| | | Ref #1129, make `SetRowStyle` overwrite style of the cells
* Format code, update documentation and remove exported variable `XMLHeaderByte`xuri2022-03-24
|
* This improved formula calculate precision and added zero placeholder number ↵xuri2022-03-19
| | | | format support
* This fix scientific notation and page setup fields parsing issuexuri2022-03-18
|
* ref #65, new formula functions and read boolean data type cell value supportxuri2022-03-08
| | | | * added 3 new formula functions: BETAINV, BETA.INV, F.INV.RT
* This closes #1148, resolve limitations when adding VBA project to the workbookxuri2022-02-17
| | | | | | | | 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 in some cases, check file extension and format codexuri2022-01-23
| | | | | | 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`
* ref #1054, breaking change for the column and row's iteratorxuri2022-01-19
| | | | This removed 3 exported functions: `TotalCols`, `CurrentCol` and `CurrentRow`
* Breaking change: remove `TotalRows` of row iterator and performance optimizationxuri2022-01-17
| | | | Reduce allocation memory 20%, and 80% GC times for the row's iterator
* Fix adjustMergeCells not modifies cell rect (#1118)Dokiy2022-01-14
|
* ref #1096, reduce memory usage by about 50% for large data spreadsheetxuri2022-01-11
|
* Typo fix, rename exported constants, dependencies modules and copyright updatexuri2022-01-09
| | | | Rename exported constants `NameSpaceDublinCoreMetadataIntiative` to `NameSpaceDublinCoreMetadataInitiative`
* This closes #1096, memory usage optimization and another 4 changesxuri2021-12-27
| | | | | | | | - 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
* Update docs for SetSheetStyle, and added 2 formula functionsxuri2021-12-04
| | | | | ref #65: new formula functions DURATION and MDURATION fix incorrect example in SetSheetStyle docs
* Support get current row/col and total rows/cols in the stream reader (#1054)li2021-11-05
|
* This closes #1031, fix small float parsed error in some casexuri2021-10-15
| | | | | | - new formula function: YEARFRAC, ref #65 - update the codecov version - remove unused variable
* This closes #1026, time parse accuracy issue and typo fixedxuri2021-09-26
|
* This closes #833, closes #845, and closes #1022, breaking changesxuri2021-09-19
| | | | | | - Close spreadsheet and row's iterator required - New options `WorksheetUnzipMemLimit` have been added - Improve streaming reading performance, memory usage decrease about 93.7%
* This closes #998xuri2021-09-05
| | | | | | | - 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`
* - This fix panic and incorrect cell read on some casexuri2021-08-22
| | | | | - Make unit test on Go 1.7 - API documentation updated
* This closes #989, closes #990xuri2021-08-17
| | | | | New API: `SetRowStyle` support for set style for the rows Update documentation for the `GetRows`, `SetCellStyle` and `SetColStyle`
* Speed up merge cellsthree2021-08-13
|
* This closes #848 and closes #852, fix reading decimals precisionxuri2021-07-12
|
* Support concurrency add picturexuri2021-07-06
|
* - Support concurrency iterate rows and columnsxuri2021-07-05
| | | | | - Rename exported field `File.XLSX` to `File.Pkg` - Exported error message
* fix getRowHeight actually get the height of the next row (#860)strong2021-06-13
|
* make the caller of `getRowHeight` function adapt row number change, update ↵xuri2021-06-13
| | | | comment: use rows number instead of rows index.
* This closes #855, fix missing formula cell when getting rows valuexuri2021-06-05
|
* fix the bug when there was no count attribute in sharedStrings filewilliam2021-05-24
|
* This closes #842, avoid empty rows in the tail of the worksheetxuri2021-05-16
|
* This closes #652, new SetColWidth API, support set column width in stream ↵xuri2021-05-10
| | | | writing mode, and export error message
* Go 1.15 and later required, #65 fn: IMABS, IMCOS, IMCOSH, IMCOT, IMCSC, ↵xuri2021-04-04
| | | | IMCSCH, IMEXP, IMLN and IMLOG10
* #65 fn: N, PERCENTILE.INC and Txuri2021-03-30
| | | | typo fixed