Hello Wolfgang, yes, it is likely a problem of LibreOffice not showing a text content with large font in a cell with no explicit row height. I created a small test spreadsheet with LibreOffice doing a hello world with hello in a cell in one row and world in the next row with a very high font (see document attached). After saving the document with LibreOffice, I manually removed the explicit row height on the second row with the high font text. The row has after reload the same row height as any other rows and the content with the high text font vanished. This happens for latest MS Office as well, but works with OpenOffice.org.
The bug you mentioned is about base data base and text documents and therefore different although having the same topic. A quick search on the attribute name https://bugs.documentfoundation.org/buglist.cgi?quicksearch=use-optimal-row-height revealed a correct issue three months old: https://bugs.documentfoundation.org/show_bug.cgi?id=62268 I have added this test scenario and tried to clarify the problem of LibreOffice. Therefore it is not our bug. My suggested work around set explicit row height. Regards, Svante ᐧ 2017-08-14 13:29 GMT+02:00 Svante Schubert <[email protected]>: > Hello Wolfgang, > > I have forwarded your email to a friend from the LibreOffice team, but he > is on vacation these days. > Please be patient :) > > Greetings from Denmark (also on vacation) > Svante > ᐧ > > 2017-08-10 9:34 GMT+02:00 Wolfgang Pausch <[email protected]>: > >> Hello, >> >> I try to set up an odt spreadsheet document using odfdom. I have quite a >> lot of cells that contain more than one line of text. Thus, what I want is >> that I fill the cells with content, and then the necessary row height is >> determined automatically. >> >> According to chapter 20.384 of http://docs.oasis-open.org/off >> ice/v1.2/OpenDocument-v1.2-part1.pdf, there is an attribute >> >> style:use-optimal-row-height >> >> with the description >> >> true: row height should be recalculated automatically if content in the >>> row changes. >>> >> >> When I set this attribute to true on my row, generate the document, and >> open it in Libreoffice, the row height was *not* determined automatically. >> Once I make any manual input in that row, Libreoffice recalculates the row >> height, and everything is fine. >> >> Now, obviously Libreoffice honors the specification of that attribute - >> it recalculates the row heigth on changes. >> >> My question is, how can I make it recalculate the row height on document >> generation, such that the row height is already correct when the user opens >> the generated spreadsheet document for the first time? Is this possible at >> all? >> >> Is my problem somehow related to https://bugs.documentfoundatio >> n.org/show_bug.cgi?id=45789 ? >> >> Thanks for any ideas, >> >> Wolfgang >> >> >
