>From 1.9m94 Help
INDIRECT
Returns the reference specified by a text string. This function can also
be used to return the area of a corresponding string.
Syntax
INDIRECT(ref)
ref represents a reference to a cell or an area (in text form) for which
to return the contents.
Note Icon
If you open an Excel spreadsheet
that uses indirect addresses
calculated from string functions,
the sheet addresses will not be
translated automatically. For
example, the Excel address in
INDIRECT("filename!sheetname"&B1) is
not converted into the Calc address
in INDIRECT
("filename.sheetname"&B1).
On Thu, 2005-04-21 at 15:28 -0400, Anthony Chilco wrote:
> Hi John,
> I gather that by now you've seen the post from Steve K. It
> seems to work fine with 1.9.79. I've been meaning to
> download and install the beta, so I'll try it tonight. I
> can't see how it would work, though.
> I think you've seen the issue regarding indirects. I had
> been notified that it would be mentioned in v2 help.
> tc
>
> John King wrote:
> > On Thu, 21 Apr 2005 12:11:04 -0400, Anthony Chilco wrote:
> >
> >
> >>Hi John,
> >>I had the same problem with indirect functions. It was logged as an issue
> >>and the fix was to put a note in the help section on MS compatibility. I'm
> >>downloading the file. If it's a quick fix, I can do it for you and send
> >>back the file to you off line.
> >>tc
> >
> >
> > That would be marvellous.
> >
> > I can't find the note you refer to in help. Has it been included yet?
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
--
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]
