Horizontally scrolling goes beyond count of columns

2 posts, 0 answers
  1. Severin
    Severin avatar
    5 posts
    Member since:
    Oct 2015

    Posted 04 Apr 2017 Link to this post

    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.

  2. Severin
    Severin avatar
    5 posts
    Member since:
    Oct 2015

    Posted 04 Apr 2017 in reply to Severin Link to this post

    I found that the rssScroller.rssViewSize width was "1.04888e+06px". The horizontal scrollbar works as expected if I override width to 2000px (using Chrome Developer Tools).

    I also noticed that _refresh() is called many times, each time increasing the total (which is used to calculate the width), until presumably it grows to 10488843.

    The call stack is:

    _refresh

    value

    fromJSON

    (anonymous)

    batch

    fromJSON

    insertSheet

    fromJSON

    init

    init

    (anonymous)

    each

    each

    b.fn.(anonymous function)

    initializeWidget

    ...

     

    SB

Back to Top