Bug Hunting Session
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)
Version:
(earliest affected)
Inherited From OOo
Hardware: x86 (IA32) All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Header-Footer
  Show dependency treegraph
 
Reported: 2012-11-16 17:18 UTC by Yuri
Modified: 2017-07-12 21:49 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


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

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!

=]