summaryrefslogtreecommitdiff
path: root/cell.go
Commit message (Collapse)AuthorAge
...
* 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
| * Fix #538, added setting a major unit and tick label skip support for the chartxuri2019-12-25
| |
| * Improve compatibility, fix workbook's rels ID calc errorxuri2019-12-23
| |
| * Fix #533, add support overlapped mergecellsxuri2019-12-14
| |
| * Optimize code of Getting/Setting Page Marginsxuri2019-10-17
| |
| * solve ending space missingheiy2019-10-10
| |
| * Allow access to more formula attributes in SetCellFormula (#484)Christian Fiedler2019-09-22
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | * Allow access to more formula attributes in SetCellFormula Make SetCellFormula variadic to not break API. The new arguments are option arguments in which the type of the formula and the ref attribute may be set. These need to be set for an array formula to work. * Add TestWriteArrayFormula to test optional parameters of SetCellFormula TestWriteArrayFormula writes a document to the test directory that contains array formulas that are used to calculate standard deviations. The file also contains values calculated by the Go testcase, so the results can be verified. It should be tested, if the array formula works (i.e. shows a number, not an error) and that the values calculated by the formula and those calculated by Go are the same.
| * Combine functions:xuri2019-09-16
| | | | | | | | | | | | workBookRelsWriter, drawingRelsWriter into relsWriter; drawingRelsReader, workbookRelsReader, workSheetRelsReader into relsReader; addDrawingRelationships, addSheetRelationships into addRels
| * add missing error check in SetSheetRow()mqy2019-08-19
| |
generated by cgit v1.2.1 (git 2.18.0) at 2025-04-16 04:16:44 +0000