Apache OpenOffice (AOO) Bugzilla – Issue 24952
SUMXMY2 import fails
Last modified: 2004-02-02 10:02:48 UTC
In Excel SUMXMY2 can be used without crtl-shift-return. When importing such a file the sheet gets an Err:504 because in OOo it is a matrix-function, see column C in the referrenced file. I expect, that the import-filter would set SUMXMY2 explizit as matrix-function even if excel uses it only implizit.
Similar problem with SUMPRODUCT, see issue 4485, fixed in OOO 2.0. *** This issue has been marked as a duplicate of 4485 ***
double -> closed