79447857

Date: 2025-02-18 10:20:17
Score: 7 🚩
Natty: 5
Report link

when any column configured as Dropdown List

Sheet.getPhysicalNumberOfRows()

or

sheet.getLastRowNum()

gives all the rows number (22463 / 22462) . User provides only 5 rows but due to dropdown list configured on 1st column, it assumes all the rows are available and return blank values for configured dropdown list value.

Is there any solution to read only 5 rows which user has added and skip the rest ?

Reasons:
  • Blacklisted phrase (1.5): any solution
  • Blacklisted phrase (1): Is there any
  • RegEx Blacklisted phrase (2): any solution to read only 5 rows which user has added and skip the rest ?
  • Has code block (-0.5):
  • Ends in question mark (2):
  • Starts with a question (0.5): when any
  • Low reputation (0.5):
Posted by: Chirag Shah