Unplanned
Last Updated: 14 Aug 2024 14:57 by Charles
Charles
Created on: 14 Aug 2024 14:57
Category: Spreadsheet
Type: Bug Report
1
When calling the Workbook.ToJSON method on a workbook document where all cells have AnyValueDataValidation the application crashes

Bug report

When applying data validation to all cells of a xlsx file and trying to import the file via Telerik.Web.Spreadsheet as demonstrated in the Server Import/Export demo the application will crash.

Reproduction of the problem

  1. Check ticket 1661158 for a sample xlsx file.
    N.B. The sample file has an AnyValidation rule applied to all cells and a title set for the cells. In addition two columns have predefined styling rules - font, fontSize, etc.
  2. Try to load the file using Telerik.Web.Spreadsheet, as demonstrated in the Demo.

Current behavior

Loading will fail.

Expected/desired behavior

File should be loaded

Possibly related to #4017
In the reported scenario there are 1048576 rows, with 16384 columns, resulting in 17179869184 cells all with applied non-default validation value, and we iterate them all to set the validation value, so it can be serialized.

Environment

  • Kendo UI version: 2024.3.806
0 comments