--------------------------------------------------
From: "Juergen Diel" <[EMAIL PROTECTED]>
Sent: Sunday, March 23, 2008 9:53 PM
To: <[email protected]>
Subject: [users] Calc: Reverse Arrays
Dear all,
I'm using OO V. 2.3. I'm experiencing the following:
When entering =SUMMENPRODUKT(A12:A14;A14:A12),
[=SUMPRODUCT(A12:A14;A14:A12)] OOCalc reverses the second term to A12:A14.
Obviously, that gives a different result than I need it. There are
workarounds which return a reversed matrix, but it would be easier if
OOCalc wouldn't correct what I'm writing.
Why would you need it? For example the calculation of so called Schröder
numbers requires that you calculate the scalar product of a vector A(0) to
A(n) with the same vector reversed A(n) to A(0).
Is there a way to force OOCalc to observe the order given? Or is it a bug?
And, it seems to be not possible to do a sumproduct of a horizontal and
vertical error. =SUMPRODUCT(A12:A14;A1:C1) returns a #Value error.
Finally, thanks to all contributing to such a nice tool!
Kind regards,
Jürgen Diel
(JuergenDiel >at< gmx >dot< de
--
Ist Ihr Browser Vista-kompatibel? Jetzt die neuesten
Browser-Versionen downloaden: http://www.gmx.net/de/go/browser
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
