When importing data, we have a client that is using a spreadsheet link in their formula to grab data like so:
(This other sheet does not exist in our system). When loading this into the Kendo spreadsheet via FromFile, we see the value 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?