Scrolling programatically

Posted by: yianeco on 20 June 2020, 4:53 am EST

  • Posted 20 June 2020, 4:53 am EST

    Hi,
    Is there a way to scroll sheet programatically?
    Thanks

    Yiannis
  • Replied 23 June 2020, 10:06 pm EST

    Hi Yiannis,

    You can use the ShowCell method for the purpose. This method scrolls the sheet so that the specified cell appears in the specified position, without changing the active cell.

    Here is the documentation link:
    https://help.grapecity.com/spread/Spread8/WebSiteHelp/webframe.html#funct375.html

    Thanks,
    Pragati
  • Replied 25 June 2020, 4:30 pm EST

    ShowCell is not helpful because in order to use it you need to pass the row number of the last (or first) row displaying on the screen. I do not know of anyway to get that row number.

    Regards

    Yiannis
  • Replied 25 June 2020, 9:02 pm EST

    Hi Yiannis,

    I am sorry but I could not get the last response. Can you please confirm what do you want to convey from that?

    ~Pragati
  • Replied 25 June 2020, 9:40 pm EST

    Programatically move the sheet (scroll bars)

    Yiannis
  • Replied 30 June 2020, 9:32 pm EST

    Hi Yiannis,

    I have asked the developers for the same [internal tracking ID: 279161]. Will let you know once there is any information from them.

    Thanks.
  • Replied 2 July 2020, 5:08 am EST

    Thank you.
    You but I must notice that similar issues/ requests are given a tracking number but we never hear from the developers. I have many examples that go back over a year ear and and nothing has happened.

    If you are not planning to to release an update for the software please let us know.

    Anyway, back to the issue in hand.
    I have noticed that when using page up key the vertical scrollbar is moving and the sheet moves also. But whe page down key this does not happen. Any explanation for this?. If page down key was working also I could use this for the purpose I want.

    Regards

    Yiannis
  • Replied 2 July 2020, 10:01 pm EST

    Hi Yiannis,

    Let me ask the developer regarding your case. Will get back to you on this.

    Also, I could not replicate the Page down key related issue at my end. When the key is pressed, the sheet is moved as expected. I verified the behavior using the following product sample:
    C:\Program Files (x86)\FarPoint Technologies\Spread 8\Samples\ActiveX\VB6\Demo Overview

    Can you please share a small project demonstrating the behavior you mentioned?

    Thanks.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels