OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

How show images anchor at other sheet

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
mothorchid
Newbie
Newbie


Joined: 06 Dec 2008
Posts: 1

PostPosted: Sat Dec 06, 2008 11:17 pm    Post subject: How show images anchor at other sheet Reply with quote

i'm newbie to calc.
i think my question is already solved in this forum,
but i can't find the thread so long time.
I used keyword "picture, cell, stick, image, find, etc"
These words are so common term. i cant find what i need.
So maybe my quetions is some kind of FAQ, forgive and help me please.

My Goal is manage employees. and I want to recognize by their faces in odt file.
At sheet 3 I saved their face pictures, cell by cell. Each pictures anchored each cells. Pictures may have unique names.
At Sheet 2 I saved their informations.
At sheet 1, I want to search and see the results.
For example, If I input A1 cell employee's name, then Sheet1 shows his informations and face picture.

How can I show pictures? which function can I use?
call them by "picture name"? or "cell position"?

Or pictures can be saved in jpeg files in a directory, not in sheet3.
picture's name equals employee's or has serial number which is arranged.. etc..
this way is also OK to me.

I mean to show the picture as image to see instantly,
not hyperlink to click and show them through other applications.

help me please~

P.S. to do this with MSoffice, check example in this site.

http://www.xlstudy.com/excel_study_main.htm

go to "mk016" and download XLS file.
(This file is not english (korean) but simple to understand, and contains Macro.
It doesnt work well with OOo Calc, so you may open this file with MSoffice.)
I try to this with Calc, but impossible.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group