This is a migrated thread and some comments may be shown as answers.

Spreadsheet Control Not Rendering Properly

1 Answer 19 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
David
Top achievements
Rank 1
David asked on 27 Oct 2020, 03:06 PM

I ran into an issue with the RadSpreadsheet control embedded in a RadWizard step. The control would appear on the screen with an empty cell area, no grid and no data. I could verify the file was loaded properly because the data in cell A1 could be seen in the Formula Bar. Resizing the browser window in any way would immediately trigger the control to refresh and everything looked great, but not until then. I contacted Telerik Support and Peter Milchev very quickly responded with the following:

"The problem with the Spreadsheet appearance is due to the fact that the control's container is initially hidden, hence the calculations are wrong.
We have researched a bit and it turns out the behavior can be further improved and the control could handle itself a hidden parent container. 
Until that becomes a part of the source code, please verify that adding the following script Under the ScriptManager would fix the issue."

<script>
    if (Telerik.Web.UI.RadSpreadsheet) {
        Telerik.Web.UI.RadSpreadsheet.prototype.original_initialize = Telerik.Web.UI.RadSpreadsheet.prototype.initialize;
        Telerik.Web.UI.RadSpreadsheet.prototype.initialize = function () {
            this.original_initialize();
            this.add_parentShown(this.get_element());
        }
        Telerik.Web.UI.RadSpreadsheet.prototype.repaint = function () {
            this.get_kendoWidget().refresh()
        }
    }
</script>

 

The workaround resolved the issue immediately. I hope this helps you as much as it helped me.

1 Answer, 1 is accepted

Sort by
0
Peter Milchev
Telerik team
answered on 30 Oct 2020, 11:47 AM

Hello David,

Thank you for taking the time to share the solution to your problem with the community. 

I have logged this as an official feedback portal item so everyone can follow it and subscribe to get notified when there is any progress on it:

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

Tags
Spreadsheet
Asked by
David
Top achievements
Rank 1
Answers by
Peter Milchev
Telerik team
Share this question
or