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

            Bug ID: 92865
           Summary: Row Height "use-optimal-row-height" differences in OO
                    and LIBO
           Product: LibreOffice
           Version: Inherited From OOo
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: critical
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs@lists.freedesktop.org
          Reporter: suga...@gmail.com

Created attachment 117374
  --> https://bugs.documentfoundation.org/attachment.cgi?id=117374&action=edit
XLS Files row Height difference

Attached XLS file shows almost collapsed rows in all LIBO versions, as the row
height set to those rows are very small. But all the rows are visible in Excel
and OpenOffice. I digged in further and saved the xls file as ods, both through
LibreOffice and OpenOffice and analyzed the difference in the xml.

LIBREOFFICE Behaviour:- 
The row height in 'ro2' is very small and also use-optimal-row-height is set as
false. Hence LibreOffice UI displays the rows with the same small height(which
almost looks like collapsed rows.).
<style:style style:name="ro1" style:family="table-row">
<style:table-row-properties style:row-height="14.66pt" 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="0.74pt" fo:break-beforeauto=""
style:use-optimal-row-height="false"/>
</style:style>
<style:style style:name="ro3" style:family="table-row">
<style:table-row-properties style:row-height="12.81pt" fo:break-beforeauto=""
style:use-optimal-row-height="false"/>
</style:style>

OpenOffice Behaviour:- 

Though the row height of 'ro2' is very small in this case also,
use-optimal-row-height is set as true. Hence, when the file is opened in any UI
the row heights get recalculated according to the content and all the rows are
visible just like the original xls file.

<style:style style:name="ro1" style:family="table-row">
<style:table-row-properties style:row-height="0.1665in" fo:break-beforeauto=""
style:use-optimal-row-height="true"/>
</style:style>
<style:style style:name="ro2" style:family="table-row">
<style:table-row-properties style:row-height="0.0102in" fo:break-beforeauto=""
style:use-optimal-row-height="true"/>
</style:style>
<style:style style:name="ro3" style:family="table-row">
<style:table-row-properties style:row-height="0.178in" fo:break-beforeauto=""
style:use-optimal-row-height="true"/>
</style:style>

File attached, was created in EXCEL.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to