summaryrefslogtreecommitdiff
path: root/excelize_test.go
Commit message (Collapse)AuthorAge
* 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
|
* - Fix `checkCellInArea()` index out of range when merged cell ref is single ↵Ri Xu2018-04-08
| | | | | | | coordinate, relate issue #206; - go test updated; - Repository icon for SourceTree has been added
* - Make row index consistent in function `SetRowHeight` and `GetRowHeight`, ↵Ri Xu2018-04-02
| | | | | | fix issue #205; - go test and godoc has been updated
* - Add categories or values on reverse order (orientation of the chart) ↵Ri Xu2018-03-29
| | | | | | support, and set auto or fixed maximum, minimum of the axis, relate issue #202; - go test and godoc has been updated
* - Update the function `NewSheet()` to handle when already exists a worksheet ↵Ri Xu2018-03-16
| | | | | | of the same name, relate pull request #196; - go test and godoc has been updated
* - New function `SetSheetRow()` has been added for support write whole line ↵Ri Xu2018-03-12
| | | | | | | at once, relate issue #96 and #194; - go test and godoc updated; - Note that this function performance has not been tested
* - Add protection properties associated with the cell support, relate issue #191;Ri Xu2018-03-07
| | | | - godoc and go test has been updated
* Readme and godoc has been updated.Ri Xu2018-03-06
|
* - Update the function `AddChart()`: clustered, stacked and 100% stacked bar ↵Ri Xu2018-03-05
| | | | | | and column series charts supported, relate issue #190; - go test and godoc has been updated
* Handle special shared string table file name `xl/SharedStrings.xml`, relate ↵Ri Xu2018-03-02
| | | | issue #188
* Update godoc to make charts compatibility with WPS, relate issue #187.Ri Xu2018-02-12
|
* - Add a hyperlink to an image support for the function `AddPicture()`, ↵Ri Xu2018-02-03
| | | | | | relate issue #185; - go test and document has been updated.
* xlsx.SetCellValue() now supports bool valuedvelderp2018-01-25
|
generated by cgit v1.2.1 (git 2.18.0) at 2025-04-19 01:09:25 +0000