Version: (using KDE KDE 3.5.2) Installed from: Ubuntu Packages OS: Linux SUMPRODUCT formula do not manage correctly their arguments when these are "vertical vectors". Instead, the formula takes the first argument twice. It does not happen with "horizontal vectors", i think. Example: being A1=2,A2=2,B1=3,B2=3. =SUMPRODUCT(A1:A2;B1:B2) result is 8 instead 12. =SUMPRODUCT(A1:B1;A2:B2) result is 13. Right!!
SVN commit 561524 by mecir: Two-array functions now correctly use both arrays, instead of only one. BUG: 130681 M +1 -1 ValueCalc.cpp --- trunk/koffice/kspread/ValueCalc.cpp #561523:561524 @@ -1656,7 +1656,7 @@ for (int c = 0; c < cols; c++) { Value v1 = a1.element (c, r); - Value v2 = a1.element (c, r); + Value v2 = a2.element (c, r); if (v1.isArray() && v2.isArray()) twoArrayWalk (v1, v2, res, func); else {
SVN commit 561530 by nikolaus: backport SVN commit 561524 by mecir: Two-array functions now correctly use both arrays, instead of only one. CCBUG: 130681 M +1 -1 valuecalc.cc --- branches/koffice/1.6/koffice/kspread/valuecalc.cc #561529:561530 @@ -1587,7 +1587,7 @@ for (int c = 0; c < cols; c++) { Value v1 = a1.element (c, r); - Value v2 = a1.element (c, r); + Value v2 = a2.element (c, r); if (v1.isArray() && v2.isArray()) twoArrayWalk (v1, v2, res, func); else {
You need to log in before you can comment on or make changes to this bug.