Bug 57202 - FORMATTING: Make Header/footer font size independent from scaling of the sheets
Summary: FORMATTING: Make Header/footer font size independent from scaling of the sheets
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: x86 (IA32) All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Calc-Header-Footer
  Show dependency treegraph
Reported: 2012-11-16 17:18 UTC by Yuri
Modified: 2020-07-01 04:01 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:

ODS file containing exemplification of this bug. (16.36 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-11-16 17:18 UTC, Yuri
PDF version of the uploaded ODS file. (23.00 KB, application/pdf)
2012-11-16 17:24 UTC, Yuri

Note You need to log in before you can comment on or make changes to this bug.
Description Yuri 2012-11-16 17:18:18 UTC
Created attachment 70165 [details]
ODS file containing exemplification of this bug.

In Calc, I created a single ODS file containing several spreadsheets (thus several sheet tabs: Sheet1, Sheet2, Sheet3...). Every sheet was filled with a data table with a dozen of columns and some tens of lines, each. Those tables have different widths.

I then clicked Format => Page => Sheet => Scaling mode => Fit print range(s) to width/height, and configured it to 1/100: 1 page in width, 100 pages in height. So all the tables will be resized to fit 1 page, in terms of width.

I also clicked Format => Page => Header/Footer => Edit => Custom header/footer => Text Attributes => Font, and then configured the font size to 16, for both headers and footers, thus I expect all headers and footers to have the same font sizes, despite of the different tables/sheets they belong to.

However, because of the different sizes of the tables (different printing areas), each table was resized to fit the width of 1 page. It's ok, this is exactly what I need. The problem is: on the headers and footers, the font size is being changed aswell! So the most shrinked tables/sheets have headers and footers with smaller font sizes (sizes below 16), and the less shrinked tables/sheets have headers and footers with bigger font sizes.

This is a problem, since I expected all headers and footers to have the _same_ font size: the tables must be resized to fit the preset width (fit to 1 page), but headers and footers must not.

I consider this a bug, since I set the font size to 16 but it's being resized.
Comment 1 Yuri 2012-11-16 17:24:50 UTC
Created attachment 70166 [details]
PDF version of the uploaded ODS file.
Comment 2 Rainer Bielefeld Retired 2012-11-27 06:02:16 UTC
I agree, this menu 'Format -> Page -> Sheet -> Scale - Scaling mode = "Fit print range(s) to iwdth/height" should only "zoom" cells content, but not header and footer. 

This is nothing new, I also see this effect in more early versions, even back to OOo 1.1.5.

I also think it's a bug, and it's an accepted very old AOOo issue.

@Spreadsheet Team:
Please set Status to ASSIGNED and add yourself to "Assigned To" if you accept this Bug or forward the Bug if it's not your turf (and remove others in team from CC)
Comment 3 Cor Nouws 2013-05-17 21:38:54 UTC
@yuri: mind if I mark this as 'enhancement' ?
Comment 4 Yuri 2013-05-17 23:35:52 UTC
(In reply to comment #3)
> @yuri: mind if I mark this as 'enhancement' ?

If doing it raises the possibility of this "issue" to be solved, then yes, please!

Comment 5 pb 2020-06-25 23:45:01 UTC
It would appear that changing it to "enhancement" did not make it any more likely to happen sooner.  This bug is 8 years old, and I just discovered it, to my annoyance.

I am going to change it back to "bug," and see who gets mad at me.
Comment 6 joesch04 2020-06-30 07:21:08 UTC
I am not sure if this is a bug (or a feature), but a solution would be good.

For example, I have a file where the print size needs to be scaled down to about 35% and the headers and footers are currently scaled down accordingly.
It would be helpful to fix the size of the header and footer at 100%.
Comment 7 Yuri 2020-07-01 04:01:42 UTC
To me it's pretty clear and obvious that it's a bug. I agreed that this bug report was marked as a desired feature instead of a bug report so developers could have more time to dedicate to fixing other (more critical) bugs and take the time to fix this. But 8 years is too long. I'm very impressed by such delay.

Here's the most obvious reason why this is a bug: a spreadsheet contains information, but its headers and footers contain METAINFORMATION (i.e. information about the spreadsheet's information). E.g. the page numbers placed in the headers or footers pretty much inform us how many pages (i.e. how much space) the spreadsheet's information takes up.

Another clear reason why resizing a spreadsheet shouldn't resize its headers and footers along is because international standardization organizations like ISO specify fixed font types and sizes for headers and footers in different document types (e.g. dissertations and other technical and academic documents).

Therefore, by default LibreOffice should NOT resize headers and footers: the actual "desired feature" or "enhancement" is precisely providing the end-user the ability to change such default behavior, in order to cause LibreOffice to resize headers' and footers' font sizes along with their corresponding pages. But for some weird reason LibreOffice by default behaves in such non-standard, undesired way.