[Libreoffice-bugs] [Bug 117229] New: 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

            Bug ID: 117229
           Summary: FILESAVE XLSX Page header+footer margins overwritten
                    with values in wrong units
           Product: LibreOffice
           Version: 5.4.5.1 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Keywords: filter:xlsx
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: kelemeng at ubuntu.com

Created attachment 141625
  --> https://bugs.documentfoundation.org/attachment.cgi?id=141625&action=edit
Simple xlsx with default margins

Attached simple XLSX contains by default the following margin settings in
xl/worksheets/sheet1.xml:

<pageMargins left="0.7" right="0.7" top="0.75" bottom="0.75" header="0.3"
footer="0.3"/>

This results in 1,91 cm top/bottom margins, 1,78 cm left/right margins and 0,76
cm header/footer margins in Excel – so the above values are in inches.

Without any changes to header/footer settings, or enabling them in the Page
dialog, this is converted into:

<pageMargins left="0.7" right="0.7" top="0.75" bottom="0.75"
header="0.511805555555555" footer="0.511805555555555"/>

These header-footer values roughly match the default 0,5 cm default in the Page
window.

Opening this file in Excel causes the header-footer to become 1,3 cm - or ~0,51
inches.

The header and footer values should remain unchanged by a simple resave, and
custom values should be converted to inches before saving.

-- 
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/20180425/b75f3f6d/attachment.html>