[Libreoffice-bugs] [Bug 125205] Spreadsheet cell padding is not saved/preserved

[bugzilla-daemon at bugs.documentfoundation.org]

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

V Stuart Foote <vstuart.foote at utsa.edu> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Keywords|                            |filter:xlsx
          Component|Calc                        |filters and storage
         Whiteboard| QA:needsComment            |
             Blocks|                            |108897
                 CC|                            |vstuart.foote at utsa.edu
           See Also|                            |https://bugs.documentfounda
                   |                            |tion.org/show_bug.cgi?id=67
                   |                            |774

--- Comment #2 from V Stuart Foote <vstuart.foote at utsa.edu> ---
ODF - OOXML - ODF Round trip filter issue.

Horizontal padding handled via fo:margin-left maybe needs to be handled with
different units on export to OOXML .xmls

1. Working in LibreOffice master/6.3.0alpha1+

A sample sheet with horizontal left spacing (indent) of 1 pt in ODF (as flat
.fods) gets a fo:margin-left value of 0.99, it will save and reopen from ODF.
But the attribute seems to get mishandled in filter export to OOXML.

>From LibreOffice master/6.3.0 a save-as export of file to OOXML (.xlsx) sets:
<alignment horizontal="general" vertical="bottom" textRotation="0"
wrapText="false" indent="0" shrinkToFit="false"/>

And when that OOXML is opened in LibreOffice (or Excel) the horizontal
alignment/indent shows "0". So issue with the export of the alignment
horizontal indent.


2.) Creating similar sheet in Excel 2016, a left horizontal alignment of 1 set,
showing noticeably wider indent that LO. 

Examine the file saved from Excel to OOXML, and also a copy saved to ODF.

These both open in LibreOffice master/6.3.0 showing a larger indent than the
indent of 1 (pt) in LO had shown.

Looking at the Excel 2016 generated XML, IIUC the style.xml for
the OOXML shows: <alignment horizontal="left" indent="1"/>;
the ODF shows: <style:paragraph-properties fo:text-align="start"
fo:margin-left="10.01pt"/>

Seems the GUI alignment units in Excel are not points but are chars! And the
indent of 1ch becomes 10pt in ODF.

Bit of an interoperability issue on these two facets.

Note: binary XLS format may be affected also -- I did not check. But seems like
this facet is on import is facet/dupe of bug 67774 (cmnt 10 there).


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=108897
[Bug 108897] [META] XLSX (OOXML) bug tracker
-- 
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/20190525/cf229905/attachment-0001.html>