I have replaced part of a formula (using search and replace) just now and it is still a working formula. If you wish, send me a copy of part of your file and I will run the function on it. Terry
----- Original Message ----- > From: Martin Hediger <[email protected]> > To: [email protected] > Cc: > Sent: Thursday, 3 November 2011 10:10 PM > Subject: Re: Question Replace Path in Calc > > No, I'm only searching for 'data' and replacing with > 'project/data' > Thanks a lot for the efforts. > Martin > > > Am 03.11.11 12:07, schrieb Terry: > >> 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] >> >> > > > --------------------------------------------------------------------- > 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]
