https://bugs.documentfoundation.org/show_bug.cgi?id=62268
--- Comment #30 from adam_cadama...@hotmail.co.uk ---
This is still an issue in LibreOfficeCalc 6.0.
Like others, I generate ods files externally to LibreOfficeCalc with a custom
database export script. I generate the all the necessary xml files, the
mimetype and add png files. I carefully zip it all up to get a compliant ods
file.
As stated before, it is not possible during generation to know the row height
in order to set it in the xml. (Or rather it would require duplicating the
current LibreOfficeCalc auto row height calculation code based on content,
font, kerning, padding, size etc)
Opening the file in Excel, everything looks good.
Opening the file in LibreOfficeCalc6, all rows are at their default heights.
It is a problem, since users run the exporter themselves to create the ods, and
expect it to look correct when opening it. Getting them to run a macro is not a
solution.
It seems that the algorithm from Bernhard Donaubauer should be sufficient:
a) if there is no height attribute and the "use_optimal-row-height" attribute
is set then calculate the row height
b) if there is no height attribute and the "use_optimal-row-height" attribute
is not set then use the default value
c) if there is a height attribute just use it
If that is not possible, could a new custom xml attribute be introduced and
used to trigger row height recalculation on file open? Then we can just add
that to the xml. I don't care if it is stripped back out on save, since then
the height will be set anyway.
Regards,
Adam
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
