summaryrefslogtreecommitdiff
path: root/col.go
Commit message (Collapse)AuthorAge
* Support get current row/col and total rows/cols in the stream reader (#1054)li2021-11-05
|
* 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 fix panic and incorrect cell read on some casexuri2021-08-22
| | | | | - Make unit test on Go 1.7 - API documentation updated
* 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`
* Speed up merge cellsthree2021-08-13
|
* This closes #971, closes #972 and closes #974xuri2021-07-29
| | | | | | | | - Escape XML character in the drop list - Fix incorrect character count limit in the drop list - Fix Excel time parse issue in some case - Fix custom number format month parse issue in some case - Fix corrupted file generated caused by concurrency adding pictures
* Fix missing set each cell's styles when set columns stylexuri2021-07-08
|
* - Support concurrency iterate rows and columnsxuri2021-07-05
| | | | | - Rename exported field `File.XLSX` to `File.Pkg` - Exported error message
* This closes #866, support use the defined name to reference the data range ↵xuri2021-06-29
| | | | | | | in pivot table options - Fix incorrect scope when getting defined name - Update docs: use column number instead of index on get column width
* make the caller of `getRowHeight` function adapt row number change, update ↵xuri2021-06-13
| | | | comment: use rows number instead of rows index.
* 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
* fix incorrect default column from GetColWidthxuri2021-03-05
|
* lint issue fixed and new formula function: ATAN, AVERAGE, AVERAGEA, CONCAT, ↵xuri2021-02-15
| | | | CONCATENATE, COUNT, COUNTBLANK, MAX
* handle end element event in the worksheet row/column iterator XML SAX parserxuri2021-02-05
|
* Fixed #732, support single line with repeated row element in the sheet dataxuri2020-11-18
|
* Fix #724, standardize variable naming and update unit testsxuri2020-11-11
|
* Fix #706, #713 improve AddPicture performance, fix missing worksheet when ↵xuri2020-10-18
| | | | rename with same names
* 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
* support parse and generate XML element namespace dynamic, fix #651xuri2020-07-18
|
* 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
|
* Update docs and typo fixedxuri2020-06-22
|
* make columns iterator read cell streamingly and add max column limit on ↵xuri2020-06-22
| | | | ColumnNumberToName
* Implement columns iteratorJérôme Pogeant2020-06-17
|
* Resolve #570, flat columns for the column's operationxuri2020-02-07
|
* SetColVisible() can parse a column range + typos.Jacques Boscq2020-01-21
|
* Improve code coverage unit testsxuri2019-12-29
|
* Improve compatibility for chartsxuri2019-09-26
|
* Compatibility improvementxuri2019-09-24
|
* Documentation updated, Go 1.10+ requiredxuri2019-08-11
|
* Resolve #397, support set style by columnsxuri2019-05-16
|
* godoc update and typo fixedxuri2019-04-20
|
* Resolve #369,#370xuri2019-04-15
| | | | | | | | | | | | | | | | | | add error return value exported functions: GetMergeCells ProtectSheet UnprotectSheet UpdateLinkedValue GetMergeCells SetSheetVisible inner functions: workSheetReader copySheet
* Adjust coding stylenabeyama yoshihide2019-04-04
|
* Fixed bug in the calculation target cell(row).nabeyama yoshihide2019-04-04
| | | | The target cell for calclator the height was shifted by 1.
* Fixed bug in column cell to check.nabeyama yoshihide2019-04-04
| | | | The target cell for calclator the width was shifted by 1.
* 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
* Fixed PR #356 regression RemoveCol() broken (#365)Veniamin Albaev2019-03-21
|
* Typo fixed and godoc updatedxuri2019-03-20
|
* 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
* resolve the issue corrupted xlsx after deleting formula of cell, reference #346xuri2019-02-22
|
* README updatedxuri2019-01-01
|
* Fixes #308, refactor `NewSheet()`, `DeleteSheet()`, `SetActiveSheet()` and ↵xuri2018-12-15
| | | | `GetActiveSheetIndex()`
* Fix comments according to best practices by effective goxuri2018-12-11
|
* Comments style changed.xuri2018-09-14
|
* Comments style changed.xuri2018-09-14
|