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.
Created attachment 70166 [details]
PDF version of the uploaded ODS file.
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.
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)
@yuri: mind if I mark this as 'enhancement' ?
(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!