imhven
/
excelize-formula
1
0
Fork 0
Code Issues Pull Requests Projects Releases 1 Wiki Activity

Commit Graph

  • 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
  • 3c8c8c55c8 resolved #691, fix the scale for add picture not work xuri 2020-08-18 08:30:32 +0000
  • 4e4baac3bc using Mutex lock and update benchmark xuri 2020-08-16 03:48:11 +0000
  • bc704c854f update stream writer fields offset xuri 2020-08-15 10:41:45 +0000
  • c3e92a51d7 Compatible with Go 1.15, fix unit test failed on Windows and fixed #689 potential race condition xuri 2020-08-14 16:09:50 +0000
  • cb6f8852bb Merge branch 'master' into v2 xuri 2020-08-14 10:20:36 +0000
  • 3cf3101fd9 test on Go 1.5 on Travis CI and update docs for the CalcCellValue xuri 2020-08-14 10:19:27 +0000
  • c98fd7e5d0
         Fix issue #686 RemoveRow slice bounds out of range (#687) Wang Yaoshen 2020-08-14 10:32:58 +0800
  • 843bd24e56 This closes #677 and closes #679, fix panic when enabling compiler inline flags v2.3.0 xuri 2020-08-06 05:58:40 +0000
  • fcbc7e3f88
         Merge pull request #681 from WXDYGR/master xuri 2020-08-05 20:54:15 +0800
  • 1c2e7c5c68
         Update styles.go WXDYGR 2020-08-05 20:33:12 +0800
  • ee35497935
         Fix #673 comment shape compatibility issue with the recent Excel versions xuancanh 2020-07-22 20:20:00 +0800
  • 13e7bce6d2
         improvement compatibility for the XML ignorable namespace xuri 2020-07-20 00:05:37 +0800
  • ca43c65115
         Update test for addTable xuri 2020-07-19 00:10:42 +0800
  • c922c32fb7
         support parse and generate XML element namespace dynamic, fix #651 xuri 2020-07-18 15:15:16 +0800
  • 820a314cfb
         Resolve #667, support shared string table without unique count xuri 2020-07-15 23:32:00 +0800
  • 5993a07422
         Fix issue 665 (#666) jaby 2020-07-14 17:05:43 +0200
  • 0aa1510694
         update docs and improve compatibility xuri 2020-07-11 02:31:02 +0800
  • 42b1c81488
         Resolve #661 Add Logarithmic scale option support on Y axis (#662) Huy Bui (Kevin) 2020-07-11 01:07:41 +0800
  • 49257c5918
         support case-sensitive doc parts to improve compatibility xuri 2020-07-09 01:24:11 +0800
  • f7bd0729c6
         Resolve #32, fix missing leading/leading spaces when working with SST xuri 2020-07-01 22:41:29 +0800
  • 1cbb05d497
         GetCols support the row element without r attribute in the worksheet xuri 2020-06-28 00:02:32 +0800
  • 48f19f60aa
         support the row element without r attribute in the worksheet xuri 2020-06-27 00:02:47 +0800
  • 15fd56853f
         Update docs and typo fixed xuri 2020-06-22 00:14:56 +0800
  • 5221729bc3
         make columns iterator read cell streamingly and add max column limit on ColumnNumberToName xuri 2020-06-22 00:05:19 +0800
  • dcb772d692
         Merge pull request #653 from Jerome1337/648-column-iterator xuri 2020-06-20 22:08:08 +0800
  • e9a4007c17
         Implement columns iterator Jérôme Pogeant 2020-06-16 11:53:22 +0200
  • 8ce48b859a
         Merge pull request #647 from heiy/master xuri 2020-06-08 19:02:50 +0800
  • eb150c0c22 escape html tag heiy 2020-06-08 18:23:38 +0800
  • b6dd7648a1
         fn: COUNTA xuri 2020-06-04 00:35:54 +0800
  • b62950a39e
         fn: MEDIAN, ISNUMBER xuri 2020-06-02 23:39:41 +0800
  • 22df34c493
         fn: ISBLANK, ISERR, ISERROR, ISEVEN, ISNA, ISNONTEXT, ISODD, NA xuri 2020-05-31 15:13:52 +0800
  • fa2571a17e
         fn: SUMIF xuri 2020-05-30 23:21:02 +0800
  • 2ae631376b
         add limits for total columns, row and filename length xuri 2020-05-29 00:26:40 +0800
  • c168233e70
         speedup get cell value from shared string table xuri 2020-05-27 00:02:29 +0800
  • 5c99300ee4
         Fix #622, storage string to SST (shared string table) xuri 2020-05-26 02:09:39 +0800
  • 1aeb818235
         avoid creating duplicate number format xuri 2020-05-25 00:22:58 +0800
  • a546427fd9
         Resolve #643, avoid creating duplicate style xuri 2020-05-24 20:20:22 +0800
  • 7f78464f7f
         add test for ReadZipReader, close #642 xuri 2020-05-23 13:29:51 +0800
  • 82bb1153d7
         Improved error handling and stoped the crash due to fatel error (#593) close #624 sachin-puranik 2020-05-23 10:21:46 +0530
  • 0dd616b18f
         Merge pull request #517 from hengmyj/fix/cell_lock xuri 2020-05-22 17:01:45 +0800
  • ec14de32f0
         Merge branch 'master' into fix/cell_lock xuri 2020-05-22 16:53:46 +0800
  • 2efc7107ff
         - transform the range to the matrix on the first arg of the formula - typo fix - reset cell with and height when insert picture into merged cell with autofit xuri 2020-05-21 22:57:58 +0800