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 22:03:59 GMT
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 <ma.hed@bluewin.ch>
> To: ooo-users@incubator.apache.org
> 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<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
>> 
>> 
> 
> 
> ---------------------------------------------------------------------
> 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