Completed
Last Updated: 08 Feb 2021 15:00 by ADMIN
Release LIB 2021.1.215 (15/2/2021)
Simeon
Created on: 22 Jan 2021 08:18
Category: Spreadsheet
Type: Bug Report
1
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.
2 comments
ADMIN
Martin
Posted on: 22 Jan 2021 11:36

Hello Simeon,

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).

Regards,
Martin
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/.

Simeon
Posted on: 22 Jan 2021 09:01
Importing something and skipping the unsupported chart sheet (see Spreadsheet: Implement support for ChartSheet (telerik.com) would be better than just throwing an exception.  I appreciate the full support is probably a lot harder so its up to Telerik to balance the effort.