| Commit message (Collapse) | Author | Age |
|
|
|
|
|
|
|
|
|
|
|
| |
* TestTitleToNumber: more test cases
* TitleToNumber: drop use of math.Pow()
Compute using pure integers
* TitleToNumber: simplify
Remove unecessary casts to int
|
| |
|
|
|
| |
new feature: protect sheet support, relate issue #273
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
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
```
|
|
|
|
|
|
| |
`AddPicture()`, `AddShape()`, `AddTable()` and `SetConditionalFormat()`
- go test has been updated
|
| |
|
|
|
|
|
|
| |
skipping area checks when we are sure the cell can't be before or past the current row/col
Signed-off-by: Matthieu Bresson
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
Two new methods:
- SetSheetViewOptions(sheetName string, viewIndex int, opts ...SheetViewOption) error
- GetSheetViewOptions(sheetName string, viewIndex int, opts ...SheetViewOptionPtr) error
The option values are given by the user through types that have privates methods
that implement the private SheetViewOption and SheetViewOptionPtr interfaces:
- DefaultGridColor(bool)
- RightToLeft(bool)
- ShowFormulas(bool)
- ShowGridLines(bool)
- ShowRowColHeaders(bool)
Examples:
err := xl.SetSheetViewOptions("Sheet1", -1, excelize.ShowGridLines(true))
var showGridLines excelize.ShowGridLines
err := xl.GetSheetViewOptions("Sheet1", -1, &showGridLines)
Fixes #145.
|
| |
|
| |
|
| |
|
| |
|
|
|
|
|
|
| |
`ToAlphaString()` return value calculation changes, get more info from go doc. Relate issue #63;
- Readme and go doc updated
|
|
|
|
|
|
| |
deserialization, relate issue #64;
- Make function `ToAlphaString()` exportable, relate issue #63
|
|
|
|
|
|
| |
- Function parameter code is simplified;
- Fix element `Tint` value parsing error in worksheet;
- Update go test
|
| |
|
|
|
|
|
|
|
| |
one by one instead Unmarshal. Related issue #20 ;
- Fix go test typo;
- Update README
|
| |
|
| |
|
| |
|
|
|
|
|
|
|
| |
and set column width;
- Add escape characters of sheet name;
- Update go test and fix typo
|
|
|
|
|
|
| |
`workBookCompatibility` functions;
- New functions `GetActiveSheetIndex`, `GetSheetName` and `GetSheetMap` added.
|
|
|
|
|
|
| |
after save;
- Update workbook and sheet relationships and self-close tag replacement hack functions
|
| |
|
| |
|
| |
|
|
|
|
| |
linked values within a spreadsheet are not updating.
|
| |
|
| |
|
| |
|
|
|
|
| |
function; 3) Update test file.
|
|
|