summaryrefslogtreecommitdiff
path: root/excelize_test.go
Commit message (Collapse)AuthorAge
* 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
| |
* | Add new logo for excelizexuri2018-12-05
| |
* | New function `UnprotectSheet()` has been addedq5235912018-11-04
| |
* | resolve #273 new feature: protect sheet supportHcySunYang2018-11-02
| | | | | | new feature: protect sheet support, relate issue #273
* | Add testing case for the function `SearchSheet()`.covv2018-10-27
| |
* | Fix the issue caused by missing tradition to strict conversion for ↵xuri2018-10-18
| | | | | | | | `sharedStringsReader()`, relate issue #276
* | feat: add new function and refactor writeto actionlizheao2018-10-12
| | | | | | | | | | | | * add new exported function to get Excel file content buffer * refactor the WriteTo function
* | New function `AddPictureFromBytes()` has been added, this resolve #259 and ↵xuri2018-09-14
|/ | | | close #271.
* Bugfix: create worksheet cause file issue. Relate issue #249.xuri2018-07-17
|
* Merge pull request #246 from nad2000/retrieve-commentsxuri2018-07-10
|\ | | | | added retrieval of worksheet comments
| * added unit testsRad Cirskis2018-06-30
| |
* | - Initialize theme support;xuri2018-07-07
|/ | | | | - RGBA, HSL color convert has been added; - go test updated
* CopySheet() using reflect instead of encoding/gobOlivier Mengué2018-06-14
| | | | | | | | | | | | | | | | | | | Use github.com/mohae/deepcopy to deep copy worksheets instead of the internal deepcopy function that was using encoding/gob serialization and deserialization. Rationale: 1/ using `encoding/gob` is much slower than [`mohae/deepcopy`](https://github.com/mohae/deepcopy/) 2/ When building an application this implementation of `deepcopy` drags the `encoding/gob` package into the binary. And this package is much bigger than `mohae/deepcopy` (which only depends on `time` and `reflect`). ``` $ LC_ALL=C stat -f "%6z %N" $(go env GOPATH)/pkg/$(go env GOOS)_$(go env GOARCH)/github.com/mohae/deepcopy.a $(go env GOROOT)/pkg/$(go env GOOS)_$(go env GOARCH)/encoding/gob.a 10508 .../pkg/darwin_amd64/github.com/mohae/deepcopy.a 541818 .../pkg/darwin_amd64/encoding/gob.a ```
* - Add error return value for functions: `AddChart()`, `AddComment()`, ↵xuri2018-05-27
| | | | | | `AddPicture()`, `AddShape()`, `AddTable()` and `SetConditionalFormat()` - go test has been updated
* - Initialize shared formula types support, relate issue #227;xuri2018-05-26
| | | | - go test and godoc has been updated
* - Performance optimization 20% faster, 14% memory savings on set cell values;xuri2018-05-15
| | | | | - Using the canonical syntax in issue template and contributing guide; - go test has been updated
* Improve unit testing, remove redundant code.xuri2018-05-14
|
* Simplify testing code, add test case for outline functions and update the godoc.xuri2018-05-11
|
* - Bugfix: set font family not works, relate issue #222;xuri2018-05-08
| | | | | - Remove useless function `replaceWorkSheetsRelationshipsNameSpace()`; - Make test cases use strict error checking
* Merge test cases and use strict error checking.Ri Xu2018-05-07
|
* - Set name of table support in `AddTable()`, relate issue #216;Ri Xu2018-05-04
| | | | - godoc and go test has been updated
* - Support to set the positioning of a picture, relate issue #214;Ri Xu2018-04-26
| | | | - go test and godoc has been updated
* Fix typo and adding Chinese version document.Ri Xu2018-04-23
|