With the forthcoming “formulas” re-write you are working on, are you going to/can you please fix the problem of formula cell contents failing validation?
Typically most formulas return a number. To get numbers written out right, you mark the whole table, or individual columns, as type: "numeric". If the user tries to enter a =... formula the validator treats it as “not numeric”, marks it as invalid, and it shows the dark-orange colour. I know that goes away after refresh, but it’s disconcerting. Writing my own validator is not an option for me.
Furthermore, if a column is marked type: "numeric", allowInvalid: false, to enforce only numeric entry, if you want, say, the bottom cell to contain formula =SUM(...) you then cannot even get that into the cell! Overriding that cell’s properties is not an option for me.
I would suggest simply being able to have a formula cell (starts with =, when formulas enabled) automatically succeed or by-pass validation. If you feel that is too risky, add a formulasAutoValidate: true option.
It’s harder to know what to do about, say, a type: "autocomplete", strict: true, allowInvalid: false column cell where one might want a formula, as I suspect you may have input problems! For my part, I think the ability to handle formulas in type: "numeric" cells automatically is the most important/would suffice.
Thank you in advance and hope!
