In Development
Last Updated: 03 Aug 2020 12:48 by ADMIN
Scheduled for R3 2020
Created on: 07 Jul 2020 08:29
Category: SpreadProcessing
Type: Bug Report
SpreadProcessing: specific formula returns wrong result

To reproduce: 

- 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

Hi Solomon,

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.

Progress Telerik

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.