How to Adjust the Range so Set_List Does not Go Over its Max Rows
One of our test cases has us verifying a variety of reports and some of the static data within the reports. The SET_LIST function from my understanding tops out at 100 Rows. I noticed from other posts that you were able to adjust the preferences to maybe 200 or 300 rows. So, I wasn't sure if you still were able to do that or had some other reasonable work arounds for us. Additionally, I see you can select a range but I for some reason could not get it to reasonably work. I was hoping to select a range from A1, all the way over to column Z and down 100 rows which is supposedly what the max is currently set at for our users. I kept failing, which made it seem like I was configuring it incorrectly.
Please sign in to leave a comment.