[Libreoffice-bugs] [Bug 117229] FILESAVE XLSX Page header+footer margins overwritten with values in wrong units

[bugzilla-daemon at bugs.documentfoundation.org]

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

Regina Henschel <rb.henschel at t-online.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |rb.henschel at t-online.de

--- Comment #7 from Regina Henschel <rb.henschel at t-online.de> ---
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.

-- 
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/20200913/f03a72ce/attachment.htm>