Jim Martin wrote:
Okay, please disregard the previous question. Its working and I'm really
getting the hang of it.
Ok :-)
Just to explain why this works and your first try does not: The range
operator ":" in Calc works with fixed cell addresses only, e.g. A1:B5
or $C$7:$D$8. Anything else (names and functions) does not work in
Calc, such as namedrange:C7 or INDIRECT(...):A5. Therefore,
INDIRECT("A1"):INDIRECT("B2") does nor work, but INDIRECT("A1:B2") works.
But this will hopefully be fixed soon:
http://qa.openoffice.org/issues/show_bug.cgi?id=4904
Regards
Daniel
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
