Bug 122107 - FILEOPEN XLSX, Header is missing in LO - add "page layout" view
Summary: FILEOPEN XLSX, Header is missing in LO - add "page layout" view
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Keywords: filter:xlsx
Depends on:
Blocks: XLSX-Header-Footer
  Show dependency treegraph
Reported: 2018-12-14 13:00 UTC by NISZ LibreOffice Team
Modified: 2021-06-10 11:43 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

The original spreadsheet. (17.53 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2018-12-14 13:01 UTC, NISZ LibreOffice Team
Screenshot of the original document side by side in Excel and Calc. (319.49 KB, image/png)
2018-12-14 13:01 UTC, NISZ LibreOffice Team

Note You need to log in before you can comment on or make changes to this bug.
Description NISZ LibreOffice Team 2018-12-14 13:00:43 UTC
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:
Comment 1 NISZ LibreOffice Team 2018-12-14 13:01:22 UTC
Created attachment 147550 [details]
The original spreadsheet.
Comment 2 NISZ LibreOffice Team 2018-12-14 13:01:40 UTC
Created attachment 147551 [details]
Screenshot of the original document side by side in Excel and Calc.
Comment 3 Durgapriyanka 2018-12-14 19:16:43 UTC
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
Calc: threaded
Comment 4 Timur 2018-12-17 13:59:11 UTC
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.
Comment 5 IagoSRL 2019-12-19 16:55:43 UTC
Hi, I have found this bug report as of having problems with header/footer at XLSX files not showing at LibreOffice 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.
Comment 6 Christopher POTTER 2020-03-08 08:25:51 UTC
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

Comment 7 NISZ LibreOffice Team 2021-06-10 11:43:15 UTC
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.