<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - FILESAVE: custom styles lost on saving to XLSX (Summary in Comment 6)" href="https://bugs.documentfoundation.org/show_bug.cgi?id=93045#c32">Comment # 32</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - FILESAVE: custom styles lost on saving to XLSX (Summary in Comment 6)" href="https://bugs.documentfoundation.org/show_bug.cgi?id=93045">bug 93045</a> from <a class="email" href="mailto:robert@bobslog.com" title="Rob <robert@bobslog.com>"> Rob</a> <pre>Possibly related I too had xlsx files that the alignments rendered correctly in Excel but wrong in LO if they originated from sources other than Excel. i.e. 1. create xlsx in Excel, alignment all OK in both Excel and LO 2. create xlsx in non excel source, alignment OK in Excel, alignment wrong in LO It turned out [in my case] the styles.xml had a difference, - those files created in Excel included: applyAlignment="true" in the elements within the cellXfs section of styles.xml - those files created outside Excel didn't include this item, (adding this fixed the problem*.) (* in my case the "outside Excel" source was from a package called EPPlus, I patched my own copy to include the: applyAlignment="1" where necessary.) Another way of looking at it: Excel: styles default for applyAlignment is True (or 1) [ if allignment items are present] LibreOffice: styles default for applyAlignment is False (or 0) unless explicitly set so either: (1) need to patch the originator of your xlsx files to include that applyAlignment="1"/"True" item in the styles.xml, or (2)patch LibreOffice to change it's default to True. - In my case #1 was much easier. - The LibreOffice maintainers would need to decide if #2 is an appropriate / permanent fix and is so apply it.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>