Unplanned
Last Updated: 21 Nov 2019 12:44 by ADMIN
Fritz
Created on: 21 Nov 2019 09:23
Category: Spreadsheet
Type: Bug Report
0
RadSpreadsheet: StylesGallery throws exception if the style name is invalid formula

Hi Support,

 

please try set the WorkBook to RadSpreadsheet.

Best regards

Fritz

1 comment
ADMIN
Nikolay Demirev
Posted on: 21 Nov 2019 12:44

Hi Fritz,

Thank you for providing a document and a stack trace that can be used to reproduce the issue.

I was not able to reproduce the exact exception from your stack trace, but I have observed another one which was caused by a CellStyle called "+-". The items in the StyleGallery are screenshots of the cells of the RadSpreadsheet with all the styles applied to the cells and each cell has its value set to the name of each cell style. The exception is caused because the value "+-" is not a valid cell value. As Excel manages to open the document this can be categorized as a bug.

I have logged it in our feedback portal by making this thread public. You can track its progress, subscribe for status changes and add your comments on the following link - feedback item.

 

I have also updated your Telerik points.

 

As a workaround of the issue, you could rename the cell style.

Could you try to edit the document in Excel and rename the CellStyle called "+-" to something not starting with "=", "-" or "+" and try to import it in your application and let me know if you still observe the exception you have reported?

I am looking forward to your reply.

Regards,
Nikolay Demirev
Progress Telerik

Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.