incubator-ooo-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Martin Hediger <ma....@bluewin.ch>
Subject Re: Question Replace Path in Calc
Date Thu, 03 Nov 2011 11:10:18 GMT
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


Mime
View raw message