<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:vstuart.foote@utsa.edu" title="V Stuart Foote <vstuart.foote@utsa.edu>"> <span class="fn">V Stuart Foote</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - Spreadsheet cell padding is not saved/preserved"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=125205">bug 125205</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Keywords</td>
<td>
</td>
<td>filter:xlsx
</td>
</tr>
<tr>
<td style="text-align:right;">Component</td>
<td>Calc
</td>
<td>filters and storage
</td>
</tr>
<tr>
<td style="text-align:right;">Whiteboard</td>
<td> QA:needsComment
</td>
<td>
</td>
</tr>
<tr>
<td style="text-align:right;">Blocks</td>
<td>
</td>
<td>108897
</td>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>vstuart.foote@utsa.edu
</td>
</tr>
<tr>
<td style="text-align:right;">See Also</td>
<td>
</td>
<td>https://bugs.documentfoundation.org/show_bug.cgi?id=67774
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Spreadsheet cell padding is not saved/preserved"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=125205#c2">Comment # 2</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Spreadsheet cell padding is not saved/preserved"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=125205">bug 125205</a>
from <span class="vcard"><a class="email" href="mailto:vstuart.foote@utsa.edu" title="V Stuart Foote <vstuart.foote@utsa.edu>"> <span class="fn">V Stuart Foote</span></a>
</span></b>
<pre>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 <a class="bz_bug_link
bz_status_NEW "
title="NEW - FILEOPEN: XLS/XLSX: Alignment shift is incorrect - should use font's space size"
href="show_bug.cgi?id=67774">bug 67774</a> (cmnt 10 there).</pre>
</div>
</p>
<div id="referenced">
<hr style="border: 1px dashed #969696">
<b>Referenced Bugs:</b>
<ul>
<li>
[<a class="bz_bug_link
bz_status_NEW "
title="NEW - [META] XLSX (OOXML) bug tracker"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=108897">Bug 108897</a>] [META] XLSX (OOXML) bug tracker
</li>
</ul>
</div>
<br>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>