SpreadProcessing: Handle importing and reading cached formula value when the formula contains external references

Telerik Document Processing Feedback Portal

Create an account Log In

Back to Feed

Request a Feature Report a Bug

Completed

Last Updated: 02 Aug 2024 11:09 by ADMIN

Release 2024.3.802 (2024 Q3)

Stefan

Created on: 12 Jun 2024 06:51

Category: SpreadProcessing

Type: Feature Request

SpreadProcessing: Handle importing and reading cached formula value when the formula contains external references

It would be beneficial for the clients if every cell has this "cached value" even if the formula can't be evaluated for some reason with the SpreadProcessing - no need for recalculation, just reading the value. It should read the last values while the document was being saved at the originator.

Getting a method like "GetCachedValueString ..." , ideal with the same formatting used for the cell and localization, would be helpful.

2 comments

ADMIN

Dess | Tech Support Engineer, Principal

Posted on: 14 Jun 2024 11:42

Hi, Stefan,

We will do our best to offer a proper way of reading the last cached evaluated value even though if the formula can't be recalculated with RadSpreadProcessing.

It is expected to continue using the GetResultValueAsString method to obtain the cached value which represents the evaluated formula value read from the file. Make sure that you click the Follow button to get notified for any status changes.

Regards,
Dess | Tech Support Engineer, Principal
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

Stefan

Posted on: 12 Jun 2024 11:32

Or add a property to the workbook/worksheet to ignore ExternalReferences and use the "last value", as done in Excel if external references are unavailable.