This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
This is a little strange behaviour. It seems that the render does not like the A4 page layout size (or Letter) when outputting to Excel. The quick fix that I got to work was to change the Paper Size to A3 or B3, however this would then fail if the data was larger than a normal A3/B3 sheet....
It looks like a bug, so would be worth sending to Client Services to be logged. I've attached a version that has data and can be run by anyone to test.
The reason is that your data has too many columns to be fit into the page width requested in the Render tool. The Render is meant to produce document for printing purposes (reports and such). As I would expect, your workflow is throwing a warning message "the current page layout will cause some data to be incorrectly truncated. You may consider modifying how the data is laid out"
If you want to output a larger amount of data with the Render tool, then you would have to change, as suggested, the paper size to custom and increase the page width (the first value), don't be shy increasing that number, it seems that 20 did the trick for your sample data, it depends on the number of columns, I've seen it increased over 140. I think it is working as designed so no cucaracha =)
Let me know if you want to discuss further.
Margarita Wilshire Sr. Manager, Customer Support Engineering Women & Allies Committee
Silly question as I realise it's just an example, but why use Render here? The output tool is much better for xlsx data output, I appreciate you can't do formatting then but a formatted Excel report is probably the worst way to deliver this data anyway...