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

Worksheet doesn't scroll when selecting rows

8 Answers 94 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Steve
Top achievements
Rank 1
Steve asked on 26 Apr 2019, 07:07 AM
In Excel, if you select a row and then drag down past the bottom of what is visible, it scrolls automatically for you. But the RadSpreadsheet does not do this. Is there an option I am missing or an easy workaround?

8 Answers, 1 is accepted

Sort by
0
Молчан
Top achievements
Rank 1
answered on 26 Apr 2019, 09:35 AM
I guess no,u r not missing anything..it is only the most accurate way..Though bit tedious 
0
Peshito
Telerik team
answered on 30 Apr 2019, 09:39 AM
Hello,

I tried reproducing the issue but to no avail. Selecting cells and dragging the selection past down the bottom boundaries of the spreadsheet does automatically scroll downward. Attached is a video I recorded during my test. Could you attach a sample runnable project reproducing the issue? As this is a forum thread, you could either attach it to a sire for files sharing or submit a support ticket.

Regards,
Peshito
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.
0
Steve
Top achievements
Rank 1
answered on 30 Apr 2019, 07:06 PM

I'll see if I can try to put together an example at some point, but I'm working towards a pretty hard deadline in a few weeks right now and this is something that can wait until after. Some additional information I can add right now is that I have a RadRibbonWindow with a ContentControl in a Grid, and I am assigning a new spreadsheet to the contentcontrol.content at runtime in the code-behind, in case that makes any difference.

 

        <Grid Grid.Row="1">
 
            <!--Holds report content-->
            <ContentControl Margin="8" x:Name="ReportContent">
                <ContentControl.Effect>
                    <DropShadowEffect Direction="320" ShadowDepth="4" BlurRadius="12" Opacity="0.75"/>
                </ContentControl.Effect>
            </ContentControl>
.....
        </Grid>

In the code behind, there is a lot of logic to determine what gets set as the content, but in this code path it is effectively:

Me.ReportContent.Content = New Controls.RadSpreadsheet
0
Peshito
Telerik team
answered on 03 May 2019, 07:37 AM
Hi Steve,

Thanks for the heads up. The additional information was helpful in reproducing the issue. It is caused by the fact that RadSpreadsheet uses UI Virtualization and processes only information that is loaded in the viewable area. This means that you should not place it in controls/panels which will measure it with infinity. Such controls can be ScrollViewer, StackPanel or Grid with Row.Height and Column.Height set to Auto.

Please let me know if any other questions arise.

Regards,
Peshito
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.
0
Steve
Top achievements
Rank 1
answered on 14 May 2019, 06:26 PM

Even if I remove everything from around the content control which contains the spreadsheet and hardcode an explicit height and width, it still doesn't work correctly. I also tried removing the content control entirely and just set the content into the window as Me.Content = New Controls.RadSpreadsheet.

 

<telerik:RadRibbonWindow x:Class="Reporting.ReportViewer" x:Name="ReportViewer"
    mc:Ignorable="d"
    Icon="/Ace;component/Common/Images/32x32/Report.png"
    Height="600" Width="800" MinHeight="300" MinWidth="315"
    WindowStartupLocation="CenterOwner" Title="Report"
    Background="{DynamicResource Docking_Background}">
 
    <!--Holds report content-->
    <ContentControl Margin="8" x:Name="ReportContent" Height="400" Width="400">
        <ContentControl.Effect>
            <DropShadowEffect Direction="320" ShadowDepth="4" BlurRadius="12" Opacity="0.75"/>
        </ContentControl.Effect>
    </ContentControl>
 
</telerik:RadRibbonWindow>
0
Peshito
Telerik team
answered on 15 May 2019, 12:38 PM
Hi Steve,

Thank you for getting back to us. It is difficult to find out what else might be causing the issue by referring to the sample code. Could you please attach a sample runnable app reproducing it so I could debug it locally and provide you more appropriate answer?

Looking forward to your reply.

Regards,
Peshito
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.
0
Steve
Top achievements
Rank 1
answered on 07 Nov 2019, 07:53 PM

Some further information. It does scroll if I start the selection from a regular cell but not if I start from a row header. See attached video.

 

I was never able to see your swf format video, so I don't know if that is what you were doing. But I think it is pretty clear that it is not "in controls/panels which will measure it with infinity".

0
Peshito
Telerik team
answered on 11 Nov 2019, 01:16 PM

Hello Steve,

I was able to reproduce this unwanted behavior. It appears that this is a missing feature and I created a feature request on your behalf - Scroll document when a row header is selected and being dragged. I have also updated your Telerik points as gratitude to this finding. 

Please subscribe to the item in order to get notified of any status changes over this request.

Regards,
Peshito
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.
Tags
Spreadsheet
Asked by
Steve
Top achievements
Rank 1
Answers by
Молчан
Top achievements
Rank 1
Peshito
Telerik team
Steve
Top achievements
Rank 1
Share this question
or