summaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
* This closes #809, and add new fn: HARMEANxuri2021-03-25
|
* #64 fn: NORM.DIST, NORMDIST, NORM.INV, NORMINV, NORM.S.DIST, NORMSDIST, ↵xuri2021-03-24
| | | | NORM.S.INV, and NORMSINV
* Merge pull request #808 from JDavidVR/patch-1xuri2021-03-22
|\ | | | | updated SetDefinedName's localSheetId attr to use sheetIndex
| * 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
* related issue #65 fn: FIXEDxuri2021-03-21
|
* #65 fn: DATEDIFxuri2021-03-19
|
* This closes #804, fixes can't add timelines and slicers for a pivot table in ↵xuri2021-03-15
| | | | generated spreadsheet
* #65 fn: NOW and TODAY, and update dependenciesxuri2021-03-14
|
* support ShowError option in Pivot table (#802)jinhyuk-kim-ca2021-03-13
|
* #625, support setting formula for cell in streaming APIxuri2021-03-07
|
* fix incorrect default column from GetColWidthxuri2021-03-05
|
* Fix UpdateLinkedValue which returns an error when has graph sheet (#793)yuki20062021-03-04
| | | | | | | | | * Fixed UpdateLinkedValue which returns an error when there is a graph sheet Signed-off-by: yuuki.ono <yagfair@gmail.com> * fix refactoring from review Signed-off-by: yuuki.ono <yagfair@gmail.com>
* Add support for setting hyperlink display & tooltip (closes #790) (#794)James Allen2021-03-03
|
* #65 fn: LARGE, SMALL, SUBSTITUTE, refactor ARABICxuri2021-03-02
|
* This improves compatibility for absolute XML path, Windows-style directory ↵xuri2021-02-27
| | | | separator and inline namespace;
* handle default underline type on get rich text; #65 fn: CODE, COLUMN, FIND, ↵xuri2021-02-24
| | | | FINDB
* check empty rich text run properties; new formula fn: LEFT, LEFTB, RIGHT, RIGHTBxuri2021-02-23
|
* add GetCellRichText method and test (#789)tonnyzhang2021-02-22
|
* This closes #787, avoid duplicate rich text string items, new formula fn: ↵xuri2021-02-21
| | | | BIN2DEC, BIN2HEX, BIN2OCT, HEX2BIN, HEX2DEC, HEX2OCT, OCT2BIN, OCT2DEC, OCT2HEX
* ref: #756, set cell as blank when SetCellValue with nil #756, new formula ↵xuri2021-02-19
| | | | fn: BITAND, BITLSHIFT, BITOR, BITRSHIFT, BITXOR
* #65 fn: DEC2BIN, DEC2HEX, DEC2OCTxuri2021-02-18
|
* #65 fn: KURT, STDEV, STDEVAxuri2021-02-17
|
* This closes #785, support to change tab color; new formula function: FISHER, ↵xuri2021-02-16
| | | | FISHERINV, GAMMA, GAMMALN, MIN, MINA, PERMUT
* lint issue fixed and new formula function: ATAN, AVERAGE, AVERAGEA, CONCAT, ↵xuri2021-02-15
| | | | CONCATENATE, COUNT, COUNTBLANK, MAX
* add ten formula functions: ENCODEURL, EXACT, FALSE, IFERROR, ISTEXT, LENB, ↵xuri2021-02-14
| | | | NOT, REPT, SHEET, TRUE
* binary search in range lookup and new formula function: LOOKUPxuri2021-02-13
|
* This improves compatibility for worksheet relative XML path and multi rules ↵xuri2021-02-11
| | | | auto filter
* This closes #782, fix unmerge all cells cause corrupted filexuri2021-02-10
|
* init new formula function: HLOOKUPxuri2021-02-09
|
* fix custom row height check issuexuri2021-02-08
|
* handle end element event in the worksheet row/column iterator XML SAX parserxuri2021-02-05
|
* init new formula function: VLOOKUPxuri2021-02-04
|
* 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`
* update formula functions testxuri2021-02-01
|
* Fix hyperbolic cotangent calculation incorrect and unit testxuri2021-01-31
|
* Nested formula function support cell references as argumentsxuri2021-01-31
|
* refactor formula calculation framework, add new function CHOOSE, and update ↵xuri2021-01-30
| | | | dependencies module
* value fields xlsxPatternFill.FgColor & xlsxPatternFill.BgColor cause … (#770)Eagle Xiang2021-01-28
| | | | | * value fields xlsxPatternFill.FgColor & xlsxPatternFill.BgColor cause ineffective omitempty tags * remove useless omitempty tag on xlsxPatternFill.FgColor and xlsxPatternFill.BgColor
* new formula fn: IF, LEN; not equal operator support and faster numeric ↵xuri2021-01-27
| | | | precision process
* Fixed #766, change order, and added fields of workbook fieldsxuri2021-01-23
|
* Update excelize.go (#765)Ray2021-01-20
| | | miss a char as 'l' in the excel.
* 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
|
* This closes #756, not set the empty string for the cell when SetCellValue ↵xuri2021-01-08
| | | | with nil
* Update the tips message for Go modules user龚尚2021-01-05
|
* AddChart support disable legend of the chartxuri2020-12-27
|
* This closes #752, fix incorrectly merged cells on duplicate row, and new ↵xuri2020-12-22
| | | | formula function: LOWER, PROPER, UPPER
* This closes #657 and closes #748, AddChart support custom marker symbol and ↵xuri2020-12-14
| | | | symbol size, fix AddPicture auto fit failure with multi merged cells
* new formula func CLEAN and TRIM, change import path to v2 (#747)Zhang Zhipeng2020-12-14
|
generated by cgit v1.2.1 (git 2.18.0) at 2025-04-19 14:18:39 +0000