summaryrefslogtreecommitdiff
path: root/cell.go
Commit message (Collapse)AuthorAge
* 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
|
* Number format read fix (#741)Artem Kustikov2020-12-12
| | | | | * fix UT-generated file names to be ignored * fix cell value load with invalid number format ID * fix PR issues
* Fixed #735, refresh active tab after delete sheetxuri2020-11-23
|
* Fix #724, standardize variable naming and update unit testsxuri2020-11-11
|
* This closes #714 and closes #715, fix wrong worksheet index returned by ↵xuri2020-10-19
| | | | 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 (#703)Artem Kustikov2020-10-04
| | | | | | | | | | | | | | | | | | | | | | | | | * 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>
* Default row height compatibility with Apache OpenOffice and Kingsoft WPS, ↵xuri2020-08-22
| | | | unit test update and typo fixed
* Compatible with Go 1.15, fix unit test failed on Windows and fixed #689 ↵xuri2020-08-15
| | | | potential race condition
* support parse and generate XML element namespace dynamic, fix #651xuri2020-07-18
|
* Resolve #32, fix missing leading/leading spaces when working with SSTxuri2020-07-01
|
* Update docs and typo fixedxuri2020-06-22
|
* make columns iterator read cell streamingly and add max column limit on ↵xuri2020-06-22
| | | | ColumnNumberToName
* escape html tagheiy2020-06-08
|
* add limits for total columns, row and filename lengthxuri2020-05-29
|
* speedup get cell value from shared string tablexuri2020-05-27
|
* Fix #622, storage string to SST (shared string table)xuri2020-05-26
|
* Merge branch 'master' into fix/cell_lockxuri2020-05-22
|\
| * - formula engine: reduce cyclomatic complexityxuri2020-05-10
| | | | | | | | - styles: allow empty and default cell formats, #628
| * - Resolve #485 use sheet index instead of IDxuri2020-04-23
| | | | | | | | - added 3 internal function: getSheetID, getActiveSheetID, getSheetNameByID
| * Resolve #598, filter support for AddPivotTablexuri2020-04-09
| |
| * Resolve #172, init rich text supportxuri2020-04-06
| |
| * Improve code coverage unit testsxuri2019-12-29
| |
| * Stream to Excel table (#530)Cameron Howey2019-12-29
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | * Support all datatypes for StreamWriter * Support setting styles with StreamWriter **NOTE:** This is a breaking change. Values are now explicitly passed as a []interface{} for simplicity. We also let styles to be set at the same time. * Create function to write stream into a table * Write rows directly to buffer Avoiding the xml.Encoder makes the streamer faster and use less memory. Using the included benchmark, the results went from: > BenchmarkStreamWriter-4 514 2576155 ns/op 454918 B/op 6592 allocs/op down to: > BenchmarkStreamWriter-4 1614 777480 ns/op 147608 B/op 5570 allocs/op * Use AddTable instead of SetTable This requires reading the cells after they have been written, which requires additional structure for the temp file. As a bonus, we now efficiently allocate only one buffer when reading the file back into memory, using the same approach as ioutil.ReadFile. * Use an exported Cell type to handle inline styles for StreamWriter
generated by cgit v1.2.1 (git 2.18.0) at 2025-04-19 22:53:47 +0000