Aspose.Cells.GridWeb - scroll control

Aspose.Cells Product Family
1

Hi
From source code (C# or JavaScript) we need to select cell in GridWeb control and scroll to it to make it visible for user?

For selecting cell we use GridWeb.Attributes.Add(“activerow”, “20”) and
GridWeb.Attributes.Add(“activecol”, “20”), but we don’t know how to force control to scroll to display selected cell.

2

Hi,

Thanks for your interest in Aspose.Cells for GridWeb.

I think, this feature is not yet available. So I have logged this as a New Feature Request. We will update you asap.

This issue has been logged as CELLSNET-28831.

3

there is a possibility to scroll websheet from C# code, however I have no idea how to calculate correct value
GridWeb.ViewPanelScrollTop = “500”;
GridWeb.ViewPanelScrollLeft = “500”;

4

Hi,

I think, you are trying to focus some cell in WebWorksheet. I have added your comment. We will update you with code example asap.

5
Hi,

Please try the following scripts, it can suit your need.

var g = document.getElementById("GridWeb1");
var row = 29, col = 9;
g.setActiveCell(row, col);

Thank you.