Skip to Content
0
Former Member
May 08, 2010 at 12:23 PM

Spreadsheet : How to force select record to row 1

39 Views

I have a spreadsheet output that will display 1 to many rows depending on the query parameter. I want the selected row to default back to row 1 after re-running the query that populates the spreadsheet.

Currently, when I select spreadsheet row#2, this triggers another query that pulls additional data according to the selected row. The problem is this: when i run the initial query that re-populates the spreadsheet and there is no record or row #2, Xcelsius throws a parameter error message because the 'refreshed' spreadsheet still has the focus set on 'row 2' from the previous step.

What is the best way to get passed this where each time i run the query that populates the spreadsheet and that it focuses on row 1 always.

I've tried setting the properties to 'select row 1' doesnt solve the issue.