Bug 57202

Summary: Make Header/footer font size independent from scaling of the sheets
Product: LibreOffice Reporter: Yuri <yuri_sucupira>
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: enhancement    
Priority: medium CC: cno, erack, LibreOffice, libreoffice, markus.mohrhard
Version: Inherited From OOo   
Hardware: x86 (IA32)   
OS: All   
See Also: https://issues.apache.org/ooo/show_bug.cgi?id=4698
Whiteboard:
i915 platform: i915 features:
Attachments: ODS file containing exemplification of this bug.
PDF version of the uploaded ODS file.

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!

=]

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.