SpreadProcessing: specific formula returns wrong result
- Add the following formula to a cell: "=A1=FALSE"
Actual: the result is always false
Expected: the result should be true when the cell is empty
Workaround: Use the ISBLANK function.
Posted on:13 Jul 2020 07:53
I understand that you can have files where this is already set. Hopefully, our developers will fix this soon. I would recommend using the follow button, this way you will be notified when the item status changes.
Do not hesitate to contact us if you have other questions.
Posted on:07 Jul 2020 15:20
We noticed the issue in the document processing library, which we use to process third party spreadsheets. We don't get to choose the formulas. In this case, we asked them to change their formula. However, in general, this type of library needs to follow convention.