[Libreoffice-bugs] [Bug 62268] FILEOPEN: Optimum row height should be recalculated with " style:use-optimal-row-height='true'"

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=62268

--- Comment #19 from Tester <furun at arcor.de> ---
(I prepared this text for the bug report and found this here... so i post my
issue. i agree with Bernhard Dippold

Calc Version: 5.3.0.3 (Bug is still present)

Issue, libreoffice-Calc should update the automatic optimal height of rows, wen
the file is opened.
This is a issue which maybe shows up only by outside generated documents (Not
saved by libreoffice-Calc).

The Rows are set to be formated in optimal height, and because the generator
can not know this hight, the data is left out.
Calc should now update the Rows heights to there optimal. But after opening a
document, all rows are in the same standard hight.
The expected behavior is that Calc updates the height from this rows
automatically by the opening of the file, in case no height is set in the XML.
So that the user don't have to take any further action to correct the heights
manually.
I speculate, a simple trigger of a "Do-Automatic-Row-Height-Correction" in the
opening process fix the bug. dependent of the code, it is maybe only 1 code
line more.

Below are the XML codes generated form external generator, and tests.
See in "office:automatic-styles" the "style:use-optimal-row-height" option in
ro1 ro2
See in "office:automatic-styles" the "style:row-height" option in r03 r04
r03 r04 are the data generated from a external generator, form him it is
impossible to predict the height.

If a automatic update is not wanted, "style:use-optimal-row-height" simply must
be "false". It is set to "false" from Calc automatically, in case a user
changes the hight manually.
If it is "true", the correct behavior is to update it on file-load.


(I ca send a exampple.ods, but a expert should unterstand the issue
immediately.)

(In case you care about details, my ODS generator is a PHP code, which
generates documentation for medical informations. The users of the generator
should not do extra work to correct the row hight after opening the document.
And the generator can not know the hight Calc will create, so can not set it in
the generation process. The update must be done by loading the file. So pleas
no work arounds.)


content.xml:
...

        <office:automatic-styles>

                <style:style style:name="ta1" style:family="table"
style:master-page-name="Default">
                        <style:table-properties table:display="true"
style:writing-mode="lr-tb"/>
                </style:style>

                <style:style style:name="co1" style:family="table-column">
                        <style:table-column-properties fo:break-before="auto"
style:column-width="50mm"/>
                </style:style>

                <style:style style:name="ro1" style:family="table-row">
                        <style:table-row-properties style:row-height="4mm"
fo:break-before="auto" style:use-optimal-row-height="false"/>
                </style:style>

                <style:style style:name="ro2" style:family="table-row">
                        <style:table-row-properties style:row-height="4mm"
fo:break-before="auto" style:use-optimal-row-height="true"/>
                </style:style>

                <style:style style:name="ro3" style:family="table-row">
                        <style:table-row-properties style:row-height=""
fo:break-before="auto" style:use-optimal-row-height="true"/>
                </style:style>

                <style:style style:name="ro4" style:family="table-row">
                        <style:table-row-properties fo:break-before="auto"
style:use-optimal-row-height="true"/>
                </style:style>

        </office:automatic-styles>


        <office:body>
                <office:spreadsheet>
                        <table:calculation-settings
table:automatic-find-labels="false" table:use-regular-expressions="false"
table:use-wildcards="true"/>
                        <table:table table:name="Tabelle1"
table:style-name="ta1">
                                <table:table-column table:style-name="co1"
table:default-cell-style-name="Default"/>

                                <table:table-row table:style-name="ro1">
                                        <table:table-cell
office:value-type="string" calcext:value-type="string">
                                                <text:p>Fix Hight, No Automatic
Update, Hight Hight Hight Hight Hight Hight Hight Hight Hight Hight Hight Hight
Hight Hight</text:p>
                                        </table:table-cell>
                                </table:table-row>

                                <table:table-row table:style-name="ro2">
                                        <table:table-cell
office:value-type="string" calcext:value-type="string">
                                                <text:p>Automatic Known Hight,
but Wrong, Do Automatic Update?, Hight Hight Hight Hight Hight Hight Hight
Hight Hight Hight Hight Hight Hight Hight</text:p>
                                        </table:table-cell>
                                </table:table-row>

                                <table:table-row table:style-name="ro3">
                                        <table:table-cell
office:value-type="string" calcext:value-type="string">
                                                <text:p>Automatic Unknown
Hight, Do Automatic Update!, Hight Hight Hight Hight Hight Hight Hight Hight
Hight Hight Hight Hight Hight Hight</text:p>
                                        </table:table-cell>
                                </table:table-row>

                                <table:table-row table:style-name="ro4">
                                        <table:table-cell
office:value-type="string" calcext:value-type="string">
                                                <text:p>Automatic Unknown
Hight, Do Automatic Update!, Hight Hight Hight Hight Hight Hight Hight Hight
Hight Hight Hight Hight Hight</text:p>
                                        </table:table-cell>
                                </table:table-row>

                        </table:table>
                        <table:named-expressions/>
                </office:spreadsheet>
        </office:body>

...

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170421/708d9689/attachment-0001.html>