Spreadsheet Control Not Rendering Properly

[David]

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.

[Peter Milchev]

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:

• https://feedback.telerik.com/aspnet-ajax/1493177-spreadsheet-appears-broken-when-its-parent-container-is-initially-hidden 

Regards,
Peter Milchev
Progress Telerik