summaryrefslogtreecommitdiff
path: root/rows_test.go
Commit message (Collapse)AuthorAge
* This closes #1162, improve the compatibility with alternate contentxuri2022-03-05
| | | | Preserve alternate content in the workbook, worksheet, and drawingML
* 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
* 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
* Fix adjustMergeCells not modifies cell rect (#1118)Dokiy2022-01-14
|
* 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
|
* Support get current row/col and total rows/cols in the stream reader (#1054)li2021-11-05
|
* 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 #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 #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`
* This closes #989, closes #990xuri2021-08-17
| | | | | New API: `SetRowStyle` support for set style for the rows Update documentation for the `GetRows`, `SetCellStyle` and `SetColStyle`
* change go module import path to github.com/xuri/excelizexuri2021-07-28
|
* This closes #848 and closes #852, fix reading decimals precisionxuri2021-07-12
|
* - Support concurrency iterate rows and columnsxuri2021-07-05
| | | | | - Rename exported field `File.XLSX` to `File.Pkg` - Exported error message
* This closes #855, fix missing formula cell when getting rows valuexuri2021-06-05
|
* This closes #652, new SetColWidth API, support set column width in stream ↵xuri2021-05-10
| | | | writing mode, and export error message
* fix custom row height check issuexuri2021-02-08
|
* handle end element event in the worksheet row/column iterator XML SAX parserxuri2021-02-05
|
* new formula fn: IF, LEN; not equal operator support and faster numeric ↵xuri2021-01-27
| | | | precision process
* This closes #752, fix incorrectly merged cells on duplicate row, and new ↵xuri2020-12-22
| | | | formula function: LOWER, PROPER, UPPER
* Fix #724, standardize variable naming and update unit testsxuri2020-11-11
|
* - Resolve #711, update docs for the GetSheetIndexxuri2020-10-12
| | | | - Update unit test
* 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>
* add checking and limits for the worksheetxuri2020-09-18
|
* Default row height compatibility with Apache OpenOffice and Kingsoft WPS, ↵xuri2020-08-22
| | | | unit test update and typo fixed
* update docs and improve compatibilityxuri2020-07-11
|
* handle the cell without r attribute in a row elementxuri2020-04-24
|
* - Resolve #485 use sheet index instead of IDxuri2020-04-23
| | | | - added 3 internal function: getSheetID, getActiveSheetID, getSheetNameByID
* AddPivotTable API changed: new structure PivotTableField to hold pivot table ↵xuri2020-02-26
| | | | fields for better scalability
* Fix #586, duplicate row with merged cellsxuri2020-02-25
|
* optimize code and comments: use println errors instead of panicxuri2020-01-03
|
* Fix #551, handle empty rows in streaming readingxuri2019-12-31
|
* optimization: checking error in unit testsxuri2019-12-24
|
* Improve code coverage unit testsxuri2019-12-22
|
* Fix #529, handle empty inline rich textxuri2019-12-11
|
* Resolve #146, make the GetRow function read data as streaming. Ref: #382, #515xuri2019-11-23
|
* Resolve #507, add the new function `DeleteDefinedName`xuri2019-10-26
|
* Resolve #511, allow empty columns in the pivot tablexuri2019-10-24
|
* Pre-allocate some memory when reading files (#510)Michael2019-10-24
|
* fix #503 rows next issueducquangkstn2019-10-18
|
* Optimize code of Getting/Setting Page Marginsxuri2019-10-17
|
* Only parse xml once when readingHarris2019-08-05
| | | | | | | | | | We were parsing the whole sheet twice since the sheet reader already reads in all the rows. getTotalRowsCols function is unused after these changes so it has been deleted as well. Closes #439
* add unit tests to functionsxuri2019-04-16
|
* Resolve #369,#370xuri2019-04-15
| | | | | | | | | | | | | | | | | | add error return value exported functions: GetMergeCells ProtectSheet UnprotectSheet UpdateLinkedValue GetMergeCells SetSheetVisible inner functions: workSheetReader copySheet
* Add unit test to improve testing coveragexuri2019-03-24
|
* 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
* Huge refactorig for consistent col/row numbering (#356)Veniamin Albaev2019-03-20
| | | | | | | | | | | | | | | | | | | * Huge refactorig for consistent col/row numbering Started from simply changing ToALphaString()/TitleToNumber() logic and related fixes. But have to go deeper, do fixes, after do related fixes and again and again. Major improvements: 1. Tests made stronger again (But still be weak). 2. "Empty" returns for incorrect input replaces with panic. 3. Check for correct col/row/cell naming & addressing by default. 4. Removed huge amount of duplicated code. 5. Removed ToALphaString(), TitleToNumber() and it helpers functions at all, and replaced with SplitCellName(), JoinCellName(), ColumnNameToNumber(), ColumnNumberToName(), CellNameToCoordinates(), CoordinatesToCellName(). 6. Minor fixes for internal variable naming for code readability (ex. col, row for input params, colIdx, rowIdx for slice indexes etc). * Formatting fixes
generated by cgit v1.2.1 (git 2.18.0) at 2025-04-19 17:00:23 +0000