Hi great community of OL!
I’m having troubles to fit my text content on the table.
My table structure is the following:
Here is the result that I’m getting:
And here is the desired result:
But this is what I’m getting:
I have tried use static tables and dynamic tables but without success, any kind of direction will be appreciated. I suspect that I need to draw the whole table with a script to control how the text is rendered, but maybe someone with more experience can help me. My data origin is a xml file.
In advance thank you for any suggestion.
Pagination cannot split a table row in half for you, and that’s what would be required for this to work. That block of text is simply too long to fit on a single page.
I’d think the best way to approach this kind of depends on the way the data is presented in the datamapper. If this block of text is something that could be captured as multiple detail records, then this becomes a fairly simple task.
If it’s presented in one huge block already, however, then breaking it up intelligently may be more difficult. You’ll need to effectively detect where to break the data and split it up prior to putting it into a table.
Thanks for your response. I suspected that the text is just too long. I will see what I can do to manipulate the data before using it on the template.
If you have paragraphs in the text, make each its own record in DataMapping - this is achieved by building table records in a JS script and making use of .split(“\r\n”) function that converts your string into an array of paragraphs. You will also needt to conditionally apply styles to the <tr> tag, making any subrecords below the first one to not have a top border. Alternatively, apply banding to separate records (interleaving white/grey background to delimit where a record starts and where it ends).
Thanks for your reply @puszczyk your approach sounds good. As soon as I can I will try the implementation of this solution and I will be posting the results. Again thank you very much.
No problem, I need to correct myself on the split though: \n\r might not consistently work with your average Excel alt+return (bare \r) or data pasted from unix text (\n). Instead do a regex split:
var re = /(\s*[\n\r]+\s*)/gi; //pattern for any amount of \n or \r characters preceeded and followed by any amount of whitespace
var celltext = “some text separated into paragraphs”;
var paragraphs = celltext.split(re);
