Issue 43985

Summary: Graphics inside header has wrong scale
Product: Calc Reporter: marcoesch <marc.oesch>
Component: formattingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3 CC: hl.ichaus, issues, rainerbielefeld_ooo_qa
Version: OOo 1.1.4   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Description Flags
openoffice spreadsheet
the original gif logo
New Test Kit none

Description marcoesch 2005-03-03 12:09:12 UTC
If you put an image (gif) inside the header, the image is scaled down to a very
small. It is not possible at all to scale the image. At least it should appear
as the original size.
The behaviour is weired!
I created the spreadsheet with version 1.1.3. In the beginning the image
appeared  with a correct size. Then I generated a pdf from it an the image
appeared very small.
Then in the spreadsheet's preview it also suddenly appeared small which was not
the case before.
I installed 1.1.4. opened the file, reimported the image but it now it remains
small in preview as well as in the pdf.
Comment 1 frank 2005-03-03 23:28:06 UTC

please attach a document showing the problem and describe step by step how to

Comment 2 marcoesch 2005-03-04 08:08:44 UTC
Created attachment 23323 [details]
openoffice spreadsheet
Comment 3 marcoesch 2005-03-04 08:09:40 UTC
Created attachment 23324 [details]
the original gif logo
Comment 4 marcoesch 2005-03-04 08:11:55 UTC
Hi Frank,

attached is a doc wich shows the problem. I've also attached the logo that I used.

In the attached doc goto "Page Preview" and you will see the very small logo.

Reproduce the problem.
I has been inserted using Format - Page - Header on - More - Background -
Graphics -Browse ....  (Using "Position" to place the image)
If I check or uncheck "AutoHeight" doesn't change anything. In page Preview you
can see the very small logo.

If you insert the logo in a normal cell via insert graphics, the size of it is ok.

(You might have to generate a pdf after all has benn inserted only then the
problem occurs !! - uncofirmed)

Comment 5 frank 2005-03-07 14:51:37 UTC

currently this works as intended. The picture is scaled to fit in a normal
Header based on some data from the resolution and the printer settings
(according to the development). The function you're using isn't intended for
Logos but for background graphics to fill the header instead of a solid color.

As this works as defined I've changed the Issuetype to enhancement and re-assign
it to the requirements team for evaluation.

Comment 6 frank 2006-06-02 11:10:08 UTC
*** Issue 65926 has been marked as a duplicate of this issue. ***
Comment 7 ace_dent 2008-05-06 17:43:53 UTC
It seems that Issue 43985 and Issue 69446 are closely related...
Comment 8 nikuehn 2008-07-01 13:12:11 UTC

given that the feature is meant as a "solid color replacement" it is formally an
enhancement. But I would rather call it a valid misuse case, we have the same
problem in our company with images in Headers:

- We have preprinted paper (header logo and footer logo) in our company, but we
also send out a lot of stuff via PDF. 
- We do not want to maintain different Document templates for each use case as
this is not known beforehand when initially creating the document. 
- We'd like to work with the "print background" property of the printing dialog
to allow using preprinted paper because there is no specialized other feature
for this use case.
- I.e. we would either need a specialized feature for printing / not printing
certain images or a background image behaviour that allows the misuse case.

A different issue plays into this question, too: the "print background" property
in the extended print dialogue does not affect the header and footer
backgrounds. May be by design, too although it does not make a whole lot of
sense to me. I couldn't find an issue # for this.

Side note: I have tested OOo3 beta and I was able to insert a PNG image scaled
as given in the image metadata. This works only with PNG images.

So much about my (more than) two cents, thanks for the good work on OOo anyways. 

#8664 seems to be somewhat related, too.

Comment 9 Rainer Bielefeld 2014-03-03 06:26:18 UTC
Created attachment 82774 [details]
New Test Kit

I created a new test kit (intentionally for Bug 69446) with 2 spreadhseets using very similar pictures, logo072dpx.png created with IrfanView from logo180dpx.png by modifying dpi value. logo180dpx.png is much smaller in poage header, logo072dpx.png is much bigger in page header than same picture in sheet contents.
Comment 10 Rainer Bielefeld 2014-03-03 06:31:57 UTC
I can't completely agree with Comment 5, and I think that New Test Kit falsifies the argumentation. The headers of both spreadhseets have the same dimension, and so a background-square due to Comment 5 should have the same dimension in header. But as you can see in test kit, reality is different to arguments in comment 5, size is very different comparing both spreadsheets.

this problem is even worse because many users have to "abuse" the background picture function to simulate a "picture in page heading" function, what is missing in AOO.
Comment 11 Rainer Bielefeld 2014-03-03 06:34:34 UTC
*** Issue 69446 has been marked as a duplicate of this issue. ***