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
The header is missing.
There should still be a header.
User Profile Reset: No
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
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
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 18.104.22.168 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