Mailing-List: contact ooo-users-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ooo-users@incubator.apache.org
Received-SPF: pass (athena.apache.org: local policy)
Message-ID: <4EB147C5.5070302@bluewin.ch>
Date: Wed, 02 Nov 2011 14:38:13 +0100
From: Martin Hediger <ma.hed@bluewin.ch>
User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; de;
 rv:1.9.2.23) Gecko/20110920 Thunderbird/3.1.15
MIME-Version: 1.0
To: ooo-users@incubator.apache.org
Subject: Re: Question Replace Path in Calc
References: <4EAAADB7.8070506@bluewin.ch>
	<CAP-ksoj3812-5eUony787fsSzQzr+ust=VhCrnAQenRjktmCVA@mail.gmail.com>
	<4EAAC623.6020409@bluewin.ch>	<201110291024.52914.linux_mike@clear.net.nz>
	<4EB1061E.4000802@bluewin.ch>
	<1320227974.94268.YahooMailNeo@web161702.mail.bf1.yahoo.com>
 <CAP-ksoji_94rtKXx=2LA4o9scm+LMt1dmqYPxq=hVbWc=nbF5A@mail.gmail.com>
In-Reply-To: 
 <CAP-ksoji_94rtKXx=2LA4o9scm+LMt1dmqYPxq=hVbWc=nbF5A@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

Thanks for the further suggestion.

Martin


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