<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:rb.henschel@t-online.de" title="Regina Henschel <rb.henschel@t-online.de>"> <span class="fn">Regina Henschel</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - FILESAVE XLSX Page header+footer margins overwritten with values in wrong units"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=117229">bug 117229</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;">CC</td>
<td>
</td>
<td>rb.henschel@t-online.de
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - FILESAVE XLSX Page header+footer margins overwritten with values in wrong units"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=117229#c7">Comment # 7</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - FILESAVE XLSX Page header+footer margins overwritten with values in wrong units"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=117229">bug 117229</a>
from <span class="vcard"><a class="email" href="mailto:rb.henschel@t-online.de" title="Regina Henschel <rb.henschel@t-online.de>"> <span class="fn">Regina Henschel</span></a>
</span></b>
<pre>I don't think, that it is a problem with units. The values are correct in case
header/footer have content. In that case it is:
LO top margin + LO header height + LO header spacing = Excel top margin
and
Excel header position = LO top margin
For example, an Excel setting with top margin 20mm and header position 6mm is
divided in LO into top margin 6mm + header height 3,88mm + header spacing
10,12mm.
Because in LO the header is not inside the margin, but belongs to the body
area, the Excel header position 6mm becomes the top margin in LO. And to get
the total of Excel margin a suitable spacing is used.
These rules are not used, if header/footer are empty.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>