[Libreoffice-bugs] [Bug 121637] New: change the default behavior of Calc to include a header and footer with page and sheet numbers

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=121637

Bug ID: 121637
Summary: change the default behavior of Calc to include a
header and footer with page and sheet numbers
Product: LibreOffice
Version: 6.1.1.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: libreoffice-***@lists.freedesktop.org
Reporter: ***@hotmail.com

Description:

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

Actual Results:
There will automaticly a header and footer be exported as well, with the sheet
and page number.

Expected Results:
The actuel spreadsheet that is created is exported, without anything that
hasn't been chosen by the user.


Reproducible: Always


User Profile Reset: No



Additional Info:

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=121637

--- Comment #1 from Roeland <***@hotmail.com> ---
Created attachment 147402
--> https://bugs.documentfoundation.org/attachment.cgi?id=147402&action=edit
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.

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=121637

Roeland <***@hotmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Blocks| |109087


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=109087
[Bug 109087] [META] Sheet header and footer bugs and enhancements