 xuri
|
9154d500cf
ref: #756, set cell as blank when SetCellValue with nil #756, new formula fn: BITAND, BITLSHIFT, BITOR, BITRSHIFT, BITXOR
|
%!s(int64=4) %!d(string=hai) anos |
|
xuri
|
ae6f56b953
#65 fn: DEC2BIN, DEC2HEX, DEC2OCT
|
%!s(int64=4) %!d(string=hai) anos |
|
xuri
|
b3493c5416
#65 fn: KURT, STDEV, STDEVA
|
%!s(int64=4) %!d(string=hai) anos |
|
xuri
|
bddea1262b
This closes #785, support to change tab color; new formula function: FISHER, FISHERINV, GAMMA, GAMMALN, MIN, MINA, PERMUT
|
%!s(int64=4) %!d(string=hai) anos |
|
xuri
|
36b7990d6b
lint issue fixed and new formula function: ATAN, AVERAGE, AVERAGEA, CONCAT, CONCATENATE, COUNT, COUNTBLANK, MAX
|
%!s(int64=4) %!d(string=hai) anos |
|
xuri
|
ca6b1577a7
add ten formula functions: ENCODEURL, EXACT, FALSE, IFERROR, ISTEXT, LENB, NOT, REPT, SHEET, TRUE
|
%!s(int64=4) %!d(string=hai) anos |
|
xuri
|
ec45d67e59
binary search in range lookup and new formula function: LOOKUP
|
%!s(int64=4) %!d(string=hai) anos |
|
xuri
|
23c73ab527
init new formula function: HLOOKUP
|
%!s(int64=4) %!d(string=hai) anos |
|
xuri
|
66d85dae13
init new formula function: VLOOKUP
|
%!s(int64=4) %!d(string=hai) anos |
|
xuri
|
1f329e8f96
This closes #774, closes #775 and closes #776
|
%!s(int64=4) %!d(string=hai) anos |
|
xuri
|
db7b4ee362
update formula functions test
|
%!s(int64=4) %!d(string=hai) anos |
|
xuri
|
4ac32278ff
Fix hyperbolic cotangent calculation incorrect and unit test
|
%!s(int64=4) %!d(string=hai) anos |
|
xuri
|
76c72e0a30
Nested formula function support cell references as arguments
|
%!s(int64=4) %!d(string=hai) anos |
|
xuri
|
dd77cfe44c
refactor formula calculation framework, add new function CHOOSE, and update dependencies module
|
%!s(int64=4) %!d(string=hai) anos |
|
xuri
|
b84bd1abc0
new formula fn: IF, LEN; not equal operator support and faster numeric precision process
|
%!s(int64=4) %!d(string=hai) anos |
|
xuri
|
576bfffbe6
This closes #752, fix incorrectly merged cells on duplicate row, and new formula function: LOWER, PROPER, UPPER
|
%!s(int64=5) %!d(string=hai) anos |
 Zhang Zhipeng
|
ad79505173
new formula func CLEAN and TRIM, change import path to v2 (#747)
|
%!s(int64=5) %!d(string=hai) anos |
|
xuri
|
599a8cb0bc
Fixed #727, rounding numeric with precision for formula calculation
|
%!s(int64=5) %!d(string=hai) anos |
|
xuri
|
b812e9a1a8
New formula function AND (#701) and update doc for the NewSheet (#714)
|
%!s(int64=5) %!d(string=hai) anos |
|
xuri
|
02530e8c8a
Fix #701, init new formula function AND and OR, prevent formula lexer panic on retrieving the top token type
|
%!s(int64=5) %!d(string=hai) anos |
|
xuri
|
ac3dce0bea
- Resolve #711, update docs for the GetSheetIndex
|
%!s(int64=5) %!d(string=hai) anos |
|
xuri
|
3cf3101fd9
test on Go 1.5 on Travis CI and update docs for the CalcCellValue
|
%!s(int64=5) %!d(string=hai) anos |
 jaby
|
5993a07422
Fix issue 665 (#666)
|
%!s(int64=5) %!d(string=hai) anos |
|
xuri
|
b6dd7648a1
fn: COUNTA
|
%!s(int64=5) %!d(string=hai) anos |
|
xuri
|
b62950a39e
fn: MEDIAN, ISNUMBER
|
%!s(int64=5) %!d(string=hai) anos |
|
xuri
|
22df34c493
fn: ISBLANK, ISERR, ISERROR, ISEVEN, ISNA, ISNONTEXT, ISODD, NA
|
%!s(int64=5) %!d(string=hai) anos |
|
xuri
|
fa2571a17e
fn: SUMIF
|
%!s(int64=5) %!d(string=hai) anos |
|
xuri
|
2efc7107ff
- transform the range to the matrix on the first arg of the formula
|
%!s(int64=5) %!d(string=hai) anos |
|
xuri
|
0feb819d4c
updated test and go.mod
|
%!s(int64=5) %!d(string=hai) anos |
|
xuri
|
882abb8098
- formula engine: reduce cyclomatic complexity
|
%!s(int64=5) %!d(string=hai) anos |
