I’m trying to use the PageSetup.setPrintTitleRows/Columns :
I know in both the cases the first value example $1, indicates the start row, how could I determine the second value in a dynamic way (hard coded to $5) in the ‘setPrintTitleRows’
I have the scenario where the row titles could be 2 rows in one document and it could be 5 rows in another during conversion. I would like to make sure all the pages in a given sheet (if its on multiple pages) to have the same row title.
Please let me know if there is an API to get the number of rows that make up the title on the first sheet.