summaryrefslogtreecommitdiff
path: root/excelize_test.go
Commit message (Collapse)AuthorAge
* Format code, update documentation and remove exported variable `XMLHeaderByte`xuri2022-03-24
|
* ref #65, new formula functions and read boolean data type cell value supportxuri2022-03-08
| | | | * added 3 new formula functions: BETAINV, BETA.INV, F.INV.RT
* 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`
* Typo fix, rename exported constants, dependencies modules and copyright updatexuri2022-01-09
| | | | Rename exported constants `NameSpaceDublinCoreMetadataIntiative` to `NameSpaceDublinCoreMetadataInitiative`
* feat: implement SHA-512 algorithm to ProtectSheet (#1115)Jonham.Chen2022-01-08
|
* 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
* This closes #1097, initialized formula function XLOOKUP and update testxuri2021-12-25
|
* Export 7 errors so users can act differently on different type of errorsxuri2021-12-07
|
* 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%
* Add set shared formula support and documentation for the `SetCellFormula`xuri2021-09-03
|
* This closes #844, support get shared formularaochq2021-08-15
|
* Improve security and simplify codexuri2021-08-15
| | | | | | | - Make variable name more semantic - Reduce cyclomatic complexities for the formula calculate function - Support specified unzip size limit on open file options, avoid zip bombs vulnerability attack - Typo fix for documentation and error message
* change go module import path to github.com/xuri/excelizexuri2021-07-28
|
* This closes #872, support re-save the new spreadsheet after `SaveAs`xuri2021-07-09
|
* - Support concurrency iterate rows and columnsxuri2021-07-05
| | | | | - Rename exported field `File.XLSX` to `File.Pkg` - Exported error message
* This closes #861, support concurrency get cell picture and remove unused ↵xuri2021-07-04
| | | | internal function `getSheetNameByID`
* This closes #409 Remove UTC timezone requirement from date.go (#853)Alluuu2021-06-04
| | | | | | | According to issue #409 There is absolutely no reason for the timezone to be in UTC, and converting the local times to UTC while keeping values is hacky at least. Excel has no understanding of timezones, hence the user of this library should know what timezone their values are supposed to be, by following the timezone within their timeTime structs.
* This closes #652, new SetColWidth API, support set column width in stream ↵xuri2021-05-10
| | | | writing mode, and export error message
* Fixe issue generated file corrupted caused by incorrect default XML ↵xuri2021-04-30
| | | | namespace attributes
* #65 fn: N, PERCENTILE.INC and Txuri2021-03-30
| | | | typo fixed
* Add support for setting hyperlink display & tooltip (closes #790) (#794)James Allen2021-03-03
|
* lint issue fixed and new formula function: ATAN, AVERAGE, AVERAGEA, CONCAT, ↵xuri2021-02-15
| | | | CONCATENATE, COUNT, COUNTBLANK, MAX
* Fix #724, standardize variable naming and update unit testsxuri2020-11-11
|
* using POSIX directory separator in zip path with Windowsxuri2020-11-06
|
* Compatibility improvement: parse document core part (workbook) dynamicallyxuri2020-11-04
|
* Update conversion between integer types and unit testsxuri2020-10-23
|
* 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>
* support ECMA-376 document standard encryption, ref #199xuri2020-09-02
|
* Resolve #199, init password protection spreadsheet supportxuri2020-09-01
|
* support case-sensitive doc parts to improve compatibilityxuri2020-07-09
|
* add limits for total columns, row and filename lengthxuri2020-05-29
|
* Resolve #643, avoid creating duplicate stylexuri2020-05-24
|
* add test for ReadZipReader, close #642xuri2020-05-23
|
* - Resolve #485 use sheet index instead of IDxuri2020-04-23
| | | | - added 3 internal function: getSheetID, getActiveSheetID, getSheetNameByID
* Resolve #345, fix missing comments by GetCommentsxuri2020-03-31
|
* Resolve #200, ignore empty conditional format stylexuri2020-03-16
|
* Resolve #470, export Style structs to allow create the style for cells by ↵xuri2020-03-10
| | | | given JSON or structure
* 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
|
* 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
|
* Improve code coverage unit testsxuri2019-12-22
|
* Fix #533, add support overlapped mergecellsxuri2019-12-14
|
* Resolve #507, add the new function `DeleteDefinedName`xuri2019-10-26
|
* Pre-allocate some memory when reading files (#510)Michael2019-10-24
|
* Fix #482, font strike style supportxuri2019-09-23
|
* Allow access to more formula attributes in SetCellFormula (#484)Christian Fiedler2019-09-22
| | | | | | | | | | | | | | | | | | * Allow access to more formula attributes in SetCellFormula Make SetCellFormula variadic to not break API. The new arguments are option arguments in which the type of the formula and the ref attribute may be set. These need to be set for an array formula to work. * Add TestWriteArrayFormula to test optional parameters of SetCellFormula TestWriteArrayFormula writes a document to the test directory that contains array formulas that are used to calculate standard deviations. The file also contains values calculated by the Go testcase, so the results can be verified. It should be tested, if the array formula works (i.e. shows a number, not an error) and that the values calculated by the formula and those calculated by Go are the same.