At 20:49 13/04/2008 +0400, Heriberto Reinoso Gallegos wrote:
The other day I was trying to replace completely one page I have in
Microsoft Excel with my linked drawings from AutoCAD for another one
in Openoffice (spreadsheet) and here is what happen:
When I try to link the first drawing I couldn't do it with the name
I provided, but the name came very long... You know, The drawings
are located inside a folder that is inside another one, inside
another one, in a different hard disk (external) the name came like:
Disk K/Woodgroup Drawings/final drawings/ etc. etc. and at the end
the real name of the file I was trying to link... In Excel I just
write the name of the file, I search for it and It linked it with
the given name. Is it possible to do so with Openoffice CALC??
You can do something very similar.
o Select the spreadsheet cell.
o Go to Insert | Hyperlink.
o Select Document in the left panel.
o Under Document in the right panel, press the folder icon ("Open
File") next to the Path window.
o Browse to the required file. (Note that, if you do it this way,
you don't need to type the path.)
o Select Apply. The full text now appears in the Text window under
"Further settings".
o Edit the contents of the Text window to show what you require in
the cell itself - perhaps by just deleting the parts you don't need.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]