summaryrefslogtreecommitdiff
path: root/cell.go
Commit message (Collapse)AuthorAge
* Add a check for maximum limit hyperlinks in a worksheetxuri2019-04-21
| | | | typo fixed
* godoc update and typo fixedxuri2019-04-20
|
* 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
* Check max length for SetCellStr and fix coordinate issue for MergeCellxuri2019-04-14
|
* Fix out of range panic when removing formula.Aplulu2019-04-09
| | | | Fix file corruption issue when deleting a sheet containing a formula.
* 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
* Use bitSize for float32 type numbers conversion, relate PR #361xuri2019-03-21
|
* SetCellFloat for floats with specific precision (#361)Michael2019-03-21
| | | | | | This allows the user to set a floating point value into a cell with a specific number of places after the decimal. Closes #357
* 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
* resolve the issue corrupted xlsx after deleting formula of cell, reference #346xuri2019-02-22
|
* README updatedxuri2019-01-01
|
* fix issue #290peiqi2018-11-08
|
* Comments style changed.xuri2018-09-14
|
* Comments style changed.xuri2018-09-14
|
* Comments style changed.xuri2018-09-14
|
* Fix golint errors under confidence 0.1xuri2018-09-12
|
* Fixes #256 and format document.xuri2018-08-06
|
* - Initialize shared formula types support, relate issue #227;xuri2018-05-26
| | | | - go test and godoc has been updated
* - 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
* - 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
* xlsx.SetCellValue() now supports bool valuedvelderp2018-01-25
|
* make SetCellStyle quicker by skipping conversions in checkCellInArea, and ↵mbresson2018-01-19
| | | | | | skipping area checks when we are sure the cell can't be before or past the current row/col Signed-off-by: Matthieu Bresson
* - Function `SetCellValue()` time.Duration support added, relate issue #176;Ri Xu2018-01-05
| | | | - go test updated
* Rename import path to github.com/360EntSecGroup-Skylar/excelizeJinzhu2017-11-16
|
* - Bugfix: use sheet name in func `AddPicture`, relate issue #142;Ri Xu2017-10-31
| | | | - godoc updated
* - Add unsigned integer data type support, related issue #136;Ri Xu2017-10-18
| | | | | | - go test and godoc updated Signed-off-by: Ri Xu <xuri.me@gmail.com>
* Performance optimization, use the array index instead of the value in range.Ri Xu2017-10-16
|
* Improve code readability.Ri Xu2017-09-30
|
* Handle coordinate parse exception, relate issue #122.Ri Xu2017-09-19
|
* 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
* Golang 1.9 compatible, fix issue #111Ri Xu2017-09-01
|
* - New function `GetCellHyperLink()` added, relate issue #98;Ri Xu2017-08-08
| | | | - go test added
* Fix round-off error in representation of date and time valuesTakayuki Usui2017-07-31
|
* Optimize code, go test and godoc updated.Ri Xu2017-07-30
|
* Add extra argument "Linktype" to SetCellHyperLinkYoungwan Kim2017-07-30
| | | | | | it support "External" and "Location" Signed-off-by: Youngwan Kim <y103.kim@gmail.com>
* - Add number format code with unicode values, relate issue #86;Ri Xu2017-07-26
| | | | - godoc updated
* - Init insert/remove column/row support. Relate issue #77 and #82;Ri Xu2017-07-24
| | | | - Readme and go test updated
* Bugfix: unable to read the value of the merged cell, relate issue #78Ri Xu2017-07-05
|
* Function `GetCellValue()` performance improvement by avoid repeating ↵Ri Xu2017-06-29
| | | | deserialization, relate issue #70.
* - 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
* - Function `formattedValue()` performance improvement by avoid repeating ↵Ri Xu2017-06-26
| | | | | | deserialization, relate issue #64; - Make function `ToAlphaString()` exportable, relate issue #63
* Code optimize.Ri Xu2017-05-24
|
* Handle number formats out of built-in range exception by returning raw ↵Ri Xu2017-05-05
| | | | value, relate issue #50.
* - Formatted cell data support, fix issue #48;Ri Xu2017-05-05
| | | | | - Function `SetCellValue()` support `time.Time` data type parameter, relate issue #49; - go doc and go test updated
* Performance improvementRi Xu2017-03-12
|
* - Complete the element `sheetFormatPr` struct definition;Ri Xu2017-03-10
| | | | | | - Partial logic performance optimization, use pointer reference instead of a pass the variable value; - Add comments for content types struct definition; - Update go test `TestSetBorder` section
* - New feature: border setting support (Related issue #21);Ri Xu2017-03-06
| | | | | | - Function parameter code is simplified; - Fix element `Tint` value parsing error in worksheet; - Update go test
* - Improved performance when reading large files, call Token to read tokens ↵Ri Xu2017-02-12
| | | | | | | one by one instead Unmarshal. Related issue #20 ; - Fix go test typo; - Update README