After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 404829 - Array formula saved incorrectly
Array formula saved incorrectly
Status: RESOLVED DUPLICATE of bug 322096
Product: Gnumeric
Classification: Applications
Component: import/export MS Excel (tm)
1.6.x
Other All
: Normal normal
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2007-02-06 01:37 UTC by michal
Modified: 2009-08-27 05:06 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description michal 2007-02-06 01:37:00 UTC 
Please describe the problem:
Array formulae like:
=sum(a1:a4*b1:b4)
don't get saved properly in excel export.

In Excel (and Openoffice), what's needed is:
=sum((a1:a4)*(b1:b4))
but gnumeric removes the inner sets of parentheses.
In gnumeric, either form gives a1*b1+a2*b2+a3*b3+a4*b4
but in Excel and OO, only the second form gives this result.

Steps to reproduce:
1. 
2. 
3. 


Actual results:


Expected results:


Does this happen every time?


Other information:
Comment 1 Huzaifa Sidhpurwala (Red Hat Security Response) 2008-04-30 04:21:13 UTC 
Note:
This functionality is broken in gnumeric 1.8.2

=sum(a1:a2*a3:a4) gives #VALUE!

I am going to open a bug report on this, just an fyi
Comment 2 Andreas J. Guelzow 2009-06-27 18:51:43 UTC 
Entering =sum(a1:a4*b1:b4) as an array formula and exporting to ODF yields in OOo the same result as in Gnumeric.

Entering =sum(a1:a4*b1:b4) as a regular formula in gnumeric doesn't function as an array formula anymore and creates an implicit intersection as in Excel and exported to ODF yields the same answer in OOo as in Gnumeric.

SO I am pretty sure that this is fixed now since we do the same (weird) calculation as Excel and OOo if that formula is not entered as an array formula.

This problem has been fixed in the development version. The fix will be available in the next major software release. Thank you for your bug report.
Comment 3 Jody Goldberg 2009-06-28 20:35:00 UTC 
This is unlikely to have been fixed yet.
OOo and Gnumeric are just more lenient about the formula handling.
Comment 4 Andreas J. Guelzow 2009-07-09 04:36:49 UTC 
How does this report differ from 322096?
Comment 5 Jody Goldberg 2009-08-27 05:06:36 UTC 
*** This bug has been marked as a duplicate of bug 322096 ***