Hi - I have a Table Box which contains a few thousand rows, so only the first few of those rows are directly visible within the window that contains it: to see the rest I need to scroll the Table Box with the vertical scroll bar. Somewhere within that Table Box is a row that satisfies a particular criterion. A simple script will tell me what that row number is, and the Set Selected Rows() property will highlight it for me, so I could easily scroll down the table to that row to find it - but I'd prefer to have the Table Box automatically scrolled to the right point so that the row is displayed for me.
Is there a way to script that? I can't see a property listed by the "Show Properties" command that looks as if it might perform such a function.
Are you graphing your data? If so, one thing you can do is to highlight a data point or set of points in the graph that are of interest. Navigate back to your data table and hit the F7 key. Typing F7 will take you to the row in the table for the data point that is first in the list of the selected points. You can then hit F7 again to take you to the next point. Hit F6 to take you back to a previous point.
I'm afraid not; this is something that I need to be able to do with a JSL script, because I'm trying to remove the need for any action on the part of the user while some other tasks are being run. If for example my script has already determined that the row the user needs to see is row 12345, but only the first 20 rows of the Table Box can be seen on the screen, then essentially what I need to be able to do here is send a message to the Table Box saying "scroll down to row 12345, so that row is displayed within the window".
One alternative way to do it would be simply to extract the contents of row 12345 and display it separately, but I'd prefer to scroll the display down to the relevant row because there's other information contained within the table around that position that's also likely to be of interest to the user.
It may be that I can't actually do this, in which case I'll find another other way out - but I felt it was worth asking first.
I am not aware of any messages that can be sent to a table box to have it scroll to a specific location. I have put in such a request to Support@jmp.com, but I have not seen anything as of yet.
I hope there is someone out there that can prove me wrong