 xuri
|
3903c106a4
#65, new fn: POISSON.DIST, POISSON, SKEW, and STDEV.S
|
3 years ago |
|
xuri
|
e1abdb0e5a
This closes #809, and add new fn: HARMEAN
|
3 years ago |
|
xuri
|
ab2c1c8fe1
#64 fn: NORM.DIST, NORMDIST, NORM.INV, NORMINV, NORM.S.DIST, NORMSDIST, NORM.S.INV, and NORMSINV
|
3 years ago |
|
xuri
|
bd83c27ffc
Merge pull request #808 from JDavidVR/patch-1
|
3 years ago |
 David
|
d08a6d2437
updated SetDefinedName's localSheetId attr to use sheetIndex
|
3 years ago |
|
xuri
|
874d59cee0
related issue #65 fn: FIXED
|
3 years ago |
|
xuri
|
d3227393ef
#65 fn: DATEDIF
|
3 years ago |
|
xuri
|
9af00b9b98
This closes #804, fixes can't add timelines and slicers for a pivot table in generated spreadsheet
|
3 years ago |
|
xuri
|
2350866d46
#65 fn: NOW and TODAY, and update dependencies
|
3 years ago |
 jinhyuk-kim-ca
|
b83a36a8ae
support ShowError option in Pivot table (#802)
|
3 years ago |
|
xuri
|
7e12b560ce
#625, support setting formula for cell in streaming API
|
3 years ago |
|
xuri
|
71bd5e1959
fix incorrect default column from GetColWidth
|
3 years ago |
 yuki2006
|
dbe88d723e
Fix UpdateLinkedValue which returns an error when has graph sheet (#793)
|
3 years ago |
 James Allen
|
a12dfd3ce6
Add support for setting hyperlink display & tooltip (closes #790) (#794)
|
3 years ago |
|
xuri
|
7ef1892f32
#65 fn: LARGE, SMALL, SUBSTITUTE, refactor ARABIC
|
3 years ago |
|
xuri
|
afe2ebc261
This improves compatibility for absolute XML path, Windows-style directory separator and inline namespace;
|
3 years ago |
|
xuri
|
5a0d885315
handle default underline type on get rich text; #65 fn: CODE, COLUMN, FIND, FINDB
|
3 years ago |
|
xuri
|
d84050921e
check empty rich text run properties; new formula fn: LEFT, LEFTB, RIGHT, RIGHTB
|
3 years ago |
 tonnyzhang
|
bbb8ebfa8c
add GetCellRichText method and test (#789)
|
3 years ago |
|
xuri
|
2833395347
This closes #787, avoid duplicate rich text string items, new formula fn: BIN2DEC, BIN2HEX, BIN2OCT, HEX2BIN, HEX2DEC, HEX2OCT, OCT2BIN, OCT2DEC, OCT2HEX
|
3 years ago |
|
xuri
|
9154d500cf
ref: #756, set cell as blank when SetCellValue with nil #756, new formula fn: BITAND, BITLSHIFT, BITOR, BITRSHIFT, BITXOR
|
3 years ago |
|
xuri
|
ae6f56b953
#65 fn: DEC2BIN, DEC2HEX, DEC2OCT
|
3 years ago |
|
xuri
|
b3493c5416
#65 fn: KURT, STDEV, STDEVA
|
3 years ago |
|
xuri
|
bddea1262b
This closes #785, support to change tab color; new formula function: FISHER, FISHERINV, GAMMA, GAMMALN, MIN, MINA, PERMUT
|
3 years ago |
|
xuri
|
36b7990d6b
lint issue fixed and new formula function: ATAN, AVERAGE, AVERAGEA, CONCAT, CONCATENATE, COUNT, COUNTBLANK, MAX
|
3 years ago |
|
xuri
|
ca6b1577a7
add ten formula functions: ENCODEURL, EXACT, FALSE, IFERROR, ISTEXT, LENB, NOT, REPT, SHEET, TRUE
|
3 years ago |
|
xuri
|
ec45d67e59
binary search in range lookup and new formula function: LOOKUP
|
3 years ago |
|
xuri
|
3648335d7f
This improves compatibility for worksheet relative XML path and multi rules auto filter
|
3 years ago |
|
xuri
|
3783d1d01b
This closes #782, fix unmerge all cells cause corrupted file
|
3 years ago |
|
xuri
|
23c73ab527
init new formula function: HLOOKUP
|
3 years ago |
