Ask Your Question
0

I'd like to insert a .png logo into the header of a spreadsheet.

asked 2016-09-09 14:35:49 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I'd like to insert a .png logo into the header of a spreadsheet. I'm using libreoffice 5.2 on a Linux platform.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2016-09-09 18:41:39 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Hi mark, Thanks for your response, If initially saved as .ods after inserting the image, can you subsequently save as .xls and keep the header intact, as most of the audience for this doc will be using Windows?

edit flag offensive delete link more

Comments

It doesn't seem possible to keep the image in the header when saved as xls or xlsx, also if you open the ods file with excell it removes the images. You can place an image in the ods sheet background and save as xls or xlsx, but the image is then tiled across the sheet in excel. The image shows in the excel worksheet view but does not seem to show in print preview so I don't think this helps.

mark_t gravatar imagemark_t ( 2016-09-09 20:54:41 +0200 )edit

You could export to pdf and distribute the pdf to other users but they would not have option to edit the data.

mark_t gravatar imagemark_t ( 2016-09-09 20:55:39 +0200 )edit
0

answered 2016-09-09 17:36:12 +0200

mark_t gravatar image

updated 2016-09-09 17:42:59 +0200

From the menu "Format", "Page..." then in the dialog select the Header tab.

Make sure Header is on.

Click on "More..." button.

In the drop down list next to "As:" select Image instead of color.

Use "Browse..." button to select the image file.

Select type and position for how you want the image to appear.

Note this only seems to work if saved as a .ods format and not if saved as .xls.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-09-09 14:35:49 +0200

Seen: 1,392 times

Last updated: Sep 09 '16