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.
Below is the partial workflow as part of reporting
Excel is the output report for this workflow using RENDER tool. Data gets truncated when report is generated in excel format whereas html report shows up all the data. How to avoid the truncation? please help
Warning msg: The current page layout will cause some data to be incorrectly truncated. You may consider modifying how the data is laid out.
I found that it only works to a certain extent. I have a very wide set of columns that I want to Render into an Excel file, and beyond a certain number of characters it gives that same warning message, and started dropping random characters from the data.
I then chose the widest possible standard Paper Size - "B3 (353mm x 500mm)" - and "Landscape" Orientation. This allowed me to include more columns, but still at a point this generated the same warning message, and loss of characters.
I thought that perhaps choosing a Paper Size of "Custom Size", and entering 353mm x 600mm would resolve the issue, but it did not help.
What is the cause of this limitation? Shouldn't I be able to Render into an Excel format as wide as I need, without limitation?