On Sheet Change Scroll to A1

[David]

I would like to always freeze the first physical row and column whenever a sheet is selected. However the Freeze Panes method always indexes into whichever rows and columns are currently in the viewport, which might be anywhere on the sheet. How can I get the viewport to scroll to first physical row and column on sheet change?

[Dimitar]

Hello David,

You can use the BringIntoView method for this, and you need to update the layout before calling this method:

public MainWindow()
{
    InitializeComponent();
    radSpreadsheet.ActiveSheetChanged += RadSpreadsheet_ActiveSheetChanged;       
}

private void RadSpreadsheet_ActiveSheetChanged(object sender, EventArgs e)
{
    RadWorksheetEditor worksheetEditor = radSpreadsheet.ActiveWorksheetEditor;
    worksheetEditor.FreezePanes(new CellIndex(1, 1));

    radSpreadsheet.UpdateLayout();
    worksheetEditor.BringIntoView(new CellIndex(1, 1));            
}

I hope this helps. Should you have any other questions do not hesitate to ask.

Regards,
Dimitar
Progress Telerik

[David]

It helped in so far as it pointed me in right direction.

However it has a fatal flaw in that toggling back and forth among same worksheets causes weird effects on return to a previous one.

Here is what I ended up with, which does work:

private async void Spreader_ActiveSheetChanged(object sender, EventArgs e)
        {
            if (Spreader.ActiveSheet != null)
            {
                var ed = Spreader.ActiveWorksheetEditor;
                ed.BringIntoView(new CellIndex(0, 0));
                Spreader.UpdateLayout();
                await Task.Delay(100);
                ed.UnfreezePanes();
                await Task.Delay(100);
                Spreader.UpdateLayout();
                ed.FreezePanes(new CellIndex(1, 1));
            }
        }

Not sure the Task Delays are really necessary, but does assure one action completes before the next starts.

David Pressman

[Dimitar]

Hello David,

I am glad that you have found a solution for your case. Do not hesitate to contact us if you have other questions.

Regards,
Dimitar
Progress Telerik