Bug 99296 - Calc: Disable headers/footers by default
Summary: Calc: Disable headers/footers by default
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 120876 121637 122492 (view as bug list)
Depends on:
Blocks: Calc-Header-Footer
  Show dependency treegraph
 
Reported: 2016-04-14 13:44 UTC by Samuel Mehrbrodt (CIB)
Modified: 2019-01-17 11:44 UTC (History)
14 users (show)

See Also:
Crash report or crash signature:


Attachments
Default calc document printed (7.34 KB, image/png)
2016-04-14 13:49 UTC, Samuel Mehrbrodt (CIB)
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Samuel Mehrbrodt (CIB) 2016-04-14 13:44:49 UTC
Currently Calc has the table name in the header and the page name in the footer by default (see attachment).

This looks kind of weird if you do not change the table name ("Table1" by default) and have only one page to print.

I suggest to remove this default and have blank headers&footers by default.
Comment 1 Samuel Mehrbrodt (CIB) 2016-04-14 13:49:41 UTC
Created attachment 124341 [details]
Default calc document printed
Comment 2 sophie 2016-04-14 14:49:54 UTC
+1 set as New - Sophie
Comment 3 Katarina Behrens (CIB) 2016-04-14 14:50:20 UTC
<jphilipz> bubli_, mahfiaz, sophi: samuel_m thinks we should have blank header and footer by default in calc #99296
<bubli_> jphilipz: Yes he said so already :))
<bubli_> and I told him it makes kinda sense
<bubli_> It's slightly unexpected when one prints a sheet and has a header and footer there
<bubli_> without actively doing anything to set those
<jphilipz> bubli_, sophi: please comment in the bug report with your approval :D

