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 586828 - SUM() broken for ODF
SUM() broken for ODF
Status: RESOLVED DUPLICATE of bug 570890
Product: Gnumeric
Classification: Applications
Component: import/export OOo / OASIS
1.8.x
Other All
: Normal normal
: ---
Assigned To: Andreas J. Guelzow
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2009-06-24 08:38 UTC by Ian Dalton
Modified: 2009-06-24 08:49 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
doesn't work (6.94 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-06-24 08:38 UTC, Ian Dalton 		Details
works (6.81 KB, application/vnd.sun.xml.calc)
2009-06-24 08:39 UTC, Ian Dalton 		Details

Description Ian Dalton 2009-06-24 08:38:25 UTC 
Please describe the problem:
SUM() works if I save in OOo as OOo 1.0 (.sxc), but not ODF (.ods).

Steps to reproduce:
1. Create a file in OpenOffice.org (3.0.1 Ubuntu's repo).
2. Enter some data and SUM() it.
3. Open in Gnumeric.


Actual results:
An error of the form "Sheet1!A4 : Missing expression namespace" and the formula (but not the value) is missing.

Expected results:
Formula to remain and no error to appear.

Does this happen every time?
Yes

Other information:
Comment 1 Ian Dalton 2009-06-24 08:38:57 UTC 
Created attachment 137291 [details]
doesn't work
Comment 2 Ian Dalton 2009-06-24 08:39:12 UTC 
Created attachment 137292 [details]
works
Comment 3 Andreas J. Guelzow 2009-06-24 08:49:33 UTC 
OpenOffice decided to change its namespace. They used to use oooc: for its formulas, then decided to change to of: which is supposed to stand for OpenFormula, a standard that doesn't exist yet.

This is alreday fixed for a while, since 1.9.4 (1.9.9 has been released last weekend.)


This particular bug has already been reported into our bug tracking system, but we are happy to tell you that the problem has already been fixed. It should be solved in the next software version. You may want to check for a software upgrade.


*** This bug has been marked as a duplicate of 570890 ***