We generate reports as spreadsheets (by directly modifying the
content.xml of a template document). Some of the cells can have multiple lines, and the cell contents vary in width as well. All columns and rows are set to use the optimal width/height, and I would like the display to adjust automatically when the user opens the document.
content.xml styles contain
<style:style style:name="ro1" style:family="table-row"> <style:table-row-properties fo:break-before="auto" style:use-optimal-row-height="true"/> </style:style>
(I have removed the
The only thing I can think of is to create a macro that sets optimal widths/heights and bind it to a keyboard shortcut. Is there any other way to achieve this?