The help ARRAY FORMULA is a help here. Quoting it:
Creating Array Formulas
If you create an array formula using the *Function Wizard*, you must
mark the *Array* check box each time so that the results are returned in
an array. Otherwise, only the value in the upper-left cell of the array
being calculated is returned.
If you enter the array formula directly into the cell, you must use the
key combination Shift+Ctrl+Enter instead of the Enter key. Only then
does the formula become an array formula.
Array formulas appear in braces in OpenOffice.org Calc. You cannot
create array formulas by manually entering the braces.
The cells in a results array are automatically protected against
changes. However, you can edit or copy the array formula by selecting
the entire array cell range.
I hope this helps.
Joe Conner, Poulsbo, WA
Toms Gmail wrote:
Dear Users,
I have just converted to using Open Office from the usual Microsoft,
this due to starting my own company and I like the idea of open
source. Well it is also free which is an added bonus
In Excel you can make a list in an array formula so that a row vector
can be subtracted/added from a another list of values
Eg from Excel
={10*LOG(SUM(10^((E15:L15+{1,2,3,4,5,6,7,8})/10))}
The idea is that the values in the { brackets} can modify the values
in the range E15:L15. This is the form of a formula that I use to
calculate sums for acoustic measurements. I have found that Calc
doesn't seem to recognize the { } and thus I have to use a much more
complicated formula.
Could anyone help with how to overcome this problem? I have done a
search of the groups but can't seem to find much.
Regards
Tom Harper.
------------------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.488 / Virus Database: 269.14.2/1052 - Release Date: 10/5/2007 6:53 PM
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
