Get highest row ignoring empty results from formulas

Topics: User Forum
Jan 28, 2014 at 10:56 AM
I have a table with 1000 rows. But, the user can write data only for the 10 first rows. When I call getHighestDataRow() or getHighestRow() I still getting 1000 instead of 10. This is because I have formulas in one of the columns. In this case, how can I get 10 instead of 1000 rows?