Array formulas in Calc Guide


I’m reviewing the topic of Array formulas and found the Calc Guide a bit shallow, and bring here the suggestion to review and improve the contents of [1] .

The web can supply a lot of examples and advances use of arrays for the competition, but of course, we must write in our own words. Some interesting examples in [2].

And also the so called “implicit intersection” of array formulas, which is quite interesting (google it!).


[1] Chapter 8 Using Formulas and Functions
[2] Documentation/How Tos/Using Arrays - Apache OpenOffice Wiki