summaryrefslogtreecommitdiff
path: root/sheet.go
Commit message (Collapse)AuthorAge
* Fix golint errors under confidence 0.1xuri2018-09-12
|
* Fixes #256 and format document.xuri2018-08-06
|
* Bugfix: create worksheet cause file issue. Relate issue #249.xuri2018-07-17
|
* 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
* - 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
|
* save bytes on memory instead of stringLunny Xiao2018-05-07
|
* Fix document typo.Ri Xu2018-05-03
|
* - Support to set the positioning of a picture, relate issue #214;Ri Xu2018-04-26
| | | | - 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
* Readme and godoc has been updated.Ri Xu2018-03-06
|
* - Fix `DeleteSheet()` make broken file, relate issue #165;Ri Xu2017-12-04
| | | | - godoc updated
* - Bugfix: use sheet name in func `AddPicture`, relate issue #142;Ri Xu2017-10-31
| | | | - godoc updated
* Bugfix: use sheet name in func `AddChat`, relate issue #138Ri Xu2017-10-20
| | | | Signed-off-by: Ri Xu <xuri.me@gmail.com>
* Improve code readability.Ri Xu2017-09-30
|
* godoc updated.Ri Xu2017-09-13
|
* - API changed, use worksheet name instead of "sheet" + index, related issue ↵Ri Xu2017-09-13
| | | | | | #25, #43, #47, #51, #89, #101, #116 and #120. - go test updated
* Bugfix: deep copy issue with function `CopySheet()`, relate PR #108.Ri Xu2017-08-19
|
* Conut and trim sheet name in UTF-8Takayuki Usui2017-08-13
|
* Simplify code and update unit tests.Ri Xu2017-08-01
|
* Optimize code, go test and godoc updated.Ri Xu2017-07-30
|
* - Init create or remove panes support;Ri Xu2017-07-30
| | | | - go test updated
* Trim blank cells which created by `completeCol()`, relate issue #81Ri Xu2017-07-16
|
* SHEET.GO: Fix small typoMark Stenglein2017-07-05
| | | | | | Adds a '{' to the example for sheet.GetSheetMap() Signed-off-by: Mark Stenglein <mark@stengle.in>
* - Make function `TitleToNumber()` exportable, note that function ↵Ri Xu2017-06-27
| | | | | | `ToAlphaString()` return value calculation changes, get more info from go doc. Relate issue #63; - Readme and go doc updated
* - New functions: `GetSheetVisible()` and `GetRowVisible()` added, relate ↵Ri Xu2017-06-14
| | | | | | issue #61; - go test updated
* Init auto filter support, relate issue #59.Ri Xu2017-06-08
|
* Code optimize.Ri Xu2017-05-24
|
* Initialize comments support & go test updated.Ri Xu2017-05-13
|
* - Initialize shape support: new function `AddShape()` added. Relate issue #38;Ri Xu2017-04-30
| | | | | - Drawing `nvPicPr` element ID property calculation changed; - go test updated
* - New function `HideSheet()` and `UnhideSheet()` added;Ri Xu2017-04-26
| | | | - go test updated
* - New function `CopySheet()` added, relate issue #33;Ri Xu2017-04-04
| | | | | - Typo fixed; - go test updated
* New function `GetSheetIndex()` added, relate issue #25;Ri Xu2017-04-01
| | | | | | Fix return index error in function `GetSheetMap()`; Fix return worksheet name error in function `GetSheetName()`; go test updated
* - Fix SheetCount count error;Ri Xu2017-04-01
| | | | | - Optimize deserialization operations; - README updated, add go version required notice
* - Get an images in a cell supported, new function `GetPicture` added;Ri Xu2017-03-28
| | | | - go test updated
* - Delete sheet from workbook support, related issue #30;Ri Xu2017-03-22
| | | | - go test updated
* Performance improvementRi Xu2017-03-12
|
* Support set work sheet background image.Ri Xu2017-01-24
|
* Update README, godoc and fix typo.Ri Xu2017-01-22
|
* - Add hyperlink and set formula support for cell support;Ri Xu2017-01-19
| | | | | - Character limits for cells added; - Update go test and fix typo
* Format commants, break comments after 80 characters.Ri Xu2017-01-18
|
* - New function `SetSheetName` and `SetColWidth` added, support rename sheet ↵Ri Xu2017-01-18
| | | | | | | and set column width; - Add escape characters of sheet name; - Update go test and fix typo
* - Performance improvement, remove `replaceRelationshipsID` and ↵Ri Xu2016-12-31
| | | | | | `workBookCompatibility` functions; - New functions `GetActiveSheetIndex`, `GetSheetName` and `GetSheetMap` added.
* - Fix issue: sheet protection and conditional formatting proprietary missing ↵Ri Xu2016-12-26
| | | | | | after save; - Update workbook and sheet relationships and self-close tag replacement hack functions
* - Fix issue: pivot cache and extending spreadsheetML missing;Ri Xu2016-12-26
| | | | - Compatibility improved: relationship namespace in `workbook.xml` has been changed (`xmlns:mc`, `xmlns:x15` and `mc:Ignorable` added)
* - Update maximum 31 characters allowed in sheet title;Ri Xu2016-12-23
| | | | | | | - Fix issue XML tag `headerFooter` and `sheetPr` element self-close errors cause file corruption; - Fix issue `Section` and `Pane` element order make file corruption in some case; - Change sheet `rId` calculation method in `/xl/workbook.xml`, fix makes file corruption in some case; - Compatibility improved: add `xlsxTabColor` struct and some XML element for worksheet
* - Fix issue comments missing after save;Ri Xu2016-12-22
| | | | | - Update import PKG syntax in struct; - Update test XLSX file (include table, charts, functions, comments and hyperlink on Sheet1)
* - Fix issue background image and table missing after save;Ri Xu2016-12-20
| | | | - Update test template for this fix
* Fix hyperlink missing after save issue and update completion row element ↵Ri Xu2016-12-20
| | | | logic to enhance compatibility.