This website requires JavaScript.
8a6815fccc
Improvement local month name and AM/PM format support in number format
xuri
2022-02-22 08:22:18 +0800
07be993631
Fixed parsing decimal precision issue
xuri
2022-02-18 00:02:39 +0800
f87c39c41d
This closes #1148 , resolve limitations when adding VBA project to the workbook
xuri
2022-02-17 00:09:11 +0800
ad09698515
Initialize local month name and AM/PM format support for number format
xuri
2022-02-14 00:05:47 +0800
4b64b26c52
Ref: #660 , #764 , #1093 , #1112 , #1133 This improve number format support
xuri
2022-02-13 00:06:30 +0800
3f8f4f52e6
This closes #1139 , `SetCellDefault` support non-numeric value
xuri
2022-02-08 00:08:06 +0800
0f1fcb78d5
Support workbook views Showruler settings (#1138 )
David
2022-02-06 09:52:28 -0400
862dc9dc13
Support workbook views settings (#1136 )
David
2022-02-04 01:45:42 -0400
156bf6d16e
This closes #1129 , make cell support inheritance columns/rows style
xuri
2022-01-27 22:37:32 +0800
3ee3c38f9c
Fix file corrupted in some cases, check file extension and format code
xuri
2022-01-23 00:32:34 +0800
74f6ea94ea
ref #1054 , breaking change for the column and row's iterator
xuri
2022-01-19 00:51:09 +0800
4daa6ed0b4
Breaking change: remove `TotalRows` of row iterator and performance optimization
xuri
2022-01-17 08:05:52 +0800
50c4dedf8d
This closes #1122 , improve compatibility with LibreOffice
xuri
2022-01-16 14:28:35 +0800
236ee61d20
This closes #1119 , style parsing issue fixed
xuri
2022-01-15 00:06:34 +0800
67127883dd
Fix adjustMergeCells not modifies cell rect (#1118 )
Dokiy
2022-01-14 00:28:31 +0800
b96329cc88
Breaking change for data validation and fixed #1117
xuri
2022-01-12 00:18:15 +0800
891e5baac1
ref #1096 , reduce memory usage by about 50% for large data spreadsheet
xuri
2022-01-11 00:24:24 +0800
2245fccca0
Typo fix, rename exported constants, dependencies modules and copyright update
xuri
2022-01-09 00:20:42 +0800
af5c4d00e8
feat: implement SHA-512 algorithm to ProtectSheet (#1115 )
Jonham.Chen
2022-01-08 10:32:13 +0800
9e64df6a96
Update create style example, using a pointer of the structure instead of JSON
xuri
2022-01-05 00:13:29 +0800
e37e060d6f
This closes #1107 , stream writer will create a time number format for time type cells
v2.5.0
xuri
2021-12-31 00:00:01 +0800
c5990ea348
Preserve horizontal tab character when set the cell value (#1108 )
vst
2021-12-30 00:36:04 +0800
89b85934f6
This closes #1096 , memory usage optimization and another 4 changes
xuri
2021-12-27 23:34:14 +0800
6b1e592cbc
This closes #1095 , support to set and get document application properties
xuri
2021-12-26 14:55:53 +0800
089cd365a3
This closes #1097 , initialized formula function XLOOKUP and update test
xuri
2021-12-25 21:51:09 +0800
6051434bf8
ref #65 , new formula functions MAXIFS and MINIFS
xuri
2021-12-19 13:36:24 +0800
63fe422299
new formula function and update docs for formula functions
xuri
2021-12-17 00:08:56 +0800
c0ac3165bd
ref #65 : new formula function COUNTIFS
xuri
2021-12-14 00:38:16 +0800
3371933494
ref #65 : new formula functions: AVERAGEIF and COUNTIF
xuri
2021-12-13 00:02:25 +0800
76aacfda0b
ref #65 : new formula function: SHEETS, and fix SHEET function count issue
xuri
2021-12-12 00:07:01 +0800
b33e39369a
This closes #1090 (#1092 )
jaby
2021-12-10 09:48:02 +0100
1b3040659d
ref #65 : new formula functions: ISFORMULA, ISLOGICAL and ISREF
xuri
2021-12-09 20:16:12 +0800
5bf35f8c1c
This closes #1088 (#1089 )
jaby
2021-12-09 02:40:11 +0100
44a13aa402
Export 7 errors so users can act differently on different type of errors
xuri
2021-12-07 00:26:53 +0800
3325c3946d
Fix adjustMergeCellsHelper and add some test cases (#1082 )
Dokiy
2021-12-06 22:37:25 +0800
7af55a5455
ref #65 : new formula function ODDFPRICE
xuri
2021-12-06 08:16:32 +0800
e0c6fa1beb
Update docs for SetSheetStyle, and added 2 formula functions
xuri
2021-12-04 13:07:58 +0800
577a07f08c
Simplify code and update unit test
xuri
2021-12-03 00:19:11 +0800
aa359f1c74
refactor DeleteSheet for better readability (#1078 )
Michael Wiesenbauer
2021-12-02 15:14:57 +0100
4ca1b305fe
Merge pull request #1077 from Dokiys/hotfix/get_num_fmt_id
xuri
2021-12-02 00:48:20 +0800
45a1f08a2a
Fix call getNumFmtID with builtInNumFmt return -1
Dokiy
2021-12-01 19:11:51 +0800
bb0eb4a42b
This closes #1075 , reload temporary files into memory on save
xuri
2021-12-01 00:10:31 +0800
49c9ea40d7
ref #65 : new formula function YIELD
xuri
2021-11-29 01:21:03 +0800
f26df480e5
ref #65 : new formula functions CONFIDENCE and CONFIDENCE.NORM
xuri
2021-11-25 00:38:49 +0800
7907650a97
This closes #1069 , support time zone location when set cell value
xuri
2021-11-24 00:09:35 +0800
9561976074
ref #65 : new formula function VDB
xuri
2021-11-22 00:39:39 +0800
a6c8803e91
ref #65 : new formula function XIRR
xuri
2021-11-21 15:49:29 +0800
9b0aa7ac30
This closes #1060 , fix build-in time number format parse error
xuri
2021-11-20 11:31:17 +0800
6b277c61d2
Fix sheet deletion fail in some case
xuri
2021-11-18 08:06:14 +0800
bc3c7d51a2
ref #65 : new formula function PRICE
xuri
2021-11-17 00:25:36 +0800
bda8e7f812
This closes #1061 , support multi-byte language on set header footer
xuri
2021-11-16 00:40:44 +0800
72410361b0
ref #65 , new formula functions: COUPDAYBS, COUPDAYS and COUPDAYSNC
xuri
2021-11-15 00:28:10 +0800
57275db22e
This closes #1057 , merge column styles to reduce spreadsheet size
xuri
2021-11-14 00:17:31 +0800
adecf447e1
This closes #1059 , represent boolean in XML as 0/1 rather than true/false
xuri
2021-11-13 14:11:16 +0800
5de671f8bb
ref #65 : new formula function MINUTE
xuri
2021-11-12 01:01:50 +0800
00eece4f53
ref #65 : new formula function XNPV
xuri
2021-11-11 00:43:42 +0800
a68bc34b0c
ref #65 : new formula functions PERCENTRANK.EXC, PERCENTRANK.INC and PERCENTRANK
xuri
2021-11-09 00:10:09 +0800
8f82d8b029
ref #65 : new formula functions COUPNCD and COUPNUM
xuri
2021-11-08 00:19:28 +0800
1df76b583c
ref #65 : new formula functions COUPPCD and PRICEMAT
xuri
2021-11-07 00:14:39 +0800
02b0fdf2c9
ref #65 : new formula functions PERCENTILE.EXC, QUARTILE.EXC and VAR.S
xuri
2021-11-06 00:11:16 +0800
8d21959da3
ref #65 : new formula functions VAR, VARA and VARPA
xuri
2021-11-05 00:03:46 +0800
60b13affbd
Support get current row/col and total rows/cols in the stream reader (#1054 )
li
2021-11-05 00:01:34 +0800
e64775fdcc
ref #65 : new formula functions STANDARDIZE, STDEV.P and STDEVP
xuri
2021-11-04 00:04:45 +0800
32548a6cac
return immediately when matched for efficiency (#1049 )
Sean Liang
2021-11-03 15:13:46 +0800
08ad10f68e
ref #65 : new formula functions ERF, ERF.PRECISE, ERFC and ERFC.PRECISE
xuri
2021-11-03 00:17:06 +0800
b0eb9ef807
ref #65 : new formula functions DELTA and GESTEP
xuri
2021-11-02 00:02:35 +0800
3447cfecf2
ref #65 : new formula functions ACCRINT and ISOWEEKNUM
xuri
2021-11-01 00:13:38 +0800
3bb2849e41
ref #65 : new formula functions DEVSQ and GEOMEAN
xuri
2021-10-31 00:15:17 +0800
9cc6694830
ref #65 : new formula functions RATE and RECEIVED (#1045 )
Jerring
2021-10-30 22:14:49 +0800
8932a0a0c3
ref #65 : new formula functions PV, RANK and RANK.EQ
xuri
2021-10-30 14:27:14 +0800
5c4627a0c2
ref #65 : new formula functions VALUE and WEEKDAY
xuri
2021-10-29 20:05:43 +0800
ffc998941c
ref #65 : new formula functions SWITCH and TRIMMEAN
xuri
2021-10-28 22:17:33 +0800
2e9635ece8
ref #65 : new formula functions TBILLPRICE and TBILLYIELD
xuri
2021-10-27 08:07:21 +0800
08087e1233
ref #65 : new formula functions TBILLEQ and TEXTJOIN
xuri
2021-10-26 00:01:05 +0800
154effdf82
ref #65 : new formula functions YIELDDISC and YIELDMAT
xuri
2021-10-24 12:20:24 +0800
71684d966a
ref #65 : new formula functions AVEDEV and CHIDIST
xuri
2021-10-23 10:18:06 +0800
f126f63562
ref #65 : new formula functions ADDRESS and PRICEDISC
xuri
2021-10-22 00:46:11 +0800
49e80b9e47
ref #65 : new formula functions DISC and INTRATE
xuri
2021-10-21 00:33:25 +0800
1df7f32cc6
ref #65 , new formula functions: RRI, SLN and SYD
xuri
2021-10-20 00:07:22 +0800
5f907b7824
ref #65 : new formula functions IFNA and IFS and fix string compare result issue in arithmetic operations
xuri
2021-10-19 00:06:19 +0800
620f873186
ref #65 : new formula function AMORLINC
xuri
2021-10-18 00:18:56 +0800
c89b64c53c
ref #65 : new formula functions ACCRINTM and AMORDEGRC
xuri
2021-10-17 22:51:33 +0800
cf8766df83
ref #65 , new formula function: TIME
xuri
2021-10-16 16:05:50 +0800
c64ce0f9ac
Update the test case of the formula function `MIRR`
Tammy
2021-10-15 23:23:26 +0800
de38402f74
This closes #1031 , fix small float parsed error in some case
xuri
2021-10-15 21:45:46 +0800
58fd279dc8
This closes #1030 , fix date rounding error
xuri
2021-10-12 00:01:11 +0800
aa8f6f02bd
This closes #1029 , support specify compact and outline for the pivot table
xuri
2021-10-11 00:08:45 +0800
28841af980
initialize formula function TRANSPOSE, ref #65 and remove unused exported error variable ErrToExcelTime
xuri
2021-10-01 21:43:02 +0800
e52e755282
Now support set row style in the stream writer
xuri
2021-09-29 23:08:17 +0800
2d8b5b1885
This closes #1027 and closes #1028
xuri
2021-09-28 22:02:31 +0800
490f3063c2
This closes #1026 , time parse accuracy issue and typo fixed
xuri
2021-09-26 00:07:40 +0800
c05b9fe8a6
new formula function: DAYS, ref #65
xuri
2021-09-24 08:19:48 +0800
790c363cce
This closes #833 , closes #845 , and closes #1022 , breaking changes
xuri
2021-09-18 23:20:24 +0800
2add938798
- new formula functions: DATEVALUE, ref #65 - fix ineffectual variable assignments - timeout in go test
xuri
2021-09-17 00:15:51 +0800
1ba3690764
new formula functions: WEIBULL and WEIBULL.DIST, ref #65
xuri
2021-09-14 22:23:12 +0800
4ef68729f5
new formula functions: Z.TEST and ZTEST, ref #65
xuri
2021-09-13 22:40:38 +0800
52609ba526
This closes #1017 , fix duplicate image caused by incorrect internal relationships ID calculation
xuri
2021-09-10 23:19:59 +0800
dad8f490cc
This closes #417 and closes #520 , new API `GetCellType` has been added
xuri
2021-09-09 23:43:16 +0800
72d84c0cbd
This closes #262 , support set line width of add the shape
xuri
2021-09-08 22:05:42 +0800
684603befa
This closes #993 , closes #1014 - Fix formula percentages calculated incorrectly - Make UpdateLinkedValue skip macro sheet - Fix conditional format bottom N not working
xuri
2021-09-06 00:01:42 +0800