Spreadsheet: ArgumentOutOfRangeException is thrown when importing a document containing a ChartSheet preceding the WorkSheet
When importing a document containing a ChartSheet (currently not supported: Implement support for ChartSheet) with a smaller tab index than the WorkSheet an ArgumentOutOfRangeException is thrown.
Posted on:22 Jan 2021 11:36
I have already answered you in the private ticked you had opened. For visibility, I am placing the answer here as well:
Currently, we are skipping the ChartSheet but in the specific scenario, there is a Defined Name referencing the WorkSheet by a not adjusted local ID (which is causing the exception). We should adjust the ID according to the skipped ChartSheet(s).
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/.