155 Commits (master)

Author	SHA1	Message	Date
xuri	f2df344739	Resolve #369,#370 ... add error return value exported functions: GetMergeCells ProtectSheet UnprotectSheet UpdateLinkedValue GetMergeCells SetSheetVisible inner functions: workSheetReader copySheet	6 years ago
xuri	40ff5dc1a7	refactor: handler error instead of panic, ... 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	6 years ago
Veniamin Albaev	dc01264562	Huge refactorig for consistent col/row numbering (#356) ... * 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	6 years ago
Michael W. Mitton	5dd00b9a00	Do not create a blank fill if no fill is specified in the style format	6 years ago
xuri	fabd9d013f	README updated	6 years ago
xuri	1c45425f12	resolve #276, add OfficeOpenXML-XMLSchema-Strict mode support	6 years ago
xuri	3e004d900b	Comments style changed.	6 years ago
xuri	13a9769cc5	Comments style changed.	6 years ago
xuri	2f146c923c	Comments style changed.	6 years ago
xuri	b4a6e61ec3	Fix golint errors under confidence 0.1	6 years ago
xuri	ec37b114c3	Fixes #256 and format document.	7 years ago
Alex Whitney	db7a605cf8	Use min/mid/max value for 2 and 3 color scale conditional formatting	7 years ago
xuri	79dfe1c307	GoDoc updated.	7 years ago
xuri	d6468fc114	- Initialize theme support; ... - RGBA, HSL color convert has been added; - go test updated	7 years ago
xuri	9cb0e9308b	- Update Travis CI to include GOARCH=386 tests, relate issue #239 and #244; ... - Fix doc typo	7 years ago
xuri	9e463b4614	- Add error return value for functions: `AddChart()`, `AddComment()`, `AddPicture()`, `AddShape()`, `AddTable()` and `SetConditionalFormat()` ... - go test has been updated	7 years ago
xuri	e8961f0aff	- Bugfix: set font family not works, relate issue #222; ... - Remove useless function `replaceWorkSheetsRelationshipsNameSpace()`; - Make test cases use strict error checking	7 years ago
Lunny Xiao	38ad20efc1	save bytes on memory instead of string	7 years ago
Ri Xu	200437d778	Fix document typo.	7 years ago
Ri Xu	9ee57fdb38	Fix typo and adding Chinese version document.	7 years ago
Ri Xu	ecc3adf22a	- Add protection properties associated with the cell support, relate issue #191; ... - godoc and go test has been updated	7 years ago
Ri Xu	638bd44dd5	- gofmted with -s; ... - Fix ineffectual assignments in Go code; - Godoc has been updated	7 years ago
Martin Sandve Alnæs	e556c25047	Avoid looping over unused rows and columns in SetCellStyle. ... The recent improvement to SetCellStyle still loops over all the rows before the area, moving the area checks into the loop is more concise and faster. Since the loop now covers the correct area by construction, the inner loop check checkCellInArea is no longer needed.	7 years ago
mbresson	317ef65381	make SetCellStyle quicker by skipping conversions in checkCellInArea, and skipping area checks when we are sure the cell can't be before or past the current row/col ... Signed-off-by: Matthieu Bresson	7 years ago
Ri Xu	76366fc1d9	Travis CI config updated and typo fixed.	7 years ago
Ri Xu	07a4140098	- 24 hour time format supported, relate issue #163; ... - godoc and go test updated	7 years ago
Ri Xu	905be463ed	Improve code readability.	7 years ago
Ri Xu	e820388d70	Handle coordinate parse exception, relate issue #122.	7 years ago
Ri Xu	f05f799f8d	- API changed, use worksheet name instead of "sheet" + index, related issue #25, #43, #47, #51, #89, #101, #116 and #120. ... - go test updated	7 years ago
Ri Xu	77af25295e	- Conditional format with formula support, relate issue #75; ... - go test and readme update	8 years ago
Ri Xu	845e339755	Document updated.	8 years ago
Ri Xu	67636039f6	- Init conditional format support, relate issue #75; ... - go test and godoc updated	8 years ago
Ri Xu	5cf3725f02	Add missing element `xfId` of the styles to fix issue #93.	8 years ago
Ri Xu	961996a813	- Fix `completeCol()` make extra rows, relate issue #87; ... - godoc updated	8 years ago
Ri Xu	4a74951e81	- Support set custom number format, relate issue #86; ... - go test and godoc updated	8 years ago
Ri Xu	8493fea373	- Add number format code with unicode values, relate issue #86; ... - godoc updated	8 years ago
Ri Xu	4f942255e4	- Fix missing element in worksheet, workbook and styles. Related issue #81; ... - Format code and update readme	8 years ago
Ri Xu	4b7d21bb63	Currency format code added.	8 years ago
Ri Xu	101abe8e98	Add currency format code and go test updated.	8 years ago
Ri Xu	60fa5a5be1	- Display negative numbers by applying a red color supported; ... - go test updated	8 years ago
Ri Xu	bc31e545c8	- Currency format supported, relate issue #80; ... - go test and godoc updated	8 years ago
Ri Xu	654a676d93	- New function `NewStyle()` added and function `SetCellStyle()` has been exported, relate issue #72; ... - go test and go doc updated	8 years ago
Ri Xu	e05867a033	Function `GetCellValue()` performance improvement by avoid repeating deserialization, relate issue #70.	8 years ago
Ri Xu	555e2ba9a8	- Make function `TitleToNumber()` exportable, note that function `ToAlphaString()` return value calculation changes, get more info from go doc. Relate issue #63; ... - Readme and go doc updated	8 years ago
Ri Xu	35841caaf1	- Function `formattedValue()` performance improvement by avoid repeating deserialization, relate issue #64; ... - Make function `ToAlphaString()` exportable, relate issue #63	8 years ago
Ri Xu	efff54ccde	- Fixed coordinate parse error in function `SetCellStyle()`, relate issue #60; ... - Simplified code	8 years ago
Ri Xu	8fbab47444	- Formatted cell data support, fix issue #48; ... - Function `SetCellValue()` support `time.Time` data type parameter, relate issue #49; - go doc and go test updated	8 years ago
Ri Xu	266d2c36e5	- Font bold, italic and underline style support. Relate issue #45; ... - Function `GetRows()` doc updated, relate issue #43; - go test and embed template updated	8 years ago
Ri Xu	6e287839ec	- Set number format for a cell support; ... - go test updated	8 years ago
Ri Xu	7ceb4f21ad	Godoc updated.	8 years ago
Ri Xu	b6254209fe	- Set text in cell align support, note that the parameters of the `SetCellStyle` function have changed; ... - go test updated	8 years ago
Ri Xu	68b4d1f546	- Set cell background color and style support; ... - Rename function `SetBorder` to `SetCellStyle`; - Complete `xlsxColor` structure definition; - go test updated	8 years ago
Ri Xu	de6e075713	Performance improvement	8 years ago
Ri Xu	5384756d64	- Complete the element `sheetFormatPr` struct definition; ... - 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	8 years ago
Ri Xu	1f73f08185	- New feature: border setting support (Related issue #21); ... - Function parameter code is simplified; - Fix element `Tint` value parsing error in worksheet; - Update go test	8 years ago