cancel
Showing results for 
Search instead for 
Did you mean: 
maddieleblanc
Nintex Newbie

How can I make the print range of an excel file dynamically increase in size depending on the number of rows using row replication in Drawloop?

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?

0 Kudos
Reply
1 Reply
haleywalsh
Nintex Newbie

Re: How can I make the print range of an excel file dynamically increase in size depending on the number of rows using row replication in Drawloop?

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 

Reply