Inserting dynamic image in Calc

Discuss the spreadsheet application

Inserting dynamic image in Calc

Postby fiddler » Mon Mar 09, 2009 9:36 am

I have a small application where I have 2 cells (X,Y) which contains the 2 sides for a rectangel.
I can insert a DXF file of this rectangel as an image via "Insert", "Picture", "From File" etc.

However I cannot update the image easily.
If I go to "Edit","Links" I can update the image manually.
I have tried to record a Macro, but it stops when the Links update dialog box appears.

Is there any easy way around this ?

What I would like to do eventually is to dynamicaly update the drawing image as I chnage the X or Y sides.
As the DXF file is just a text file this is quite easy done.

PS, I got qite excited when I discovered that you could view DXF drawing files in OO. Just marvelous.

Kim
There is no future in time travel
OOo 3.0.X on Ms Windows XP
fiddler
 
Posts: 3
Joined: Tue Dec 30, 2008 11:28 pm

Re: Inserting dynamic image in calc

Postby andyroberts1234 » Fri Mar 11, 2011 12:03 pm

Perhaps using the code for inserting an image http://codesnippets.services.openoffice.org/Calc/Calc.InsertImage.snip you may be able to add a few lines of code to make it change dynamically
Andy

OOO 3.3.0 / Windows 7 64-bit
andyroberts1234
 
Posts: 75
Joined: Fri Feb 11, 2011 2:29 pm


Return to Calc

Who is online

Users browsing this forum: Lupp, MSN [Bot] and 3 guests