Commit Graph

1058 Commits (master)
 

Author SHA1 Message Date
xuri 3bb2849e41
ref #65: new formula functions DEVSQ and GEOMEAN
3 years ago
Jerring 9cc6694830
ref #65: new formula functions RATE and RECEIVED (#1045)
3 years ago
xuri 8932a0a0c3
ref #65: new formula functions PV, RANK and RANK.EQ
3 years ago
xuri 5c4627a0c2
ref #65: new formula functions VALUE and WEEKDAY
3 years ago
xuri ffc998941c
ref #65: new formula functions SWITCH and TRIMMEAN
3 years ago
xuri 2e9635ece8
ref #65: new formula functions TBILLPRICE and TBILLYIELD
3 years ago
xuri 08087e1233
ref #65: new formula functions TBILLEQ and TEXTJOIN
3 years ago
xuri 154effdf82
ref #65: new formula functions YIELDDISC and YIELDMAT
3 years ago
xuri 71684d966a
ref #65: new formula functions AVEDEV and CHIDIST
3 years ago
xuri f126f63562
ref #65: new formula functions ADDRESS and PRICEDISC
3 years ago
xuri 49e80b9e47
ref #65: new formula functions DISC and INTRATE
3 years ago
xuri 1df7f32cc6
ref #65, new formula functions: RRI, SLN and SYD
3 years ago
xuri 5f907b7824
ref #65: new formula functions IFNA and IFS and fix string compare result issue in arithmetic operations
3 years ago
xuri 620f873186
ref #65: new formula function AMORLINC
3 years ago
xuri c89b64c53c
ref #65: new formula functions ACCRINTM and AMORDEGRC
3 years ago
xuri cf8766df83
ref #65, new formula function: TIME
3 years ago
Tammy c64ce0f9ac
Update the test case of the formula function `MIRR`
3 years ago
xuri de38402f74
This closes #1031, fix small float parsed error in some case
3 years ago
xuri 58fd279dc8
This closes #1030, fix date rounding error
3 years ago
xuri aa8f6f02bd
This closes #1029, support specify compact and outline for the pivot table
3 years ago
xuri 28841af980 initialize formula function TRANSPOSE, ref #65 and remove unused exported error variable ErrToExcelTime
3 years ago
xuri e52e755282
Now support set row style in the stream writer
3 years ago
xuri 2d8b5b1885
This closes #1027 and closes #1028
3 years ago
xuri 490f3063c2
This closes #1026, time parse accuracy issue and typo fixed
3 years ago
xuri c05b9fe8a6
new formula function: DAYS, ref #65
3 years ago
xuri 790c363cce This closes #833, closes #845, and closes #1022, breaking changes
3 years ago
xuri 2add938798
- new formula functions: DATEVALUE, ref #65
3 years ago
xuri 1ba3690764
new formula functions: WEIBULL and WEIBULL.DIST, ref #65
3 years ago
xuri 4ef68729f5
new formula functions: Z.TEST and ZTEST, ref #65
3 years ago
xuri 52609ba526
This closes #1017, fix duplicate image caused by incorrect internal relationships ID calculation
3 years ago
xuri dad8f490cc
This closes #417 and closes #520, new API `GetCellType` has been added
3 years ago
xuri 72d84c0cbd
This closes #262, support set line width of add the shape
3 years ago
xuri 684603befa
This closes #993, closes #1014
3 years ago
xuri 32b23ef42d
This closes #998
3 years ago
xuri 2616aa88cb
Add set shared formula support and documentation for the `SetCellFormula`
3 years ago
xuri 5e1fbd6bf7
This closes #1008, added new formula functions MATCH and XOR, related issue #65
3 years ago
xuri c3d1d7dddd
Preserve XML control character in bstrUnmarshal result
3 years ago
xuri 7d9b9275bd
This closes #1012, support specify the formula in the data validation range, and update the documentation for the `AddPicture`
3 years ago
xuri cd030d4aa8
Improve compatibility with row element with r="0" attribute
3 years ago
xuri a2d449708c
- This fix panic and incorrect cell read on some case
3 years ago
Stani 9b55f4f9f0
This closes #1006, new fn: MONTH ref #65
3 years ago
Stani 4d716fa7ed
* This closes #1004, new fn: MONTH ref #65
3 years ago
Stani f280c03345
This closes #997, fix LOOKUP function to find nearest match (#1001)
3 years ago
Stani 935af2e356
This closes #1002, new fn: DAY ref #65
3 years ago
Stani dca03c6230
This closes #994, fix LOOKUP function for Array form
3 years ago
xuri a55f354eb3
This closes #989, closes #990
3 years ago
raochq b02f864eab
This closes #844, support get shared formula
3 years ago
xuri 48c16de8bf
Improve security and simplify code
3 years ago
three f6f14f507e
Speed up merge cells
3 years ago
bailantaotao 61d0ed1ff2
This closes #987: support nested calc for if formula (#988)
3 years ago