Posted 7 September 2021, 5:37 am EST
I’ve discovered another formula problem, similar to the one mentioned above, but in this case I’m trying to do an arithmetic comparison on operands that are strings consisting of numerical digits.
In the following example, the formula in column D gives a different result (FALSE) in Wijmo 5-20212-812 from what we get in our older version of Wijmo from 2018 (TRUE).
https://jsfiddle.net/lucksm1/6kxbyd17/
The operands are strings consisting entirely of numerical digits. The older Wijmo processed the formula like Excel – i.e. the string operands are treated as numbers, yielding the expected result TRUE.
Apparently the new Wijmo treats the operands as strings and returns FALSE. In order to get the expected result, the VALUE function has to be applied to the operands (Column E).
Is this a bug or a feature? Our application uses a large database of formulas that will have to be modified if we can’t recover the original behavior.
Thanks,
Mike