[GH #6234] The use of the INTERCEPT formula needs help

1615175118 · 27 August 2019 13:45

I saw on github that the function library of handsontable supports INTERCEPT function, but I will make mistakes when I use it in the project. I hope you can help me. thank you very much!

INTERCEPT support address on github:

github.com

handsontable/formula-parser/blob/develop/src/supported-formulas.js#L181


'IMREAL',
'IMSEC',
'IMSECH',
'IMSIN',
'IMSINH',
'IMSQRT',
'IMSUB',
'IMSUM',
'IMTAN',
'INT',
'INTERCEPT',
'INTERVAL',
'IPMT',
'IRR',
'ISBINARY',
'ISBLANK',
'ISEVEN',
'ISLOGICAL',
'ISNONTEXT',
'ISNUMBER',
'ISODD',

Demo address:
https://jsfiddle.net/wuganzhi/7uxy52me/18/

aleksandra_budnik · 27 August 2019 13:45

Hey @1615175118

I have updated the topic. It seem that this is a bug. We are developing a new formula engine, that should slowly adapted to Handsontable in December. We’ll try this issue out once we get the new engine running.