On Wed, 2005-04-27 at 17:28 +0200, Elsasser wrote:
>
> G. Roderick Singleton a Ãcrit :
>
> >On Wed, 2005-04-27 at 15:32 +0200, Elsasser wrote:
> >
> >
> >>In a OO CALC Spreadsheet, if I want to insert relative URL addresses and
> >>follow the indications of the OO helpfiles, it does not work, and the
> >>addresses always stay "absolute".
> >>Besides, if I select "Button" in the "Text/Button" switch, 1. the Button
> >>does not work, 2. There is no means to get rid of it (actually, there IS
> >>a means, which is to destroy both the cell where it is supposed to be
> >>and the cell just below, but I may want to keep the information that is
> >>in this latter cell).
> >>Does anybody know how to make relative paths really work ?
> >>
> >>
> >>
> >
> >Not sure but I recall adding info on using URLs to
> >http://documentation.openoffice.org/manuals/OOo1.x.x/user_guide.pdf
> >I think that this section is somewhere around page 200 +/- 10 pages. It
> >mentions using '$' for absolute addresses. I cannot lookup up at this
> >moment so will let you see whether or not it helps.
> >
> >Good luck.
> >
> >
> My problem is NOT about relative vs absolute adresses of spreadsheet
> cells, but of URLs to which there is a hyperlink in a cell. I find
> nothing about that question in the OO User Guide.
> Marc H.
Mark I found this on page 206:
Referencing a Cell in Another Document
Cells can also be referenced in other spreadsheets:
1. For the following example, the source document is named 'C:\test
\test.sxc'; and it contains a sheet named Sheet1.
2. Open a different or new spreadsheet document.
3. Place the cursor in cell A1 and enter the following formula:
='C:\test\test.sxc'#Sheet1.A1
4. Alternatively, enter the file name as a URL designation:
='file:///C/test/test.sxc'#Sheet1.A1. Similarly access a file on
the Internet by using:
='http://www.sun.com/test/test.sxc'#Sheet1.A1.
5. Drag the box in the lower right corner of the active cell to
select a range of cells. OpenOffice.org automatically inserts
the corresponding references in the adjacent cells. As a result,
the sheet name is preceded with a "$" sign to designate it as an
absolute reference.
Note #5. If you are using '$' then ...
Sorry you couldn't find it.
--
PLEASE KEEP MESSAGES ON THE LIST.
Documentation Co-Lead
http://documentation.openoffice.org/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
