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

Maximize Spreadsheet to page size

2 Answers 118 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Kenneth
Top achievements
Rank 1
Kenneth asked on 16 Feb 2017, 07:07 PM

I want to make the Spreadsheet control the same size as the browser window.  So I am trying to use the RadSplitter/RadPane method to do this.  However, it's not really working and there are several weird things happening.

            <telerik:RadSplitter ID="splitter" runat="server" OnClientLoaded="SplitterLoaded"
                BorderSize="1" PanesBorderSize="1" Width="99%">
                <telerik:RadPane ID="pane" runat="server" Width="100%">
                    
                    <telerik:RadSpreadsheet runat="server" ID="radSheet" Height="99%" Width="99%" />
                
                </telerik:RadPane>
            </telerik:RadSplitter>

 

1.  As seen in the "sheet_before_event" image, the control doesn't initially fill the RadPane.

2.  However, after an event is fired (click in my case) the spreadsheet will then fill the RadPane, as seen in "sheet_after_event" image.

3.  Through all of this the sheet view inside the control remains small with scroll bars.

Am I trying to do something that isn't currently supported?

 

2 Answers, 1 is accepted

Sort by
0
Accepted
Peter Milchev
Telerik team
answered on 21 Feb 2017, 11:06 AM
Hello Kenneth,

This appearance is caused by the fact that the Spreadsheet is rendered before the end of the Pane resizing.

To workaround this issue, one option is to resize the underlying Kendo widget of the Spreadsheet in the OnClientLoaded and OnClientResized event handlers:

<script>
    function OnClientResized(sender, args) {
        var spreadsheet = $find('<%= radSheet.ClientID %>');
        spreadsheet.get_kendoWidget().resize();
    }
 
    function OnClientLoaded(sender, args) {
        var spreadsheet = $find('<%= radSheet.ClientID %>');
        spreadsheet.get_kendoWidget().resize();
    }
</script>
<telerik:RadSplitter ID="splitter" runat="server" OnClientLoaded="OnClientLoaded"
    BorderSize="1" PanesBorderSize="1" Width="99%">
    <telerik:RadPane ID="pane" runat="server" Width="100%" OnClientResized="OnClientResized">
        <telerik:RadSpreadsheet runat="server" ID="radSheet" Height="99%" Width="99%" />
    </telerik:RadPane>
</telerik:RadSplitter>

Regards,
Peter Milchev
Telerik by Progress
Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
0
Kenneth
Top achievements
Rank 1
answered on 23 Feb 2017, 07:56 PM
Exactly what I needed!  Thank you!!!
Tags
Spreadsheet
Asked by
Kenneth
Top achievements
Rank 1
Answers by
Peter Milchev
Telerik team
Kenneth
Top achievements
Rank 1
Share this question
or