I found problem in excel library when I used function ctx.excel.getLastRow2('A2') in attached excel file , it's alway return 1000 but when I used ctx.excel.getLastRow('A2') it's return the exact value. as in the image below.
Accordingly, I want to know the difference between getLastRow and getLastRow2 and when to use it.
Thank you.