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 |
xuri
|
1bc5302007
Fixed #764, add a condition for round precision
|
3 years ago |
xuri
|
b260485f29
support to set print black and white and specified the first printed page number
|
3 years ago |
xuri
|
054bb9f061
Support to adjust print scaling of the worksheet
|
3 years ago |
xuri
|
a26675517e
This closes #756, not set the empty string for the cell when SetCellValue with nil
|
3 years ago |
龚尚
|
22dc6ff33c
Update the tips message for Go modules user
|
3 years ago |
xuri
|
71829c5202
AddChart support disable legend of the chart
|
3 years ago |
xuri
|
576bfffbe6
This closes #752, fix incorrectly merged cells on duplicate row, and new formula function: LOWER, PROPER, UPPER
|
3 years ago |
xuri
|
77978ac68d
This closes #657 and closes #748, AddChart support custom marker symbol and symbol size, fix AddPicture auto fit failure with multi merged cells
|
3 years ago |
Zhang Zhipeng
|
ad79505173
new formula func CLEAN and TRIM, change import path to v2 (#747)
|
3 years ago |
Artem Kustikov
|
61057c58d3
Number format read fix (#741)
|
3 years ago |
jacentsao
|
95d8920c8e
support range validation for decimal (#739)
|
3 years ago |
xuri
|
13e0ed2a69
Fixed #735, refresh active tab after delete sheet
|
3 years ago |
xuri
|
599a8cb0bc
Fixed #727, rounding numeric with precision for formula calculation
|
3 years ago |