G. Roderick Singleton wrote:
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).
I opened the file with 1.9.93, and unhid all the hidden sections of the
file. Then in the first named sheet, I looked at the formulae in e5...,
where the INDIRECT() function is. I opened one of those cells, and
using the function autopilot, changed the cell reference from A2 to "A2"
(quotes included), and the error disappeared. This may be the clue to
your problem.
Matt Needles
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
