Description: When an xlsx with header gets opened in LO the header is not shown. Steps to Reproduce: 1. Create a new xlsx in Excel. 2. Insert a header. 3. Save and open it in LO Actual Results: The header is missing. Expected Results: There should still be a header. Reproducible: Always User Profile Reset: No Additional Info:
Created attachment 147550 [details] The original spreadsheet.
Created attachment 147551 [details] Screenshot of the original document side by side in Excel and Calc.
Thank you for reporting the bug. I can confirm that the bug is present in Microsoft Excel 2007 Version: 6.3.0.0.alpha0+ Build ID: 3c964980da07892a02d5ac721d80558c459532d0 CPU threads: 2; OS: Windows 6.1; UI render: default; VCL: win; TinderBox: Win-x86@42, Branch:master, Time: 2018-12-12_02:07:45 Locale: en-US (en_US); UI-Language: en-US Calc: threaded
Do I understand well that this is not about "header missing", it's there on print preview, but it's about missing "page layout" view? Which is an enhancement then.
Hi, I have found this bug report as of having problems with header/footer at XLSX files not showing at LibreOffice 6.3.3.2 at print preview and after export as PDF, so for me is not just an issue of not having a 'page layout view'. I have created the file in LibreOffice, added a header with an image (preset or custom imported one), saved as XLSX. Close the file and open it again, the image won't appear (and in case the image is the only element in the header/footer -no text-, the header/footer won't appear altogether -including removing the margins defined for it). Same if file was created with Excel, or created/manipulated with a python or NodeJS library. It seems a compatibility issue with XLSX.
I can confirm @IagoSRL (even in 6.4.1) This is a **major bug**. All images in header/footer are not saved when in XLSX format (does work when saved in ODF format). In my opinion XLSX compatibility is key, so it should be fixed ASAP THE SEVERITY IS NOT ENHANCEMENT BUT MAJOR
This is a poorly worded report from us, sorry. The example file was switched to Page Layout View in Excel and this setting can be saved to XLSX. Opening in Calc there is no Page layout view at all (bug #109230) so the setting cannot be activated.