Hello Svante,
thank you very much for your efforts. Now I at least know the source of
the problem.
Luckily, at least at the moment we don't really have to distribute the
affected documents. (the hint with the explicit row height is well
known to us, but unfortunately it would not be easily usable if the cell
contents are variable-length based on database content).
Thank you,
Wolfgang
Am 2017-08-17 um 12:46 schrieb Svante Schubert:
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
