How to create opendocument ods files with optimal row height
<p>Application creates OpenDocument spreadsheets (ods file) in code.
Some rows contains caption with bigger font sized.
They are only partially visible if opened in LibreOffice.</p>

<p>All rows have same style ro1 which has <code>style:use-optimal-row-height="true"</code>
setting:</p>

<pre><code>    &lt;style:style style:name="ro1" style:family="table-row"&gt;
   &lt;style:table-row-properties style:use-optimal-row-height="true" fo:break-before="auto"/&gt;
    &lt;/style:style&gt;
</code></pre>

<p>This setting does not increase caption row height. All rows have same height.
How to force Libreoffice Calc and Excel to select optimal height for caption rows on table open?<br>
It is difficult to manually calculate row heights during file creation.</p>