summaryrefslogtreecommitdiff
path: root/adjust.go
Commit message (Collapse)AuthorAge
* This closes #1391, escape XML characters to avoid with corrupt filexuri2022-11-15
| | | | - Update and improve unit test coverage
* Support update column style when inserting or deleting columnsxuri2022-11-11
| | | | | | - Go Modules dependencies upgrade - Unify internal variable name - Unit test updated
* This closes #1379, cleanup stream writer temporary files by the `Close` functionxuri2022-10-26
| | | | | | - Fix error on inserting columns or rows on the worksheet which contains one cell merged cell range - Fix getting incomplete rich text cell value in some cases - Unit tests updated
* This closes #1360, closes #1361xuri2022-09-28
| | | | | | | - Fix default number format parse issue with a long string of digits - Fix creating a sheet with an empty name cause a corrupted file - The `GetCellStyle` function no longer return master cell style of the merge cell range - Using the specialized name in variables and functions
* Using the specialized name in a variable and making comments clearxuri2022-09-18
| | | | - Add JSON tags for `AppProperties`, `PivotTableOption` and `PivotTableField` structure
* This closes #1293, add new function `GetColStyle`xuri2022-09-07
| | | | | | - Fix generate workbook corruption after insert cols/rows in some case - Update unit tests - Update dependencies module
* This is a breaking change closes #1332 (#1333)Kostya Privezentsev2022-08-31
| | | This use `InsertRows` instead of `InsertRow`, and using `InsertCols` instead of `InsertCol`
* This closes #1244 and closes #1314, improving the compatibility with Google ↵xuri2022-08-13
| | | | | | Sheet - Format code with `gofmt`
* Fix potential file corrupted when changing cell value or the col/rowxuri2022-07-16
| | | | | - Remove shared formula subsequent cell when setting the cell values - Support adjust table range when removing and inserting column/row
* This closes #1148, resolve limitations when adding VBA project to the workbookxuri2022-02-17
| | | | | | | | Added two exported functions `SetWorkbookPrOptions` and `GetWorkbookPrOptions` to support setting and getting the code name property of the workbook Re-order fields of the workbook properties group to improve the compatibility Go Modules dependencies upgrade Put workbook related operating in new `workbook.go` source code Library introduction docs block updated
* 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`
* Fix adjustMergeCellsHelper and add some test cases (#1082)Dokiy2021-12-06
| | | Signed-off-by: Dokiys <dokiychang@gmail.com>
* Speed up merge cellsthree2021-08-13
|
* This closes #979, fix the data validation deletion issue and tidy the ↵xuri2021-08-06
| | | | internal function in the source code
* Prevent panic when incorrect range is provided as PivotTableRange to (#874)Deepak S2021-07-10
|
* 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
* 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
|
* Fix issue #686 RemoveRow slice bounds out of range (#687)Wang Yaoshen2020-08-14
| | | fix Hyperlinks update error
* Update docs and typo fixedxuri2020-06-22
|
* Performance improvementsxuri2020-04-05
|
* 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
* Improve compatibility, fix workbook's rels ID calc errorxuri2019-12-23
|
* Fix #533, add support overlapped mergecellsxuri2019-12-14
|
* Documentation updated, Go 1.10+ requiredxuri2019-08-11
|
* Fixed doc corruption when deleting all merged cellsxuri2019-08-03
|
* Fix #437, recalculate offset for merged cells adjusterxuri2019-07-20
|
* Fix #424, refactor merged cells adjusterxuri2019-06-12
|
* Fixed #418, #420, #421, init adjust calculation chain supportxuri2019-06-08
| | | | Update testing case
* 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
* 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
generated by cgit v1.2.1 (git 2.18.0) at 2025-04-16 00:30:39 +0000