Worksheet scrolls to top on DoAction or row/column resize (WPF)

[DemTomLee]

Is there a way to prevent a worksheet from scrolling to the top of the sheet when a DoAction is triggered or a row or column is resized?

[jingwood]

I just tested DoAction and resizing worksheet, I can't confirm that worksheet scrolls to the top. Can you provide some code to reproduce it?

[DemTomLee]

It appears that this is occurring because I have the first row frozen. In the example source code below, if you scroll down and delete a row using the button the worksheet scrolls back to the top. Note that this behavior does not occur when a row is not frozen.

Example source code:

MainWindow.xaml:

<Window x:Class="TestReoGrid.MainWindow"
        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
        xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
        xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
        xmlns:rg="clr-namespace:unvell.ReoGrid;assembly=unvell.ReoGrid"
        xmlns:local="clr-namespace:TestReoGrid"
        mc:Ignorable="d"
        Title="MainWindow" Height="400" Width="800">
    <Grid>
        <Grid.RowDefinitions>
            <RowDefinition Height="40"/>
            <RowDefinition Height="*"/>
        </Grid.RowDefinitions>

        <Button x:Name="TestButton" HorizontalAlignment="Left" VerticalAlignment="Top" Content="Test" Width="85" Height="30" FontSize="11" Click="TestEvent" Margin="5,5,0,0" />

        <rg:ReoGridControl x:Name="Grid" Grid.Column="0" Grid.Row="2"/>
    </Grid>
</Window>

MainWindow.xaml.cs:

using System.Windows;
using unvell.ReoGrid;

namespace TestReoGrid
{
    public partial class MainWindow : Window
    {
        public MainWindow()
        {
            InitializeComponent();

            SetGridProperties();
        }


        public void SetGridProperties()
        {
            var workbook = Grid;

            workbook.SheetTabNewButtonVisible = false;

            var worksheet = workbook.CurrentWorksheet;
            worksheet.Name = "Data";

            worksheet.FreezeToCell(1, 0);
        }


        public void TestEvent(object sender, RoutedEventArgs e)
        {
            unvell.ReoGrid.ReoGridControl workbook = Grid;

            unvell.ReoGrid.Worksheet worksheet = Grid.GetWorksheetByName("Data");

            int rowIndex = worksheet.SelectionRange.Row;
            int rowCount = worksheet.SelectionRange.Rows;

            try
            {
                var action = new unvell.ReoGrid.Actions.RemoveRowsAction(rowIndex, rowCount);

                workbook.DoAction(action);
            }
            catch { }
        }
    }
}

[jingwood]

Thanks! By freeze to cell I can confirm this problem, it should be fixed.

[giffunis]

Hi, this happen on Windows forms too. I have tryed to find a solution and I saw this on ViewControl.Cs

If I comment it, all seems to work fine.