p71924506
/
excelize
forked from p30928647/excelize
1
0
Fork 0
Code Issues Pull Requests Projects Releases Wiki Activity

Commit Graph

  • d42834f3a8
         update dependencies module and bump version 2.4.0 v2.4.0 xuri 2021-04-18 16:00:34 +0000
  • 80d832022f
         #65 fn: IRR nad MIRR xuri 2021-04-16 14:45:45 +0000
  • 471f4f8d2b
         #65 fn: FV, FVSCHEDULE, NPER, NPV and PDURATION xuri 2021-04-14 00:39:18 +0800
  • 68dd5b345c
         #65 fn: DB, DDB, DOLLARDE, DOLLARFR, EFFECT, ISPMT and NOMINAL xuri 2021-04-13 00:01:13 +0800
  • a13b21fe07
         fixed the negative values series missing chart color, #65 fn: CUMIPMT and CUMPRINC xuri 2021-04-11 00:03:25 +0800
  • 1559dd31be
         Support specifies that each data marker in the series has a different color xuri 2021-04-10 00:15:39 +0800
  • a8197485b5
         #65 fn: IPMT, PMT and PPMT xuri 2021-04-09 00:29:47 +0800
  • 737b7839a2
         Fixed #819, read empty after streaming data writing #65 fn: IMAGINARY, IMARGUMENT, IMCONJUGATE and IMDIV xuri 2021-04-08 00:50:59 +0800
  • 99963f89c7
         #65 fn: IMLOG2, IMPOWER, IMPRODUCT, IMREAL, IMSEC, and IMSECH xuri 2021-04-07 00:01:03 +0800
  • 3345e89b96
         #65 fn: IMSIN, IMSINH, IMSQRT, IMSUB, IMSUM, IMTAN xuri 2021-04-05 13:00:34 +0800
  • f8f699a172
         Go 1.15 and later required, #65 fn: IMABS, IMCOS, IMCOSH, IMCOT, IMCSC, IMCSCH, IMEXP, IMLN and IMLOG10 xuri 2021-04-04 15:29:43 +0800
  • 89c262fc1d
         Fixed #813, streaming data writer result missing after call normal API #65 formula function: COMPLEX xuri 2021-04-03 22:56:02 +0800
  • 6e812a27c6
         #65 fn: BESSELI and BESSELJ xuri 2021-04-02 22:41:33 +0800
  • a002a2417e
         #65 fn: VAR.P and VARP and fix Yoda conditions issue xuri 2021-04-01 21:52:43 +0800
  • 9d4bf88b47
         #65 fn: QUARTILE and QUARTILE.INC xuri 2021-03-31 22:01:02 +0800
  • 2af96c0714
         #65 fn: N, PERCENTILE.INC and T typo fixed xuri 2021-03-30 23:02:22 +0800
  • 6d7bd7cd8a
         #65 fn: PERCENTILE and PERMUTATIONA xuri 2021-03-27 00:08:55 +0800
  • 3903c106a4
         #65, new fn: POISSON.DIST, POISSON, SKEW, and STDEV.S xuri 2021-03-26 00:17:29 +0800
  • e1abdb0e5a
         This closes #809, and add new fn: HARMEAN xuri 2021-03-25 00:05:02 +0800
  • ab2c1c8fe1
         #64 fn: NORM.DIST, NORMDIST, NORM.INV, NORMINV, NORM.S.DIST, NORMSDIST, NORM.S.INV, and NORMSINV xuri 2021-03-24 08:24:59 +0800
  • bd83c27ffc
         Merge pull request #808 from JDavidVR/patch-1 xuri 2021-03-22 10:39:08 +0800
  • d08a6d2437
         updated SetDefinedName's localSheetId attr to use sheetIndex David 2021-03-21 19:39:36 -0400
  • 874d59cee0 related issue #65 fn: FIXED xuri 2021-03-21 23:45:36 +0800
  • d3227393ef
         #65 fn: DATEDIF xuri 2021-03-19 23:23:05 +0800
  • 9af00b9b98
         This closes #804, fixes can't add timelines and slicers for a pivot table in generated spreadsheet xuri 2021-03-15 23:56:36 +0800
  • 2350866d46
         #65 fn: NOW and TODAY, and update dependencies xuri 2021-03-14 22:29:18 +0800
  • b83a36a8ae
         support ShowError option in Pivot table (#802) jinhyuk-kim-ca 2021-03-13 00:22:28 -0500
  • 7e12b560ce
         #625, support setting formula for cell in streaming API xuri 2021-03-07 15:02:04 +0800
  • 71bd5e1959 fix incorrect default column from GetColWidth xuri 2021-03-05 00:40:37 +0800
  • dbe88d723e
         Fix UpdateLinkedValue which returns an error when has graph sheet (#793) yuki2006 2021-03-04 10:23:45 +0900
  • a12dfd3ce6
         Add support for setting hyperlink display & tooltip (closes #790) (#794) James Allen 2021-03-03 12:30:31 +0000
  • 7ef1892f32
         #65 fn: LARGE, SMALL, SUBSTITUTE, refactor ARABIC xuri 2021-03-02 22:34:09 +0800
  • afe2ebc261 This improves compatibility for absolute XML path, Windows-style directory separator and inline namespace; xuri 2021-02-27 00:03:46 +0800
  • 5a0d885315
         handle default underline type on get rich text; #65 fn: CODE, COLUMN, FIND, FINDB xuri 2021-02-24 00:37:44 +0800
  • d84050921e
         check empty rich text run properties; new formula fn: LEFT, LEFTB, RIGHT, RIGHTB xuri 2021-02-23 00:05:19 +0800
  • bbb8ebfa8c
         add GetCellRichText method and test (#789) tonnyzhang 2021-02-22 06:04:13 -0600
  • 2833395347
         This closes #787, avoid duplicate rich text string items, new formula fn: BIN2DEC, BIN2HEX, BIN2OCT, HEX2BIN, HEX2DEC, HEX2OCT, OCT2BIN, OCT2DEC, OCT2HEX xuri 2021-02-21 00:21:45 +0800
  • 9154d500cf ref: #756, set cell as blank when SetCellValue with nil #756, new formula fn: BITAND, BITLSHIFT, BITOR, BITRSHIFT, BITXOR xuri 2021-02-19 00:03:51 +0800
  • ae6f56b953
         #65 fn: DEC2BIN, DEC2HEX, DEC2OCT xuri 2021-02-18 08:13:22 +0800
  • b3493c5416
         #65 fn: KURT, STDEV, STDEVA xuri 2021-02-17 00:51:06 +0800
  • bddea1262b
         This closes #785, support to change tab color; new formula function: FISHER, FISHERINV, GAMMA, GAMMALN, MIN, MINA, PERMUT xuri 2021-02-16 00:02:14 +0800
  • 36b7990d6b
         lint issue fixed and new formula function: ATAN, AVERAGE, AVERAGEA, CONCAT, CONCATENATE, COUNT, COUNTBLANK, MAX xuri 2021-02-15 00:09:35 +0800
  • ca6b1577a7
         add ten formula functions: ENCODEURL, EXACT, FALSE, IFERROR, ISTEXT, LENB, NOT, REPT, SHEET, TRUE xuri 2021-02-14 00:02:29 +0800
  • ec45d67e59
         binary search in range lookup and new formula function: LOOKUP xuri 2021-02-13 00:07:52 +0800
  • 3648335d7f This improves compatibility for worksheet relative XML path and multi rules auto filter xuri 2021-02-11 00:07:46 +0800
  • 3783d1d01b
         This closes #782, fix unmerge all cells cause corrupted file xuri 2021-02-10 00:04:13 +0800
  • 23c73ab527
         init new formula function: HLOOKUP xuri 2021-02-09 00:12:53 +0800
  • 30549c5e90
         fix custom row height check issue xuri 2021-02-08 18:05:15 +0800
  • 2fb135bc94
         handle end element event in the worksheet row/column iterator XML SAX parser xuri 2021-02-05 22:52:31 +0800
  • 66d85dae13
         init new formula function: VLOOKUP xuri 2021-02-04 23:57:07 +0800
  • 1f329e8f96
         This closes #774, closes #775 and closes #776 - 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` xuri 2021-02-02 22:23:16 +0800
  • db7b4ee362
         update formula functions test xuri 2021-02-01 00:07:51 +0800
  • 4ac32278ff
         Fix hyperbolic cotangent calculation incorrect and unit test xuri 2021-01-31 13:15:10 +0800
  • 76c72e0a30
         Nested formula function support cell references as arguments xuri 2021-01-31 01:28:40 +0800
  • dd77cfe44c
         refactor formula calculation framework, add new function CHOOSE, and update dependencies module xuri 2021-01-30 00:11:01 +0800
  • 219add2f0e
         value fields xlsxPatternFill.FgColor & xlsxPatternFill.BgColor cause … (#770) Eagle Xiang 2021-01-28 21:13:23 +0800
  • b84bd1abc0
         new formula fn: IF, LEN; not equal operator support and faster numeric precision process xuri 2021-01-27 13:51:47 +0800
  • e568319bbc
         Fixed #766, change order, and added fields of workbook fields xuri 2021-01-23 00:09:13 +0800
  • 58ecf81630
         Update excelize.go (#765) Ray 2021-01-20 14:40:33 +0800
  • 1bc5302007
         Fixed #764, add a condition for round precision xuri 2021-01-20 00:14:21 +0800
  • b260485f29
         support to set print black and white and specified the first printed page number xuri 2021-01-17 01:06:08 +0800
  • 054bb9f061
         Support to adjust print scaling of the worksheet xuri 2021-01-16 21:51:23 +0800
  • a26675517e
         This closes #756, not set the empty string for the cell when SetCellValue with nil xuri 2021-01-08 23:57:13 +0800
  • 22dc6ff33c
         Update the tips message for Go modules user 龚尚 2021-01-05 13:41:00 +0800
  • 71829c5202
         AddChart support disable legend of the chart v2.3.2 xuri 2020-12-27 00:18:54 +0800
  • 576bfffbe6 This closes #752, fix incorrectly merged cells on duplicate row, and new formula function: LOWER, PROPER, UPPER xuri 2020-12-22 08:47:46 +0800
  • 77978ac68d
         This closes #657 and closes #748, AddChart support custom marker symbol and symbol size, fix AddPicture auto fit failure with multi merged cells xuri 2020-12-14 20:56:51 +0800
  • ad79505173
         new formula func CLEAN and TRIM, change import path to v2 (#747) Zhang Zhipeng 2020-12-14 09:56:42 +0800
  • 61057c58d3
         Number format read fix (#741) Artem Kustikov 2020-12-12 11:17:00 +0300
  • 95d8920c8e
         support range validation for decimal (#739) jacentsao 2020-12-10 13:37:34 +0800
  • 13e0ed2a69
         Fixed #735, refresh active tab after delete sheet xuri 2020-11-23 00:01:06 +0800
  • 599a8cb0bc
         Fixed #727, rounding numeric with precision for formula calculation xuri 2020-11-19 21:38:35 +0800
  • 92c8626f81
         Fixed #732, support single line with repeated row element in the sheet data xuri 2020-11-18 22:08:40 +0800
  • 2be4bfd410
         Fix row duplicate mechanism (#729) Eugene Androsov 2020-11-15 04:58:45 +0200
  • 2514bb16c6 Fix #724, standardize variable naming and update unit tests xuri 2020-11-10 23:48:09 +0800
  • 5dd0b4aec2
         using POSIX directory separator in zip path with Windows xuri 2020-11-06 20:03:13 +0800
  • cdc57db3b3 Fix race conditions xuri 2020-11-04 01:24:26 +0000
  • c82a185af8
         Compatibility improvement: parse document core part (workbook) dynamically xuri 2020-11-04 00:28:20 +0800
  • fcca8a3838
         optimize memory allocation (#722) Ted 2020-11-03 17:48:37 +0800
  • 9d470bb38f
         Update conversion between integer types and unit tests xuri 2020-10-23 00:01:52 +0800
  • b812e9a1a8
         New formula function AND (#701) and update doc for the NewSheet (#714) xuri 2020-10-22 08:29:25 +0800
  • 4834a058aa
         This closes #714 and closes #715, fix wrong worksheet index returned by NewSheet in some case, fix panic on formatted value with no built-in number format ID xuri 2020-10-19 23:55:54 +0800
  • 520aa679f3
         Fix #706, #713 improve AddPicture performance, fix missing worksheet when rename with same names xuri 2020-10-18 00:01:33 +0800
  • 02530e8c8a Fix #701, init new formula function AND and OR, prevent formula lexer panic on retrieving the top token type xuri 2020-10-17 00:57:12 +0800
  • ac3dce0bea
         - Resolve #711, update docs for the GetSheetIndex - Update unit test xuri 2020-10-12 00:05:27 +0800
  • d1926675f8
         - Resolve #627, improve multi-series line chart compatibility with KingSoft WPS - Avoid to create duplicate style - Update unit test for the auto filter - Init code scanning alerts xuri 2020-10-11 00:15:04 +0800
  • 93160287bb
         Optimize memory usage when stream flush and save (#659) Lijingfeng 2020-10-05 22:17:11 +0800
  • f2b8798a34
         extend cell value load to support custom datetime format (#703) Artem Kustikov 2020-10-04 16:07:39 +0300
  • 9055a835a8
         Merge pull request #710 from lbraconnier2/Pivot-failed-in-case-of-multi-columns-and-multi-data xuri 2020-10-01 19:04:19 +0800
  • 2bd359bd01 fix pivot fails in case of multi columns and multi data Ludovic Braconnier 2020-09-30 18:20:11 +0200
  • c492220237
         Pivot table generation fails when no Columns and multiple Data are provided. (#708) jinhyuk-kim-ca 2020-09-27 01:34:39 -0400
  • 89465f41b5
         Update dependency package version and docs for the OpenFile v2.3.1 xuri 2020-09-22 22:29:43 +0800
  • 324f87bcae
         add checking and limits for the worksheet xuri 2020-09-18 22:20:58 +0800
  • 96917e4617
         Update docs and test case for the pivot table xuri 2020-09-15 23:31:24 +0800
  • 97bffe608d
         Extend pivot table funtionality (#692) Eugene Androsov 2020-09-10 19:45:52 +0300
  • 01afc6e03f init ECMA-376 agile encryption support xuri 2020-09-06 18:06:59 +0800
  • 1111de2fdb
         improve compatibility for phonetic hint and sheet tab color xuri 2020-09-03 23:44:43 +0800
  • 98f1a69903
         support ECMA-376 document standard encryption, ref #199 xuri 2020-09-02 23:14:19 +0800
  • 4177c1585e Resolve #199, init password protection spreadsheet support xuri 2020-09-01 00:40:56 +0800
  • 88de2f8d51
         Default row height compatibility with Apache OpenOffice and Kingsoft WPS, unit test update and typo fixed xuri 2020-08-22 18:58:43 +0800