summaryrefslogtreecommitdiff
path: root/cell.go
Commit message (Collapse)AuthorAge
* 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
|
* Speed up merge cellsthree2021-08-13
|
* This closes #986, fix set data validation drop list failed in some casesxuri2021-08-12
| | | | Update documentation for `GetCellValue` and simplify code
* Reduce cyclomatic complexities for the formula calculate function and update ↵xuri2021-08-09
| | | | documentation for the API: `MergeCell` and `GetCellValue`
* Improve compatibility for SetRichText (#976)Arnie972021-07-31
| | | | | | | - support escaped string literal - maximum character limit added - fix missing preserve character in some case Co-authored-by: xuri <xuri.me@gmail.com>
* change go module import path to github.com/xuri/excelizexuri2021-07-28
|
* Make the functions `SetSheetRow`, `New Style` and `SetCellStyle` concurrency ↵xuri2021-07-07
| | | | safety
* - Support concurrency iterate rows and columnsxuri2021-07-05
| | | | | - Rename exported field `File.XLSX` to `File.Pkg` - Exported error message
* encode the escaped string literal which not permitted in an XML 1.0 documentxuri2021-06-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
* Add support for setting hyperlink display & tooltip (closes #790) (#794)James Allen2021-03-03
|
* handle default underline type on get rich text; #65 fn: CODE, COLUMN, FIND, ↵xuri2021-02-24
| | | | FINDB
* check empty rich text run properties; new formula fn: LEFT, LEFTB, RIGHT, RIGHTBxuri2021-02-23
|
* add GetCellRichText method and test (#789)tonnyzhang2021-02-22
|
* This closes #787, avoid duplicate rich text string items, new formula fn: ↵xuri2021-02-21
| | | | BIN2DEC, BIN2HEX, BIN2OCT, HEX2BIN, HEX2DEC, HEX2OCT, OCT2BIN, OCT2DEC, OCT2HEX
* ref: #756, set cell as blank when SetCellValue with nil #756, new formula ↵xuri2021-02-19
| | | | fn: BITAND, BITLSHIFT, BITOR, BITRSHIFT, BITXOR
* This closes #756, not set the empty string for the cell when SetCellValue ↵xuri2021-01-08
| | | | with nil
* new formula func CLEAN and TRIM, change import path to v2 (#747)Zhang Zhipeng2020-12-14
|
generated by cgit v1.2.1 (git 2.18.0) at 2025-04-19 02:14:23 +0000