In Development
Last Updated: 03 Aug 2020 12:48 by ADMIN
Scheduled for R3 2020
Dimitar
Created on: 07 Jul 2020 08:29
Category: SpreadProcessing
Type: Bug Report
1
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.

2 comments
ADMIN
Dimitar
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.

Regards,
Dimitar
Progress Telerik

Solomon
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.