Is there a way to ignore spreadsheet link references?

[Kenneth]

When importing data, we have a client that is using a spreadsheet link in their formula to grab data like so:

='H:\[OtherSheet.xls]Sheet1'!E3

(This other sheet does not exist in our system). When loading this into the Kendo spreadsheet via FromFile, we see the value [1]Sheet!E3 and the cell is highlighted red. This makes sense as we don't have the referenced sheet, but I noticed when we open the sheet in Excel, the cached value from for this cell exists and when using libraries like ExcelDataReader, we are able to parse out the actual cached value instead of looking for the sheet reference.

So how do we get the spreadsheet control to ignore the spreadsheet reference links and instead use the cached cell values that are already in the sheet?

[Ivan Danchev]

Hello Kenneth,

Currently, this behavior is not configurable and in order for the Spreadsheet to ignore the references this has to be implemented explicitly. We would suggest logging a feature request in our Feedback Portal and vote for it: https://feedback.telerik.com/kendo-jquery-ui

Usually, the highly demanded features are implemented with precedence in subsequent releases.

Regards,
Ivan Danchev
Progress Telerik