summaryrefslogtreecommitdiff
path: root/sheet.go
Commit message (Collapse)AuthorAge
...
* Make the functions `SetSheetRow`, `New Style` and `SetCellStyle` concurrency ↵xuri2021-07-07
| | | | safety
* Support concurrency add picturexuri2021-07-06
|
* - Support concurrency iterate rows and columnsxuri2021-07-05
| | | | | - Rename exported field `File.XLSX` to `File.Pkg` - Exported error message
* This closes #861, support concurrency get cell picture and remove unused ↵xuri2021-07-04
| | | | internal function `getSheetNameByID`
* fix: LocalSheetID in DefinedName should be equal to SheetIndex instead of ↵vettich2021-07-03
| | | | SheetID (#868)
* This closes #652, new SetColWidth API, support set column width in stream ↵xuri2021-05-10
| | | | writing mode, and export error message
* compatibility with non-standard page setup attributesxuri2021-05-07
|
* This closes #834, fix invalid file path and duplicate namespace when ↵xuri2021-05-06
| | | | re-creating worksheet
* Go 1.15 and later required, #65 fn: IMABS, IMCOS, IMCOSH, IMCOT, IMCSC, ↵xuri2021-04-04
| | | | IMCSCH, IMEXP, IMLN and IMLOG10
* #65 fn: N, PERCENTILE.INC and Txuri2021-03-30
| | | | typo fixed
* updated SetDefinedName's localSheetId attr to use sheetIndexDavid2021-03-21
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Excelize 2.3.2 OUT: ``` <sheets> <sheet name="Q-P-QP-11" sheetId="55" r:id="rId1"/> <sheet name="Q-P-QP-12" sheetId="53" r:id="rId2"/> <sheet name="Q-P-QP-13" sheetId="54" r:id="rId3"/> <sheet name="Q-P-RN-12" sheetId="56" r:id="rId4"/> <sheet name="Q-P-RN-13" sheetId="57" r:id="rId5"/> <sheet name="C-C-QP-11-12-13-RN-12-13" sheetId="50" r:id="rId6"/> <sheet name="E-T-QP-11-12-13" sheetId="31" r:id="rId7"/> <sheet name="E-T-BK" sheetId="60" r:id="rId8"/> <sheet name="E-A-RN-12-13" sheetId="43" r:id="rId9"/> <sheet name="F1-A-QP-11-12-13" sheetId="1" r:id="rId10"/> <sheet name="F2-A-QP-11-12-13" sheetId="23" r:id="rId11"/> <sheet name="C-A-QP-12-13-RN-12-13" sheetId="48" r:id="rId12"/> <sheet name="C-T-QP-12-13" sheetId="7" r:id="rId13"/> <sheet name="R-T-QP-12-RN-12-13" sheetId="45" r:id="rId14"/> <sheet name="C-T-QP-11" sheetId="58" r:id="rId15"/> <sheet name="R-T-QP-11" sheetId="3" r:id="rId16"/> <sheet name="A-T-QP-11-12-RN-12" sheetId="13" r:id="rId17"/> <sheet name="A2-T-RN-13" sheetId="42" r:id="rId18"/> <sheet name="ap-T-QP-11" sheetId="59" r:id="rId19"/> <sheet name="B-A-QP-12-13" sheetId="32" r:id="rId20"/> <sheet name="B-A-QP-11" sheetId="33" r:id="rId21"/> </sheets> <definedNames> <definedName localSheetId="58" name="_xlnm.Print_Titles">ap-T-QP-11!$2:$5</definedName> <definedName localSheetId="2" name="_xlnm.Print_Titles">R-T-QP-11!$2:$13</definedName> </definedNames> ``` MS Excel 2010 out ``` <sheets> <sheet name="Q-P-QP-11" sheetId="55" r:id="rId1"/> <sheet name="Q-P-QP-12" sheetId="53" r:id="rId2"/> <sheet name="Q-P-QP-13" sheetId="54" r:id="rId3"/> <sheet name="Q-P-RN-12" sheetId="56" r:id="rId4"/> <sheet name="Q-P-RN-13" sheetId="57" r:id="rId5"/> <sheet name="C-C-QP-11-12-13-RN-12-13" sheetId="50" r:id="rId6"/> <sheet name="E-T-QP-11-12-13" sheetId="31" r:id="rId7"/> <sheet name="E-T-BK" sheetId="60" r:id="rId8"/> <sheet name="E-A-RN-12-13" sheetId="43" r:id="rId9"/> <sheet name="F1-A-QP-11-12-13" sheetId="1" r:id="rId10"/> <sheet name="F2-A-QP-11-12-13" sheetId="23" r:id="rId11"/> <sheet name="C-A-QP-12-13-RN-12-13" sheetId="48" r:id="rId12"/> <sheet name="C-T-QP-12-13" sheetId="7" r:id="rId13"/> <sheet name="R-T-QP-12-RN-12-13" sheetId="45" r:id="rId14"/> <sheet name="C-T-QP-11" sheetId="58" r:id="rId15"/> <sheet name="R-T-QP-11" sheetId="3" r:id="rId16"/> <sheet name="A-T-QP-11-12-RN-12" sheetId="13" r:id="rId17"/> <sheet name="A2-T-RN-13" sheetId="42" r:id="rId18"/> <sheet name="ap-T-QP-11" sheetId="59" r:id="rId19"/> <sheet name="B-A-QP-12-13" sheetId="32" r:id="rId20"/> <sheet name="B-A-QP-11" sheetId="33" r:id="rId21"/> </sheets> <definedNames> <definedName name="_xlnm.Print_Titles" localSheetId="18">'ap-T-QP-11'!$2:$5</definedName> <definedName name="_xlnm.Print_Titles" localSheetId="15">'R-T-QP-11'!$2:$13</definedName> </definedNames> ``` Compare localSheetId it uses sheet index instead of sheet's sheetId
* This improves compatibility for absolute XML path, Windows-style directory ↵xuri2021-02-27
| | | | separator and inline namespace;
* check empty rich text run properties; new formula fn: LEFT, LEFTB, RIGHT, RIGHTBxuri2021-02-23
|
* lint issue fixed and new formula function: ATAN, AVERAGE, AVERAGEA, CONCAT, ↵xuri2021-02-15
| | | | CONCATENATE, COUNT, COUNTBLANK, MAX
* This improves compatibility for worksheet relative XML path and multi rules ↵xuri2021-02-11
| | | | auto filter
* fix custom row height check issuexuri2021-02-08
|
* This closes #774, closes #775 and closes #776xuri2021-02-02
| | | | | | | | - correct adjust calculation chain in duplicate rows - correct adjust defined name in the workbook when delete worksheet - use absolute reference in the auto filters defined name to make it compatible with OpenOffice - API `CoordinatesToCellName` have a new optional param to specify if using an absolute reference format - Fix cyclomatic complexity issue of internal function `newFills` and `parseToken`
* Fixed #764, add a condition for round precisionxuri2021-01-20
|
* support to set print black and white and specified the first printed page numberxuri2021-01-17
|
* Support to adjust print scaling of the worksheetxuri2021-01-16
|
* Fixed #735, refresh active tab after delete sheetxuri2020-11-23
|
* Fix #724, standardize variable naming and update unit testsxuri2020-11-11
|
* using POSIX directory separator in zip path with Windowsxuri2020-11-06
|
* Compatibility improvement: parse document core part (workbook) dynamicallyxuri2020-11-04
|
* optimize memory allocation (#722)Ted2020-11-03
| | | | | | | | | | | | | | | * optimize marshal * optimize mem alloc * add benchmark testing * add NewSheetWithRowNum testing * sync struct fields order * add BenchmarkNewSheetWithStreamWriter * delete NewSheetWithRowNum and benchmark test
* New formula function AND (#701) and update doc for the NewSheet (#714)xuri2020-10-22
|
* This closes #714 and closes #715, fix wrong worksheet index returned by ↵xuri2020-10-19
| | | | NewSheet in some case, fix panic on formatted value with no built-in number format ID
* Fix #706, #713 improve AddPicture performance, fix missing worksheet when ↵xuri2020-10-18
| | | | rename with same names
* - Resolve #711, update docs for the GetSheetIndexxuri2020-10-12
| | | | - Update unit test
* Default row height compatibility with Apache OpenOffice and Kingsoft WPS, ↵xuri2020-08-22
| | | | unit test update and typo fixed
* This closes #677 and closes #679, fix panic when enabling compiler inline flagsxuri2020-08-06
|
* support parse and generate XML element namespace dynamic, fix #651xuri2020-07-18
|
* Fix issue 665 (#666)jaby2020-07-14
|
* support case-sensitive doc parts to improve compatibilityxuri2020-07-09
|
* Update docs and typo fixedxuri2020-06-22
|
* - New API: SetSheetFormatPr and GetSheetFormatPrxuri2020-05-12
| | | | - typo fix, resolve #635
* init formula calculation engine, ref #65 and #599xuri2020-05-03
|
* handle the cell without r attribute in a row elementxuri2020-04-24
|
* - Resolve #485 use sheet index instead of IDxuri2020-04-23
| | | | - added 3 internal function: getSheetID, getActiveSheetID, getSheetNameByID
* Performance improvementsxuri2020-04-05
|
* remove ineffectual variable assignments and simplify codexuri2020-03-29
|
* Resolve #451, support create chart sheetxuri2020-03-28
|
* Resolve #492, init support for insert and remove page breakxuri2020-03-01
|
* Resolve #580, revert commit ↵xuri2020-02-19
| | | | https://github.com/360EntSecGroup-Skylar/excelize/commit/5ca7231ed408ac264f509ff52b5d28ff4fbda757
* Resolve #570, flat columns for the column's operationxuri2020-02-07
|
* optimize code and comments: use println errors instead of panicxuri2020-01-03
|
* Improve code coverage unit testsxuri2019-12-29
|
* Improve compatibility, fix workbook's rels ID calc errorxuri2019-12-23
|
* Improve code coverage unit testsxuri2019-12-22
|
* Update comments for the xmlNewDecoder (#542)match-meng2019-12-20
|
generated by cgit v1.2.1 (git 2.18.0) at 2025-04-16 08:31:22 +0000