+1 then
Comment 4 Cor Nouws 2016-04-14 19:27:40 UTC
(In reply to Samuel Mehrbrodt (CIB) from comment #0)
> Currently Calc has the table name in the header and the page name in the
> footer by default (see attachment).

Page number in the footer.

> This looks kind of weird if you do not change the table name ("Table1" by
> default) and have only one page to print.
> 
> I suggest to remove this default and have blank headers&footers by default.

Could that be suppressed for the case with one page?
For more pages, it's not that weird and helps people.
Comment 5 Samuel Mehrbrodt (CIB) 2016-04-15 08:36:11 UTC
(In reply to Cor Nouws from comment #4)
> Could that be suppressed for the case with one page?
> For more pages, it's not that weird and helps people.

Calc doesn't support different header/footer for the first page, implementing that is out of scope here.
Comment 6 Samuel Mehrbrodt (CIB) 2016-04-15 08:37:20 UTC
One problem with just removing the default content:

The header/footer is still there (taking space when printing), it just has no content. So we should also disable the header/footer in the page style.

The question is, should we then leave the default content in and just disable them by default, or disable and remove default content?
Comment 7 Yousuf Philips (jay) (retired) 2016-04-15 16:32:36 UTC
So i checked Excel 2003, Quattro Pro x7, Calligra Words, and WPS Spreadsheet and none of them had anything in the header and footer by default. The only app that did have something was Gnumeric, which had the sheet name in the header and the page number in the footer similar to LibreOffice.

As we dont have anything by default in the header and footer in new documents from Writer or Impress, it would be consistent to do the same in new Calc documents.

(In reply to Samuel Mehrbrodt (CIB) from comment #6)
> The question is, should we then leave the default content in and just
> disable them by default, or disable and remove default content?

Well i was going to suggest that you disable them in the page style and leave the presets in, but the problem is that when they are disable, Insert > Header and Footer is them disabled and a user would have to know to go into the page style dialog in order to enable them. If it is possible to always have 'Header and Footer' enabled and the dialog has the ability to enable and disable header and footer as well as modify them, that would likely be the best option.
Comment 8 Heiko Tietze 2016-04-29 12:26:15 UTC
Design team decided to disable header/footer by default.
Comment 9 Roman Kuznetsov 2018-06-11 11:34:34 UTC
(In reply to Heiko Tietze from comment #8)
> Design team decided to disable header/footer by default.

+100500

is it hard to make?
Comment 10 Commit Notification 2018-09-03 07:06:47 UTC
heiko tietze committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=08b5048198d59441cb8033ed14cd17e68c943004

tdf#99296 - Disable headers/footers by default

It will be available in 6.2.0.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 11 Cor Nouws 2018-09-04 21:11:38 UTC
(In reply to Samuel Mehrbrodt (CIB) from comment #5)
> (In reply to Cor Nouws from comment #4)
> > Could that be suppressed for the case with one page?
> > For more pages, it's not that weird and helps people.
> 
> Calc doesn't support different header/footer for the first page,
> implementing that is out of scope here.

True - but if different sheets (with print ranges..) have a different page style, it is within reach.
Comment 12 BogdanB 2018-09-15 11:34:53 UTC
I checked on Linux 6.2: this bug is solved.

Version: 6.2.0.0.alpha0+
Build ID: 9a9b81c7212fa6a6762246593acf3f1950677a22
CPU threads: 4; OS: Linux 4.15; UI render: GL; VCL: gtk2; 
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2018-09-08_00:00:43
Locale: ro-RO (ro_RO.UTF-8); Calc: threaded
Comment 13 Xisco Faulí 2018-10-24 15:33:13 UTC
*** Bug 120876 has been marked as a duplicate of this bug. ***
Comment 14 Heiko Tietze 2018-12-06 16:13:25 UTC
Patch reverted.
Comment 15 Commit Notification 2018-12-07 07:41:47 UTC
Heiko Tietze committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/+/d08e63fb1ab16d96e3d1404c4b82267447104a0f%5E%21

tdf#121759 Revert "tdf#99296 - Disable headers/footers by default"

It will be available in 6.3.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 16 Commit Notification 2018-12-07 19:30:24 UTC
Heiko Tietze committed a patch related to this issue.
It has been pushed to "libreoffice-6-2":

https://git.libreoffice.org/core/+/1d3a07415eda3014d67d7c56466a8ad1d0ec51d9%5E%21

tdf#121759 Revert "tdf#99296 - Disable headers/footers by default"

It will be available in 6.2.0.1.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 17 Xisco Faulí 2018-12-10 16:47:44 UTC
(In reply to Heiko Tietze from comment #14)
> Patch reverted.

Hi Heiko,
Out of curiosity, why this patch got reverted ?
Comment 18 Roman Kuznetsov 2018-12-10 18:17:07 UTC
(In reply to Xisco Faulí from comment #17)
> (In reply to Heiko Tietze from comment #14)
> > Patch reverted.
> 
> Hi Heiko,
> Out of curiosity, why this patch got reverted ?

See bug 121759
Comment 19 Heiko Tietze 2019-01-02 11:31:23 UTC
*** Bug 121637 has been marked as a duplicate of this bug. ***
Comment 20 Heiko Tietze 2019-01-02 11:39:09 UTC
Since it was requested again in bug 121637 here is where we are:
Patch https://gerrit.libreoffice.org/#/c/59696/ disables the header/footer by default but then we run into trouble with the menu item Insert > Header and Footer... for editing. Patch https://gerrit.libreoffice.org/#/c/64712/ disables this menu item until Header/Footer are checked at Format > Page > Header/Footer (and moves the menu entry to Edit for clarification). But this solution was not accepted as an improvement since users do not know how to enable it. See http://document-foundation-mail-archive.969070.n3.nabble.com/Re-Minutes-from-the-UX-design-meeting-2018-Dec-06-tc4254107.html#a4254112 for the discussion. So eventually both patches got reverted.
Comment 21 Xisco Faulí 2019-01-17 11:44:40 UTC
*** Bug 122492 has been marked as a duplicate of this bug. ***