Making sure selected cell is visible

[Josh Sale]

In my ASP.Net OWC11 application, I use a server-side version of the OWC
spreadsheet to generate an XML representation of my data that I then ship to
a client-side version of the OWC SS on my aspx page.

The users want the application to retain the spreadsheet's scrolling
position across interactions with the server. For example if they've
scrolled down a few hundred rows when they click some button on the web
page, they want to still be scrolled down a few hundred rows when the page
is repainted. I'm already retaining the last selected cell(s) across these
interactions but I'm not sure how to maintain the scrolling.

Any suggestions?

TIA,

josh

 

[Josh Sale]

Well I've partially answered my own question ...

I can use the Show method of the Range object to scroll a particular cell
into the upper-left corner of the visible portion of the worksheet.

So I guess I'm left with the question of how on the server to figure out the
address of the cell scrolled into the upper-left corner of the visible part
of the screen when the user clicks some button?

josh