Image in a cell

Discuss the spreadsheet application
Post Reply
nirakarsethy
Posts: 1
Joined: Sun Jun 30, 2013 1:10 pm

Image in a cell

Post by nirakarsethy »

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
User avatar
acknak
Moderator
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Image in a cell

Post by acknak »

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
omurata
Posts: 5
Joined: Thu Sep 12, 2013 9:36 am

Image in a sheet

Post by omurata »

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
User avatar
Zizi64
Volunteer
Posts: 11359
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Image in a cell

Post by Zizi64 »

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

See these threads on another Forum:

http://www.oooforum.org/forum/viewtopic.phtml?t=132179
http://www.oooforum.org/forum/viewtopic.phtml?t=178847

and you can align pictures to the cells:
http://forum.openoffice.org/en/forum/vi ... =9&t=34544

Note:
...The images have not stored IN THE CELLS, but they are "stored" in a graphical layer of the sheet.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
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.
Post Reply