SpreadProcessing: specific formula returns wrong result

Telerik Document Processing Feedback Portal

Create an account Log In

Back to Feed

Request a Feature Report a Bug

Completed

Last Updated: 16 Sep 2020 12:41 by ADMIN

Release R3 2020

Dimitar

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.

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.