Bug 74146 - FORMATTING: Calc Header / Footer - Inserted image cannot be resized nor cropped
Summary: FORMATTING: Calc Header / Footer - Inserted image cannot be resized nor cropped
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
Whiteboard: BSA
: 80606 96262 (view as bug list)
Depends on:
Blocks: Calc-Images Calc-Header-Footer
  Show dependency treegraph
Reported: 2014-01-28 09:47 UTC by pharmankur
Modified: 2021-10-28 03:30 UTC (History)
8 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description pharmankur 2014-01-28 09:47:26 UTC
There is no option to add image in header or footer in calc.

There is an option to add image as background even-though, but its very rigid & complicated and is virtually useless, as there is no option of resizing the image.

It is particularly important feature if we want to use Calc in corporates. As many company's would like to add their logo / image along with data sheets they make using Calc.

There should an option to add graphics easily as header / footer. Also there should be option to resize / crop the graphic accordingly.
Operating System: All
Version: release
Comment 1 sophie 2014-01-28 10:12:17 UTC
Set to enhancement and new - Sophie
Comment 2 raal 2015-01-12 21:01:24 UTC
*** Bug 80606 has been marked as a duplicate of this bug. ***
Comment 3 m_a_riosv 2015-12-05 18:16:25 UTC
*** Bug 96262 has been marked as a duplicate of this bug. ***
Comment 4 Jean-Baptiste Faure 2016-01-10 17:06:47 UTC Comment hidden (obsolete)
Comment 5 Jean-Baptiste Faure 2016-01-10 17:11:23 UTC
Inserting an image in the header / footer in Calc is allowed at least since LO 5.0. The possibility to resize and crop the image is still not available.
Summary updated accordingly.

Best regards. JBF
Comment 6 Gerry 2017-06-06 14:30:42 UTC
Images in spreadsheet headers/footers are IMHO frequently used. The current handling in Calc is almost unusable for an end user, because it is:
(1) hidden in "Format" -> "Page" -> "Header" -> "More" -> "Background". This is extremely unintuitive
(2) Cropping and resizing, as well as proper scaling is currently not possible, which means that the user has to use image editing to properly add a logo to a spreadsheet header/footer.
Comment 7 Tom Williams 2021-10-28 03:30:24 UTC
I actually put a company logo in a Calc header and ended up scrapping it because the image was lost when the spreadsheet was exported to Microsoft formats (XLS and XLSX).  Still, I think being able to add images to headers and footers, in Calc, would be awesome!