Are you searching for '/Users/me/data/' and replacing it with ' /Users/me/project/data/'?
I will try the process in a test file. Terry ----- Original Message ----- > From: Martin Hediger <[email protected]> > To: [email protected] > Cc: > Sent: Thursday, 3 November 2011 9:52 PM > Subject: Re: Question Replace Path in Calc > > Hallo > I was using the search & replace dialog and set "search in > Formulae". > However, when I replace a "link", it becomes a string, and so no > longer > clickable. Then my file does not open. How can I keep it a link to a file? > > Thanks for any hints. > > > > > Am 02.11.11 13:39, schrieb Rob Weir: >> On Wed, Nov 2, 2011 at 5:59 AM, Terry<[email protected]> > wrote: >>> Use the Find and Replace tool. If you do not have a toolbar icon, it > is in the menu 'Edit' (Ctrl + F). >>> >>> When the dialogue opens, press the button on the bottom left labelled > "More Options." Make sure it says to search in 'Formulae' (an > anachronism meaning formulas). Enter the wording you want to replace under > "Search for" and enter the new wording under "Replace with." >>> >> That's a good solution. Another approach is to use Calc's text >> functions to calculate the new path. This can work for more >> complicated examples. >> >> > http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_Text_functions >> >> LEFT(), RIGHT(), REPLACE(), FIND(), SEARCH(), CONCATENATE() are useful for > this. >> >> -rob >> >>> Regards. >>> >>> ----- Original Message ----- >>>> From: Martin Hediger<[email protected]> >>>> To: [email protected] >>>> Cc: >>>> Sent: Wednesday, 2 November 2011 7:58 PM >>>> Subject: Question Replace Path in Calc >>>> >>>> Dear List >>>> I maintain a little database about some results from published > experiments in a >>>> calc spreadsheet. To be able to conveniently view the publication > reporting a >>>> specific experimental value, I included links to PDFs on my local > machine, such >>>> that I can just hit the link and open the PDF if I need to recall > some details >>>> about an experimental value. Something like this: >>>> >>>> Energy Name PDF >>>> 3.141 C3PO /Users/me/data/c3po.pdf >>>> 2.718 R2D2 /Users/me/data/r2d2.pdf >>>> [...] >>>> >>>> >>>> >>>> Now, I had to adjust the directory structure, and so the links are > not exactly >>>> correct anymore. The path would now be /Users/me/project/data/*pdf. >>>> How can I adjust the links to this new path? I tried > "Spelling, F7", >>>> but it only gives suggestions for the Names, not the links. >>>> >>>> Any suggestions are appreciated. >>>> >>>> Martin > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
