Image in a cell

Discuss the spreadsheet application

Image in a cell

Postby nirakarsethy » Sun Jun 30, 2013 1:20 pm

How to insert an image in one cell ? I tried from the available resources but didn't work out. I am using 3.4.1 on windows 7.

Thank You
Open Office 3.4.1, windows 7
Posts: 1
Joined: Sun Jun 30, 2013 1:10 pm

Re: Image in a cell

Postby acknak » Sun Jun 30, 2013 2:36 pm

Greetings and welcome to the community forum!

Sorry, Calc doesn't store images in cells--cells can only contain simple text or numeric values. Everything else is tacked on top of the cell grid. You can anchor an image to a particular cell and the image should stay in the same position, relative to that cell. In my experience, that linkage is not dependable.
AOO4/LO5 • Linux • Fedora 23
User avatar
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Image in a sheet

Postby omurata » Thu Sep 12, 2013 10:24 am

Hello, acknak

I feel difficult to insert an image into a cell.

Is it possible to insert an image into a sheet ?
If possible, please show me how to do it by UNO interface.

Best regards
Tadashi Ohmura
OpenOffice 3.4
Windows7 Pro 64bit
Posts: 5
Joined: Thu Sep 12, 2013 9:36 am

Re: Image in a cell

Postby Zizi64 » Thu Sep 12, 2013 11:46 am

You can import images into a Calc document by macro code.

See these threads on another Forum:

and you can align pictures to the cells:

...The images have not stored IN THE CELLS, but they are "stored" in a graphical layer of the sheet.
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Posts: 9725
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Return to Calc

Who is online

Users browsing this forum: No registered users and 26 guests