summaryrefslogtreecommitdiff
path: root/cell.go
Commit message (Collapse)AuthorAge
* This closes #1391, escape XML characters to avoid with corrupt filexuri2022-11-15
| | | | - Update and improve unit test coverage
* 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
* Delete shared formula in calc chain when writing a formula cell (#1387)March2022-11-08
|
* This closes #1384, fix segmentation fault in `formattedValue` (#1385)Martin Martinez Rivera2022-11-05
| | | | | | - Add nil pointer guard in cell format - Add tests to verify the nil checks in formattedValue Co-authored-by: Zach Clark <zachmclark@gmail.com>
* This closes #1204, breaking changes for add commentsxuri2022-11-02
| | | | | - Allowing insert SVG format images - Unit tests updated
* This closes #1379, cleanup stream writer temporary files by the `Close` functionxuri2022-10-26
| | | | | | - Fix error on inserting columns or rows on the worksheet which contains one cell merged cell range - Fix getting incomplete rich text cell value in some cases - Unit tests updated
* 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
* This closes #1369, support set, and get font color with theme and tint (#1370)GaoFei2022-10-15
|
* Stream writer support to set inline rich text cell (#1121)charles.deng2022-10-10
| | | Co-authored-by: zhengchao.deng <zhengchao.deng@meican.com>
* 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
* Using the specialized name in a variable and making comments clearxuri2022-09-18
| | | | - Add JSON tags for `AppProperties`, `PivotTableOption` and `PivotTableField` structure
* This makes 6 functions concurrency safetyxuri2022-09-11
| | | | - These 6 functions now support concurrency safe: SetColWidth, GetColWidth, SetColVisible, GetColVisible, SetColStyle and GetColStyle
* This closes #1247, add new function `SetSheetCol` for set worksheet column ↵Cooper de Nicola2022-08-25
| | | | | | values (#1320) Signed-off-by: cdenicola <cooper.denicola@instabase.com> Co-authored-by: cdenicola <cooper.denicola@instabase.com>
* This closes #1244 and closes #1314, improving the compatibility with Google ↵xuri2022-08-13
| | | | | | Sheet - Format code with `gofmt`
* 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
* Fix potential file corrupted when changing cell value or the col/rowxuri2022-07-16
| | | | | - Remove shared formula subsequent cell when setting the cell values - Support adjust table range when removing and inserting column/row
* This closes #1264, fix can't modify cell content issue in some casesyeshu2022-07-01
| | | Remove inline rich text when setting cell value and cell formulas
* RichTextRun support set superscript and subscript by vertAlign attribute (#1252)jialei2022-06-13
| | | check vertical align enumeration, update set rich text docs and test
* This fixes a part of staticcheck issues and updates the code of conductxuri2022-05-18
| | | | Update example for set cell hyperlinks with `HyperlinkOpts`
* This closed #1163, fix set cell value with column and row style inherit issuexuri2022-05-15
|
* This closes #1219, fixes cell value reading issue, improves performance, and ↵xuri2022-05-02
| | | | | | | 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
* This closes #1217, support update cell hyperlinkxuri2022-05-01
| | | Ref #1129, make `SetRowStyle` overwrite style of the cells
* This closes #1212, init support for 1900 or 1904 date systemxuri2022-04-30
|
* This closes #1213, fix get incorrect rich text value caused by missing cell ↵xuri2022-04-29
| | | | type checking
* ref #65, new formula functions: HYPGEOM.DIST and HYPGEOMDISTxuri2022-03-30
|
* 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
* ref #65, new formula functions: LOGNORM.INV and LOGINVxuri2022-03-15
| | | | * Update docs for the function `SetCellHyperLink`
* Fixed parsing decimal precision issuexuri2022-02-18
|
* 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
* Ref: #660, #764, #1093, #1112, #1133 This improve number format supportxuri2022-02-13
| | | | | | - Introduced NFP (number format parser) dependencies module - Initialize custom dates and times number format support - Dependencies module upgraded
* This closes #1139, `SetCellDefault` support non-numeric valuexuri2022-02-08
| | | | | | | | - Add default value on getting `View` property of sheet views - Add examples and unit test for set sheet views - Re-order field on sheet view options - Fix incorrect build-in number format: 42 - Simplify code for the `stylesReader` function
* This closes #1129, make cell support inheritance columns/rows stylexuri2022-01-27
| | | | | | Correct cells style in merge range Fix incorrect style ID returned on getting cell style in some cases Unit test updated and simplified code
* 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`
* Update create style example, using a pointer of the structure instead of JSONxuri2022-01-05
|
* This closes #1107, stream writer will create a time number format for time ↵xuri2021-12-31
| | | | | | type cells Unit test coverage improved
* Preserve horizontal tab character when set the cell value (#1108)vst2021-12-30
|
* 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
* This closes #1069, support time zone location when set cell valuexuri2021-11-24
|
* ref #65: new formula function PRICExuri2021-11-17
| | | | | - fix COUPPCD result accuracy issue - update close spreadsheet example in documentation and README
* 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
|
* - new formula functions: DATEVALUE, ref #65xuri2021-09-17
| | | | | - fix ineffectual variable assignments - timeout in go test
* This closes #417 and closes #520, new API `GetCellType` has been addedxuri2021-09-09
|
* 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`
* Add set shared formula support and documentation for the `SetCellFormula`xuri2021-09-03
|
* This closes #844, support get shared formularaochq2021-08-15
|
generated by cgit v1.2.1 (git 2.18.0) at 2025-04-16 00:30:36 +0000