Hello,
I am using a Telerik RadSpreadsheet (Telerik.Web.Spreadsheet.dll v. 2016.3.1024.40) in our application. I am testing with Chrome v. 57.
The spreadsheet is configured with a ColumnCount of 29 (i.e., A through AC) and these are displaying correctly.
However:
- It is possible to horizontally scroll past the end of the columns.
- The horizontal scrollbar slider is not resized according to the ratio of visible columns versus total columns (e.g., like the vertical scrollbar slider).
- Dragging the slider left or right scrolls quickly past the end of the columns and is therefore not usable. (Clicking the right and left buttons scrolls about 1 column at a time and is usable.)
I am using the following code to load and populate the spreadsheet server-side:
// set template spreadsheet
protected void Page_Init(object sender, EventArgs e)
{
// get provider instance
FTSpreadsheetDocumentProvider provider;
provider = new FTSpreadsheetDocumentProvider(Server.MapPath(SPREADSHEET_VIRTUAL_PATH), this);
RadSpreadsheet1.Provider = provider;
}
// bind template spreadsheet
protected void RadSpreadsheet1_DataBinding(object sender, EventArgs e)
{
RadSpreadsheet1.ColumnsCount = SPREADSHEET_COLUMNS_COUNT; // =29
RadSpreadsheet1.RowsCount = SPREADSHEET_ROWS_COUNT; // =21
}
// populate the data
protected void RadSpreadsheet1_DataBound(object sender, EventArgs e)
{
var sheet = RadSpreadsheet1.Sheets[0];
sheet.FrozenColumns = 2;
sheet.Rows[0].Cells[0].Value = ...
The attached screenshot shows the page with the horizontal slider about halfway across, which is well past the end of the columns (except for the 2 frozen columns). (PS It's not much better without the frozen columns.)
Can you please let me know how to get the horizontal scrollbar working correctly?
Thanks,
Severin B.