I am creating Quote templates using Excel and Drawloop with Salesforce. On the template, I need to replicate Quote Line Items, and there is no limit to how many line items there can be. When there are many line items, the bottom of the document end up outside of the print area and gets cut off. How can I make the print range of an excel file dynamically increase in size depending on the number of rows using row replication?
I recommend using an OFFSET formula to dynamically set the print area. Here is a tutorial to assist you: https://www.extendoffice.com/documents/excel/3815-excel-dynamic-print-area.html