summaryrefslogtreecommitdiff
path: root/table.go
Commit message (Collapse)AuthorAge
* This closes #1122, improve compatibility with LibreOfficexuri2022-01-16
| | | Fixed the issue auto filter doesn't work on LibreOffice if the sheet name has spaces
* Typo fix, rename exported constants, dependencies modules and copyright updatexuri2022-01-09
| | | | Rename exported constants `NameSpaceDublinCoreMetadataIntiative` to `NameSpaceDublinCoreMetadataInitiative`
* ref #65: new formula function PRICExuri2021-11-17
| | | | | - fix COUPPCD result accuracy issue - update close spreadsheet example in documentation and README
* - Support concurrency iterate rows and columnsxuri2021-07-05
| | | | | - Rename exported field `File.XLSX` to `File.Pkg` - Exported error message
* Fixe issue generated file corrupted caused by incorrect default XML ↵xuri2021-04-30
| | | | namespace attributes
* 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
* lint issue fixed and new formula function: ATAN, AVERAGE, AVERAGEA, CONCAT, ↵xuri2021-02-15
| | | | CONCATENATE, COUNT, COUNTBLANK, MAX
* This improves compatibility for worksheet relative XML path and multi rules ↵xuri2021-02-11
| | | | auto filter
* This closes #774, closes #775 and closes #776xuri2021-02-02
| | | | | | | | - correct adjust calculation chain in duplicate rows - correct adjust defined name in the workbook when delete worksheet - use absolute reference in the auto filters defined name to make it compatible with OpenOffice - API `CoordinatesToCellName` have a new optional param to specify if using an absolute reference format - Fix cyclomatic complexity issue of internal function `newFills` and `parseToken`
* Fix #724, standardize variable naming and update unit testsxuri2020-11-11
|
* Update test for addTablexuri2020-07-19
|
* support parse and generate XML element namespace dynamic, fix #651xuri2020-07-18
|
* Update docs and typo fixedxuri2020-06-22
|
* avoid duplicate filter database in workbook defined nameyuemanxilou2020-05-15
|
* Fix #637, improve the compatibility of the auto filter with Office 2007 - 2013xuri2020-05-14
|
* Resolve #570, flat columns for the column's operationxuri2020-02-07
|
* Improve code coverage unit testsxuri2019-12-29
|
* optimization: checking error in unit testsxuri2019-12-24
|
* Improve compatibility, fix workbook's rels ID calc errorxuri2019-12-23
|
* Combine functions:xuri2019-09-16
| | | | | | workBookRelsWriter, drawingRelsWriter into relsWriter; drawingRelsReader, workbookRelsReader, workSheetRelsReader into relsReader; addDrawingRelationships, addSheetRelationships into addRels
* Documentation updated, Go 1.10+ requiredxuri2019-08-11
|
* Fix #424, refactor merged cells adjusterxuri2019-06-12
|
* 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
* 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
* README updatedxuri2019-01-01
|
* Comments style changed.xuri2018-09-14
|
* Comments style changed.xuri2018-09-14
|
* Comments style changed.xuri2018-09-14
|
* Fix golint errors under confidence 0.1xuri2018-09-12
|
* Fixes #256 and format document.xuri2018-08-06
|
* GoDoc updated.xuri2018-07-13
|
* - Add error return value for functions: `AddChart()`, `AddComment()`, ↵xuri2018-05-27
| | | | | | `AddPicture()`, `AddShape()`, `AddTable()` and `SetConditionalFormat()` - go test has been updated
* save bytes on memory instead of stringLunny Xiao2018-05-07
|
* - Set name of table support in `AddTable()`, relate issue #216;Ri Xu2018-05-04
| | | | - godoc and go test has been updated
* Fix document typo.Ri Xu2018-05-03
|
* godoc updated.Ri Xu2017-09-13
|
* - API changed, use worksheet name instead of "sheet" + index, related issue ↵Ri Xu2017-09-13
| | | | | | #25, #43, #47, #51, #89, #101, #116 and #120. - go test updated
* Optimize code, go test and godoc updated.Ri Xu2017-07-30
|
* - Make function `TitleToNumber()` exportable, note that function ↵Ri Xu2017-06-27
| | | | | | `ToAlphaString()` return value calculation changes, get more info from go doc. Relate issue #63; - Readme and go doc updated
* - Function `formattedValue()` performance improvement by avoid repeating ↵Ri Xu2017-06-26
| | | | | | deserialization, relate issue #64; - Make function `ToAlphaString()` exportable, relate issue #63
* - New functions `GetColVisible()` and `SetColVisible()` added, relate issue #61;Ri Xu2017-06-15
| | | | | - go test updated; - Fix typo
* - New functions: `GetSheetVisible()` and `GetRowVisible()` added, relate ↵Ri Xu2017-06-14
| | | | | | issue #61; - go test updated
* - Fixed coordinate parse error in function `SetCellStyle()`, relate issue #60;Ri Xu2017-06-12
| | | | - Simplified code
* Init auto filter support, relate issue #59.Ri Xu2017-06-08
|
* Code optimize.Ri Xu2017-05-24
|
* - Initialize shape support: new function `AddShape()` added. Relate issue #38;Ri Xu2017-04-30
| | | | | - Drawing `nvPicPr` element ID property calculation changed; - go test updated
* - Initialize table support;Ri Xu2017-04-28
- go test updated
generated by cgit v1.2.1 (git 2.18.0) at 2025-04-19 01:33:42 +0000