summaryrefslogtreecommitdiff
path: root/sheet_test.go
Commit message (Collapse)AuthorAge
* Format code, update documentation and remove exported variable `XMLHeaderByte`xuri2022-03-24
|
* This closes #1162, improve the compatibility with alternate contentxuri2022-03-05
| | | | Preserve alternate content in the workbook, worksheet, and drawingML
* 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`
* Typo fix, rename exported constants, dependencies modules and copyright updatexuri2022-01-09
| | | | Rename exported constants `NameSpaceDublinCoreMetadataIntiative` to `NameSpaceDublinCoreMetadataInitiative`
* Export 7 errors so users can act differently on different type of errorsxuri2021-12-07
|
* Simplify code and update unit testxuri2021-12-03
| | | | | Improve unit test coverage for the functions: `NewStyle`, `SetActiveSheet`, `SearchSheet` and `deleteAndAdjustDefinedNames` Simplify code and add comments for the function: `deleteAndAdjustDefinedNames`
* This closes #1061, support multi-byte language on set header footerxuri2021-11-16
| | | | typo fixed and simplify code for read the data values arguments of formula functions
* 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 #873, make the sheet names are not case sensitive for ↵xuri2021-07-10
| | | | `NewSheet`, `GetSheetIndex`, `DeleteSheet`
* - Support concurrency iterate rows and columnsxuri2021-07-05
| | | | | - Rename exported field `File.XLSX` to `File.Pkg` - Exported error message
* lint issue fixed and new formula function: ATAN, AVERAGE, AVERAGEA, CONCAT, ↵xuri2021-02-15
| | | | CONCATENATE, COUNT, COUNTBLANK, MAX
* 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`
* support to set print black and white and specified the first printed page numberxuri2021-01-17
|
* Support to adjust print scaling of the worksheetxuri2021-01-16
|
* Fixed #735, refresh active tab after delete sheetxuri2020-11-23
|
* using POSIX directory separator in zip path with Windowsxuri2020-11-06
|
* optimize memory allocation (#722)Ted2020-11-03
| | | | | | | | | | | | | | | * optimize marshal * optimize mem alloc * add benchmark testing * add NewSheetWithRowNum testing * sync struct fields order * add BenchmarkNewSheetWithStreamWriter * delete NewSheetWithRowNum and benchmark test
* 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
* Fix #706, #713 improve AddPicture performance, fix missing worksheet when ↵xuri2020-10-18
| | | | rename with same names
* 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>
* - Resolve #485 use sheet index instead of IDxuri2020-04-23
| | | | - added 3 internal function: getSheetID, getActiveSheetID, getSheetNameByID
* Resolve #492, init support for insert and remove page breakxuri2020-03-01
|
* 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
|
* Resolve #507, add the new function `DeleteDefinedName`xuri2019-10-26
|
* Resolve #511, allow empty columns in the pivot tablexuri2019-10-24
|
* Optimize code of Getting/Setting Page Marginsxuri2019-10-17
|
* Added accessors for Getting/Setting Page Margins (#497)streboryaj2019-10-15
| | | | | | * Added accessors for Getting/Setting Page Margins * Added test cases
* Fix dependency on github.com/360EntSecGroup-Skylar/excelize v1Ben Wells2019-09-13
|
* Testing files updatedxuri2019-09-02
|
* Get sheet names based on indexHarris2019-08-08
| | | | | | | | SheetID only seems to indicate the file name for the sheet. Check the sheets list based on index instead. Reordering sheets in Excel changes the order they appear in that list. Fixes #457
* Add unit test for SetPageLayoutxuri2019-07-07
|
* Add unit test for GroupSheets and UngroupSheetsxuri2019-07-04
|
* New functions: SetDefinedName and GetDefinedName addedxuri2019-06-18
|
* Resolve #394, init set header and footer supportxuri2019-05-05
|
* Resolve #393, upgrade Go module to v2xuri2019-05-02
|
* add unit tests to functionsxuri2019-04-16
|
* The function SetPageLayout support set paper sizekkxkkxkkgh2019-01-13
|
* Resolve #318, add new functions andzhangleijlu2019-01-06