Download it now!
Bug 112853 - Calc doesn't support images in page header or footer
Summary: Calc doesn't support images in page header or footer
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 115456 132805 (view as bug list)
Depends on:
Blocks: XLSX Calc-Header-Footer
  Show dependency treegraph
 
Reported: 2017-10-03 06:59 UTC by Gabor Kelemen
Modified: 2020-11-24 06:32 UTC (History)
9 users (show)

See Also:
Crash report or crash signature:


Attachments
Example file made with Excel containing an image in the page footer (206.04 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2017-10-03 06:59 UTC, Gabor Kelemen
Details
Screenshot of the document in Excel 2013 print preview (172.99 KB, image/jpeg)
2017-10-03 06:59 UTC, Gabor Kelemen
Details
The document in Calc 5.4.2 on Ubuntu in print preview (124.82 KB, image/png)
2017-10-23 00:10 UTC, Gabor Kelemen
Details
Screenshot of the window (32.69 KB, image/png)
2017-10-23 00:19 UTC, Gabor Kelemen
Details
printscreen where add image (27.79 KB, image/png)
2017-10-23 13:08 UTC, raal
Details
Side by side of Writer and calc (186.85 KB, image/png)
2019-06-19 21:56 UTC, Matt
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Gabor Kelemen 2017-10-03 06:59:21 UTC
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.
Comment 1 Gabor Kelemen 2017-10-03 06:59:46 UTC
Created attachment 136722 [details]
Screenshot of the document in Excel 2013 print preview
Comment 2 Xisco Faulí 2017-10-03 08:06:50 UTC
I think this is similar to bug 109230...

*** This bug has been marked as a duplicate of bug 109230 ***
Comment 3 Gabor Kelemen 2017-10-03 08:39:23 UTC
Hi Xisco

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:
https://support.office.com/en-us/article/Headers-and-footers-in-a-worksheet-cae2a88c-64a7-42ab-96a4-28d2fc16ad31 

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.
Comment 4 Xavier Van Wijmeersch 2017-10-03 18:13:43 UTC
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.

Best regards
Comment 5 raal 2017-10-22 21:55:53 UTC
Closing, see comment 4
Comment 6 Gabor Kelemen 2017-10-22 23:58:34 UTC
(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.
Comment 7 Gabor Kelemen 2017-10-23 00:10:45 UTC
Created attachment 137219 [details]
The document in Calc 5.4.2 on Ubuntu in print preview
Comment 8 Gabor Kelemen 2017-10-23 00:19:44 UTC
Created attachment 137221 [details]
Screenshot of the window
Comment 9 raal 2017-10-23 13:08:26 UTC
Created attachment 137230 [details]
printscreen where add image
Comment 10 raal 2017-10-23 13:10:00 UTC
(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
> 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.

Hello Gabor,
see printscreen -  Format > Page > Header tab > button More > Background tab > Image
Comment 11 Gabor Kelemen 2017-10-30 14:12:35 UTC
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: 
https://support.office.com/en-us/article/Headers-and-footers-in-a-worksheet-cae2a88c-64a7-42ab-96a4-28d2fc16ad31
Comment 12 Fritz R. Paul 2017-11-03 10:07:25 UTC
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.
Comment 13 Xisco Faulí 2018-02-05 09:23:01 UTC
*** Bug 115456 has been marked as a duplicate of this bug. ***
Comment 14 Xisco Faulí 2018-03-15 10:12:39 UTC
Let's put this to NEW... In the end, it's an enhancement...
Comment 15 Jim Raykowski 2019-02-26 10:38:55 UTC
Hi All,

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?
Comment 16 Matt 2019-06-19 21:56:18 UTC
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
Comment 17 Matt 2019-06-19 21:57:37 UTC
Hello all!

As of today on Version 6.2.4.2 (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.
Comment 18 Gareth Lewis 2020-05-07 16:47:15 UTC
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.
Comment 19 Roman Kuznetsov 2020-08-16 20:01:33 UTC
*** Bug 132805 has been marked as a duplicate of this bug. ***