Mailing-List: contact ooo-users-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ooo-users@incubator.apache.org
Received-SPF: neutral (athena.apache.org: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com.au;
  h=X-YMail-OSG:Received:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
  b=hJyvH8A/GgkowArBHrNFPCr2eBxklgSKURbBvz9pbh7/xA9Woj8KCTSPych3DSrJfNIdps5+6mGzkrzkZOoIaexfs2TgAwisfwLTnU2kxMQlWpwMnmSEC1TuRU7boSRSUUc3kNWuxKRGrNR2nMyaOcZY0f6KLlg5hiaYoflRNMk=;
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>
 <4EB27261.6030008@bluewin.ch>
Message-ID: <1320318428.7981.YahooMailNeo@web161704.mail.bf1.yahoo.com>
Date: Thu, 3 Nov 2011 04:07:08 -0700 (PDT)
From: Terry <terauck-aoousers@yahoo.com.au>
Reply-To: Terry <terauck-aoousers@yahoo.com.au>
Subject: Re: Question Replace Path in Calc
To: "ooo-users@incubator.apache.org" <ooo-users@incubator.apache.org>
In-Reply-To: <4EB27261.6030008@bluewin.ch>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Are you searching for '/Users/me/data/' and replacing it with ' /Users/me/p=
roject/data/'?=0A=0AI will try the process in a test file.=0A=0ATerry=0A=0A=
=0A=0A----- Original Message -----=0A> From: Martin Hediger <ma.hed@bluewin=
.ch>=0A> To: ooo-users@incubator.apache.org=0A> Cc: =0A> Sent: Thursday, 3 =
November 2011 9:52 PM=0A> Subject: Re: Question Replace Path in Calc=0A> =
=0A> Hallo=0A> I was using the search & replace dialog and set "search in =
=0A> Formulae". =0A> However, when I replace a "link", it becomes a string,=
 and so no =0A> longer =0A> clickable. Then my file does not open. How can =
I keep it a link to a file?=0A> =0A> Thanks for any hints.=0A> =0A> =0A> =
=0A> =0A> Am 02.11.11 13:39, schrieb Rob Weir:=0A>>  On Wed, Nov 2, 2011 at=
 5:59 AM, Terry<terauck-aoousers@yahoo.com.au>=A0 =0A> wrote:=0A>>>  Use th=
e Find and Replace tool.=A0 If you do not have a toolbar icon, it =0A> is i=
n the menu 'Edit' (Ctrl + F).=0A>>> =0A>>>  When the dialogue opens, press =
the button on the bottom left labelled =0A> "More Options."=A0 Make sure it=
 says to search in 'Formulae' (an =0A> anachronism meaning formulas).=A0 En=
ter the wording you want to replace under =0A> "Search for" and enter the n=
ew wording under "Replace with."=0A>>> =0A>>  That's a good solution.=A0 An=
other approach is to use Calc's text=0A>>  functions to calculate the new p=
ath.=A0 This can work for more=0A>>  complicated examples.=0A>> =0A>> =0A> =
http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_Text_f=
unctions=0A>> =0A>>  LEFT(), RIGHT(), REPLACE(), FIND(), SEARCH(), CONCATEN=
ATE() are useful for =0A> this.=0A>> =0A>>  -rob=0A>> =0A>>>  Regards.=0A>>=
> =0A>>>  ----- Original Message -----=0A>>>>  From: Martin Hediger<ma.hed@=
bluewin.ch>=0A>>>>  To: ooo-users@incubator.apache.org=0A>>>>  Cc:=0A>>>>  =
Sent: Wednesday, 2 November 2011 7:58 PM=0A>>>>  Subject: Question Replace =
Path in Calc=0A>>>> =0A>>>>  Dear List=0A>>>>  I maintain a little database=
 about some results from published =0A> experiments in a=0A>>>>  calc sprea=
dsheet. To be able to conveniently view the publication =0A> reporting a=0A=
>>>>  specific experimental value, I included links to PDFs on my local =0A=
> machine, such=0A>>>>  that I can just hit the link and open the PDF if I =
need to recall =0A> some details=0A>>>>  about an experimental value. Somet=
hing like this:=0A>>>> =0A>>>>  Energy Name PDF=0A>>>>  3.141 C3PO /Users/m=
e/data/c3po.pdf=0A>>>>  2.718 R2D2 /Users/me/data/r2d2.pdf=0A>>>>  [...]=0A=
>>>> =0A>>>> =0A>>>> =0A>>>>  Now, I had to adjust the directory structure,=
 and so the links are =0A> not exactly=0A>>>>  correct anymore. The path wo=
uld now be /Users/me/project/data/*pdf.=0A>>>>  How can I adjust the links =
to this new path? I tried =0A> "Spelling, F7",=0A>>>>  but it only gives su=
ggestions for the Names, not the links.=0A>>>> =0A>>>>  Any suggestions are=
 appreciated.=0A>>>> =0A>>>>  Martin=0A> =0A> =0A> ------------------------=
---------------------------------------------=0A> To unsubscribe, e-mail: o=
oo-users-unsubscribe@incubator.apache.org=0A> For additional commands, e-ma=
il: ooo-users-help@incubator.apache.org=0A>

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