summaryrefslogtreecommitdiff
path: root/excelize_test.go
Commit message (Collapse)AuthorAge
...
* 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.
* Update the Godocxuri2019-08-21
|
* Handle multi row inline stringsHarris2019-08-09
| | | | | | | | | The inline string struct is actually the same as the shared strings struct, reuse it. Note that Go version 1.10 is required. Fixes #462
* Further improve read performanceHarris2019-08-07
| | | | | | | | | | | | | Instead of re-encoding the full sheet to change the namespaces in the encoded bytes, read the sheet again and do the byte replacements there. In this case, file access ends up being more performant than marshaling the sheet back to XML. In the SharedStrings test, ensure the strings are actually read. Fix #439
* Resolve #217, new function add VBA project supported.xuri2019-07-21
|
* Add TIF, TIFF format images and more detailed error information when open ↵xuri2019-06-27
| | | | the encrypted file
* New functions: SetDefinedName and GetDefinedName addedxuri2019-06-18
|
* Fix #422, avoid accent theme color index overflowxuri2019-06-09
|
* - Supplemental worksheet struct fields and field order adjustmentxuri2019-06-05
| | | | | - Testing case for set and get doc properties - Update charts struct XML tags
* Resolve #397, support set style by columnsxuri2019-05-16
|
* Resolve #394, init set header and footer supportxuri2019-05-05
|
* Resolve #393, upgrade Go module to v2xuri2019-05-02
|
* Add a check for maximum limit hyperlinks in a worksheetxuri2019-04-21
| | | | typo fixed
* add unit tests to functionsxuri2019-04-16
|
* Resolve #369,#370xuri2019-04-15
| | | | | | | | | | | | | | | | | | add error return value exported functions: GetMergeCells ProtectSheet UnprotectSheet UpdateLinkedValue GetMergeCells SetSheetVisible inner functions: workSheetReader copySheet
* Add unit test to improve testing coveragexuri2019-03-24
|
* 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
* resolve #360, fix axis parse issue when add / get pictures;xuri2019-03-20
| | | | typo fixed and go test updated
* 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
* update go test and function docscaozhiyi2019-03-07
|
* Implement consistent row addressing by Excel row number starting with 1 (#350)Veniamin Albaev2019-03-06
| | | | | | | | | | | | | | | * Implement consistent row addressing by Excel row number starting with 1 1. Added second versions for all row manipulation methods with zero-based row addressing. 2. Fixed methods documentation to explicitly describe which row addressing used in method. 3. Added WARNING to README.md. 4. Cosmetic change: All row test moved to file `rows_test.go`. * TravisCI: go1.12 added to tests matrix * BACKWARD INCOMPARTIBLE: Use only Excel numbering logic from 1 row * README updated
* Resolve #274, performance optimization for add images, charts and shapesxuri2019-02-25
|
* resolve the issue corrupted xlsx after deleting formula of cell, reference #346xuri2019-02-22
|
* Faster TitleToNumber (#343)Olivier Mengué2019-02-02
| | | | | | | | | | | | * TestTitleToNumber: more test cases * TitleToNumber: drop use of math.Pow() Compute using pure integers * TitleToNumber: simplify Remove unecessary casts to int
* New feature: File.DuplicateRowTo() duplicate row to specified row position.Veniamin Albaev2019-01-10
| | | | | | | | DuplicateRowTo() is similar to DuplicateRow() but copies specified row not just after specified source row but to any other specified position below or above source row. Also I made minor modifications of tests: using filepath.Join() instead of direct unix-way paths strings to avoid possible tests fails on other OS.
* README updatedxuri2019-01-01
|
* Tests refactoringVeniamin Albaev2018-12-27
| | | | | | | | | | | Primary motivation: Avoid statefull tests with not ignorable git file tree changes. Multiple tests reads and overwrites signle file for won needs. Multiple tests reads and overwrites file under version control. Secondary motivation: Minimal tests logic aligment, separate error expectation and not error expectation tests. Introduce sub-test over test data sets and so far. This commit is not ideal but necessary (IMHO)
* New feature: the function `SearchSheet` now support regular expression, ↵xuri2018-12-26
| | | | relate pull request #316
* Duplicate row (#317)Veniamin Albaev2018-12-26
| | | | | | * go mod tidy applied * File.DuplicateRow() method added
* Add RegSearchSheet (#316)r-uchino2018-12-26
|
* Resolve #311, create 2D/3D area, stacked area, 100% stacked area chart supportxuri2018-12-23
|
* Merge pull request #313 from sairoutine/feature/get_merge_cellsxuri2018-12-19
|\ | | | | Add GetMergeCells
| * Add GetMergeCellssairoutine2018-12-19
| |