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]
