summaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
* This closes #409 Remove UTC timezone requirement from date.go (#853)Alluuu2021-06-04
| | | | | | | According to issue #409 There is absolutely no reason for the timezone to be in UTC, and converting the local times to UTC while keeping values is hacky at least. Excel has no understanding of timezones, hence the user of this library should know what timezone their values are supposed to be, by following the timezone within their timeTime structs.
* Merge pull request #851 from si9ma/feat_disable_axisxuri2021-05-28
|\ | | | | feat: add disable option for chart xAxis and yAxis
| * feat: add disable option for chart xAxis and yAxissi9ma2021-05-27
| |
* | Merge pull request #847 from qwaszx102938/masterxuri2021-05-24
|\ \ | |/ |/| fix the bug that there was no count attribute in sharedStrings file, fix the bug that setting OutlineSummaryBelow false
| * fix the bug when there was no count attribute in sharedStrings filewilliam2021-05-24
|/
* This closes #842, avoid empty rows in the tail of the worksheetxuri2021-05-16
|
* * This closes #841, fix incorrect build number format in PR #839ice2021-05-15
|
* "15" is the correct 24 hours time format in go (#839)ice2021-05-14
| | | | * "15" is the correct 24 hours time format in go * fix number format convert issue and remove the `dateTimeFormatsCache`
* This closes #838, fix wrong worksheet XML path of the stream writer in some casexuri2021-05-14
|
* This closes #652, new SetColWidth API, support set column width in stream ↵xuri2021-05-10
| | | | writing mode, and export error message
* #65 fn: BESSELK and BESSELYxuri2021-05-09
|
* 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
* Fixe issue generated file corrupted caused by incorrect default XML ↵xuri2021-04-30
| | | | namespace attributes
* #826, support merge cell in streaming modexuri2021-04-28
|
* This closes #825, closes #829, closes #830, fix issue when get and add ↵xuri2021-04-27
| | | | comments on multi authors
* Fixed #825, improves compatibility for comments with absolute XML pathxuri2021-04-26
|
* Fixed #823, 12/24 hours time format parsing errorxuri2021-04-20
|
* update dependencies module and bump version 2.4.0xuri2021-04-18
|
* #65 fn: IRR nad MIRRxuri2021-04-16
|
* #65 fn: FV, FVSCHEDULE, NPER, NPV and PDURATIONxuri2021-04-14
|
* #65 fn: DB, DDB, DOLLARDE, DOLLARFR, EFFECT, ISPMT and NOMINALxuri2021-04-13
|
* fixed the negative values series missing chart color, #65 fn: CUMIPMT and ↵xuri2021-04-11
| | | | CUMPRINC
* Support specifies that each data marker in the series has a different colorxuri2021-04-10
|
* #65 fn: IPMT, PMT and PPMTxuri2021-04-09
|
* Fixed #819, read empty after streaming data writingxuri2021-04-08
| | | | #65 fn: IMAGINARY, IMARGUMENT, IMCONJUGATE and IMDIV
* #65 fn: IMLOG2, IMPOWER, IMPRODUCT, IMREAL, IMSEC, and IMSECHxuri2021-04-07
|
* #65 fn: IMSIN, IMSINH, IMSQRT, IMSUB, IMSUM, IMTANxuri2021-04-05
|
* Go 1.15 and later required, #65 fn: IMABS, IMCOS, IMCOSH, IMCOT, IMCSC, ↵xuri2021-04-04
| | | | IMCSCH, IMEXP, IMLN and IMLOG10
* Fixed #813, streaming data writer result missing after call normal APIxuri2021-04-03
| | | | #65 formula function: COMPLEX
* #65 fn: BESSELI and BESSELJxuri2021-04-02
|
* #65 fn: VAR.P and VARP and fix Yoda conditions issuexuri2021-04-01
|
* #65 fn: QUARTILE and QUARTILE.INCxuri2021-03-31
|
* #65 fn: N, PERCENTILE.INC and Txuri2021-03-30
| | | | typo fixed
* #65 fn: PERCENTILE and PERMUTATIONAxuri2021-03-27
|
* #65, new fn: POISSON.DIST, POISSON, SKEW, and STDEV.Sxuri2021-03-26
|
* 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
|
generated by cgit v1.2.1 (git 2.18.0) at 2025-04-19 18:37:07 +0000