This is a migrated thread and some comments may be shown as answers.
Is there a way to ignore spreadsheet link references?
1 Answer 2 Views
This is a migrated thread and some comments may be shown as answers.
Kenneth
Top achievements
Rank 1
Kenneth asked on 07 Jan 2021, 05:00 PM

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?

1 Answer, 1 is accepted

Sort by
0
Ivan Danchev
Telerik team
answered on 11 Jan 2021, 03:10 PM

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

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

Asked by
Kenneth
Top achievements
Rank 1
Answers by
Ivan Danchev
Telerik team
Share this question
or