incubator-ooo-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Terry <terauck-aoous...@yahoo.com.au>
Subject Re: Question Replace Path in Calc
Date Thu, 03 Nov 2011 11:07:08 GMT
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 <ma.hed@bluewin.ch>
> To: ooo-users@incubator.apache.org
> 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<terauck-aoousers@yahoo.com.au>  
> 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<ma.hed@bluewin.ch>
>>>>  To: ooo-users@incubator.apache.org
>>>>  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: ooo-users-unsubscribe@incubator.apache.org
> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>

---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org


Mime
View raw message