When creating a new spreadsheet and exporting to pdf or printing it there’s also a header and footer exported with sheet and page number (“sheet1” and “page 2”) for example.
This header/footer is per default set as on. There's no way to know this until you print/export your fist spreadsheet, whereafter the search begins why these words are included.
This is not wysiwyg behaviour. It’s always a search for new people how to remove these (unwanted) words.
Can the default behaviour be changed to not include header and footer with page and sheet numbers? If people want something like this, the option should be to enable it, not to get this enabled from default. When creating a pdf, one is expecting an exact copy of the spreadsheet that’s been made.
Steps to Reproduce:
1. install LibreOffice
2. create a new spreadsheet
3. exort to pdf or print
There will automaticly a header and footer be exported as well, with the sheet and page number.
The actuel spreadsheet that is created is exported, without anything that hasn't been chosen by the user.
User Profile Reset: No
Created attachment 147402 [details]
comparison in excel, albeit in Dutch
I added a screenshot of how this works in Excel (which I have to use at work). Default header and footer is "none", there's an option to select page and sheet number, but only if wanted.
Thanks for filing, Roeland.
I would not support the idea if headers/footers are active.
There are some reports about that issue ..
> one for UX.. feel free to join (the) meeting(s)!
Disabling header/footer has been requested in bug 121759 and 99296 but got refused. I'll summarize at the other ticket.
*** This bug has been marked as a duplicate of bug 99296 ***