Created attachment 136721 [details]
Example file made with Excel containing an image in the page footer
LibreOffice Calc, unlike Microsoft Excel, does not support images in page header or footer. This makes it tedious to create spreadsheets where the same logo appears on every page in print, which might be mandatory in some professional use cases.
Created attachment 136722 [details]
Screenshot of the document in Excel 2013 print preview
I think this is similar to bug 109230...
*** This bug has been marked as a duplicate of bug 109230 ***
I don't think this fits into bug #109230 which is about a new view of the header and footer.
See the 'Add or change headers or footers in the Page Setup dialog' section:
In Excels Page Setup window -> Header/Footer tab and Custom Header or Custom Footer window you can add a picture to the page header/footer.
In Calc, you can set custom page header/footer under Insert -> Headers and Footers with many similar options to Excel, but there is no way to set a picture.
It does well support images in header/footer
In header/footer go to the more button, its opens a border/background choice, go to background tab and there you can select color or image. You then browse for a image; link it or not and have a preview of it.
Closing, see comment 4
(In reply to raal from comment #5)
> Closing, see comment 4
Excuse me, but could you or Xavier prove the claims in comment 4 with a screenshot?
I was unable to find an Insert image button in Calc -> Insert -> Headers / Footers , there is a Custom header section with options for: Text formatting, Title / File name / Path/File Name , Sheet name , Page numbering, Number of pages, Date , Time.
But no option for inserting an image.
Created attachment 137219 [details]
The document in Calc 5.4.2 on Ubuntu in print preview
Created attachment 137221 [details]
Screenshot of the window
Created attachment 137230 [details]
printscreen where add image
(In reply to Gabor Kelemen from comment #6)
> (In reply to raal from comment #5)
> > Closing, see comment 4
> Excuse me, but could you or Xavier prove the claims in comment 4 with a
> I was unable to find an Insert image button in Calc -> Insert -> Headers /
> Footers , there is a Custom header section with options for: Text
> formatting, Title / File name / Path/File Name , Sheet name , Page
> numbering, Number of pages, Date , Time.
> But no option for inserting an image.
see printscreen - Format > Page > Header tab > button More > Background tab > Image
Okay, so that's a different feature. Let me explain:
- In the window on attachment #137221 [details] the content of the header/footer is editable. Back on the Header / Footer tab you can set the properties of this content, like margin, spacing, height and AutoFit height.
- In the window in attachment #137230 [details] you can set the background of the Header/Footer content, which you set up in the Headers/Footers dialog.
The size of the background depends on the Header/Footer content size. If the content height is small, the background image will be small as well.
It is also not possible to set a custom size for this background image, like in Excel (which is also used in the bugdoc).
Also the OOXML interoperability suffers quite a bit here as the image set in the bugdoc as footer image gets lost on RT - but that is a topic for another bug.
For more information about this feature in Excel see:
Using the background image is a kluge with many restrictions. Using calc for professional looking documents would be much simpler having the option to use pictures similar to the way it works in writer.
*** Bug 115456 has been marked as a duplicate of this bug. ***
Let's put this to NEW... In the end, it's an enhancement...
In the current master build the Calc Border / Background dialog uses the new background tab page based on the area tab page. Does it resolve this bug?
Created attachment 152298 [details]
Side by side of Writer and calc
Calc currently lacks an effective method to insert, position, and resize an image in the header without using an external program to edit it
As of today on Version 126.96.36.199 (x64) I don't see the option, and the set as background options for Calc aren't as good as for Writer as shown in attachment 152298 [details].
There is a clunky albeit workable way to manage image inserting in the header in Writer by doing a specific position background and manually tweaking the size in inches of the image but that requires knowing the exact aspect ratio and doing the math of it or accepting a potentially squished image. Even this method is not available in Calc at this time. Neither have a simple and straightforward "Insert picture" option within the header.
Ideal options in my case being the ability to insert an image bound to the header and scale it to fit the header size while maintaining the aspect ratio.
Current option in Writer is to insert the logo as an area background bitmap and manually scale it in order to maintain the aspect ratio or auto scale it and let it get stretched to fill the whole area (which generally looks terrible). This is clunky but effective eventually.
Current option in Calc is to open Draw and manually edit and rescale the image itself until it fits the header size you want and then insert it as a positional background image, then tweak the header size and spacing until both the image and text you are looking for fit. I only state this here as it is a possible solution for people who need it urgently, but it's an untenable process that requires far too much time to do something so simple.
Current option in Excel is open page properties > Header > click insert picture. This is far better than the two above. If you wish, you can even insert an additional image, currently not possible in either Calc or Writer to my knowledge.
I created an account to post this.
Nearly EVERY spreadsheet I have worked with over the last ten years has had some kind of image in the header (usually a logo). Without this feature in Calc I cannot use it professionally despite really wanting to. Please make it a greater priority; I am sure I cannot be the only user who needs this.