该文章介绍怎样通过 JS 代码操作 Spread 滚动条:
1.操作步骤:点击 button 通过像素值设置滚动条位置。选择 Select Option 通过 Spread 前台方法 SetActiveCell 控制滚动条位置。
2.截图:
3.参考代码:
function Button1_onclick() {
var spread = document.getElementById("FpSpread1_view");
var scrollTopPosition = spread.scrollTop;
var scrollLeftPosition = spread.scrollLeft;
spread.scrollLeft = 200;
spread.scrollTop = 200;
}
function change() {
var spread = document.getElementById("FpSpread1");
var select = document.getElementById("Select1");
var row = select.options[select.selectedIndex].value;
spread.SetActiveCell(row, 0);
}
function window.onload() {
var spread = document.getElementById("FpSpread1"); ;
spread.SetActiveCell(32, 0);
var cell = spread.GetCellByRowCol(32, 0);
var rowHeader = spread.all(spread.id + "_rowHeader");
var colHeader = spread.all(spread.id + "_colHeader");
var view = spread.all(spread.id + "_view");
if (view != null) {
view.scrollTop = cell.offsetTop;
view.scrollLeft = cell.offsetLeft;
}
}
复制代码
环境:VS 2010 && Spread for .NET 6 SP3