 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 |
|
xuri
|
30549c5e90
fix custom row height check issue
|
3 years ago |
|
xuri
|
2fb135bc94
handle end element event in the worksheet row/column iterator XML SAX parser
|
3 years ago |
|
xuri
|
66d85dae13
init new formula function: VLOOKUP
|
3 years ago |
|
xuri
|
1f329e8f96
This closes #774, closes #775 and closes #776
|
3 years ago |
|
xuri
|
db7b4ee362
update formula functions test
|
3 years ago |
|
xuri
|
4ac32278ff
Fix hyperbolic cotangent calculation incorrect and unit test
|
3 years ago |
|
xuri
|
76c72e0a30
Nested formula function support cell references as arguments
|
3 years ago |
|
xuri
|
dd77cfe44c
refactor formula calculation framework, add new function CHOOSE, and update dependencies module
|
3 years ago |
 Eagle Xiang
|
219add2f0e
value fields xlsxPatternFill.FgColor & xlsxPatternFill.BgColor cause … (#770)
|
3 years ago |
|
xuri
|
b84bd1abc0
new formula fn: IF, LEN; not equal operator support and faster numeric precision process
|
3 years ago |
|
xuri
|
e568319bbc
Fixed #766, change order, and added fields of workbook fields
|
3 years ago |
 Ray
|
58ecf81630
Update excelize.go (#765)
|
3 years ago |
