"David Farber" wrote:
I am using the basic Excel help tool within my 2002
version to investigate how arrays operate.
[....]
I guess the Open Office version works under a different set of rules.

Open Office?!

You started by claiming you are asking about MICROSOFT Excel.

Now you say you are asking about APACHE Open Office.

That is a different animal altogether.

Any similarity in behavior is completely accidental. (Albeit perhaps by
design.)