summaryrefslogtreecommitdiff
path: root/cell_test.go
Commit message (Collapse)AuthorAge
* Fixed parsing decimal precision issuexuri2022-02-18
|
* 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
* 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
* Export 7 errors so users can act differently on different type of errorsxuri2021-12-07
|
* This closes #1069, support time zone location when set cell valuexuri2021-11-24
|
* ref #65, new formula function: TIMExuri2021-10-16
|
* 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 #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
|
* Improve compatibility with row element with r="0" attributexuri2021-08-23
|
* - This fix panic and incorrect cell read on some casexuri2021-08-22
| | | | | - Make unit test on Go 1.7 - API documentation updated
* This closes #844, support get shared formularaochq2021-08-15
|
* 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 add picturexuri2021-07-06
|
* - Support concurrency iterate rows and columnsxuri2021-07-05
| | | | | - Rename exported field `File.XLSX` to `File.Pkg` - Exported error message
* This closes #861, support concurrency get cell picture and remove unused ↵xuri2021-07-04
| | | | internal function `getSheetNameByID`
* Fixed #823, 12/24 hours time format parsing errorxuri2021-04-20
|
* add GetCellRichText method and test (#789)tonnyzhang2021-02-22
|
* lint issue fixed and new formula function: ATAN, AVERAGE, AVERAGEA, CONCAT, ↵xuri2021-02-15
| | | | CONCATENATE, COUNT, COUNTBLANK, MAX
* Fixed #764, add a condition for round precisionxuri2021-01-20
|
* This closes #756, not set the empty string for the cell when SetCellValue ↵xuri2021-01-08
| | | | with nil
* 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 #732, support single line with repeated row element in the sheet dataxuri2020-11-18
|
* 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
* GetCols support the row element without r attribute in the worksheetxuri2020-06-28
|
* support the row element without r attribute in the worksheetxuri2020-06-27
|
* - Resolve #611, fix failure BenchmarkSetCellValuexuri2020-04-10
| | | | | - Allow empty filter, data, and rows in the pivot table - Add more test case for pivot table
* Resolve #172, init rich text supportxuri2020-04-06
|
* Resolve #580, revert commit ↵xuri2020-02-19
| | | | https://github.com/360EntSecGroup-Skylar/excelize/commit/5ca7231ed408ac264f509ff52b5d28ff4fbda757
* optimize code and comments: use println errors instead of panicxuri2020-01-03
|
* optimization: checking error in unit testsxuri2019-12-24
|
* Improve code coverage unit testsxuri2019-12-22
|
* Fix #533, add support overlapped mergecellsxuri2019-12-14
|
* Resolve #507, add the new function `DeleteDefinedName`xuri2019-10-26
|
* Testing files updatedxuri2019-09-02
|
* Fix #386 regression test added (#440)Vsevolod Balashov2019-09-01
| | | | | | * #386 regression test added * closes #386 string to bigint on GOARCH=386
* Resolve #382, rewrite prepareSheetXML to scale linearly (#383)Michael2019-04-16
| | | | | | | | | | | | | | * Rewrite prepareSheetXML to scale linearly We don't need to backfill columns into every row for most purposes Provided makeContiguousColumns for setting styles where we do need it for a specific region. Added a benchmark to monitor progress. For 50,000 rows this went from about 11 seconds to 1 second. The improvements are more dramatic as the row/column count increases. * Assigning that row value was redundant
* refactor: handler error instead of panic,xuri2019-03-23
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Exported functions: SetCellStyle InsertCol RemoveCol RemoveRow InsertRow DuplicateRow DuplicateRowTo SetRowHeight GetRowHeight GetCellValue GetCellFormula GetCellHyperLink SetCellHyperLink SetCellInt SetCellBool SetCellFloat SetCellStr SetCellDefault GetCellStyle SetCellValue MergeCell SetSheetRow SetRowVisible GetRowVisible SetRowOutlineLevel GetRowOutlineLevel GetRows Columns SearchSheet AddTable GetPicture AutoFilter GetColVisible SetColVisible GetColOutlineLevel SetColOutlineLevel SetColWidth GetColWidth inner functions: adjustHelper adjustMergeCells adjustAutoFilter prepareCell setDefaultTimeStyle timeToExcelTime addDrawingChart addDrawingVML addDrawingPicture getTotalRowsCols checkRow addDrawingShape addTable