IF function.

[Jakub]

Hi,

I have an excel file with simple IF function and as you can see in screens, it works directly opposite than it should work.

 

The same file in MS Excel works correct. Any suggestions?

 

[Boby]

Hello Jakub,

I can confirm that there is difference when comparing empty cells with the comparison operators =, <>, etc. As a workaround, you can use the ISBLANK funciton, which results are consistent with MS Excel. 

The following is the item for the bug in our feedback portal: 
SpreadProcessing: Comparison operators evaluates "" and reference to empty cell as not equal

Please, excuse us for the inconvenience. We have added points to your account for the report. Don't hesitate to contact us if you have other questions.

Regards,
Boby
Telerik by Progress

[Jakub]

Hi Boby,

your workaround works as expected, thanks.

 

I'm also using TRIM function, which can be found in functions list:

http://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/formulas/functions

 

However, in my applications it looks like it isn't implemented. Please check attached screen.

 

Best regards,

Jakub.

[Tanya]

Hello Jakub,

The support for the TRIM function has been implemented in the last version of the control (R2 2017). Could you please verify that you are using this version?

I tested the function and seems to be working as expected. If you are experiencing issues with the latest version of RadSpreadsheet, please send us more details on the scenario so we can reproduce and test it on our end.

Regards,
Tanya
Telerik by Progress

[Jakub]

Hi Tanya,

updating to the R2 version resolved an issue.

 

Thanks !