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 570890 - Missing expression namespace?
Missing expression namespace?
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: import/export OOo / OASIS
git master
Other All
: Normal normal
: ---
Assigned To: Jody Goldberg
Jody Goldberg
: 586828 (view as bug list)
Depends on:
Blocks:
 
 
Reported: 2009-02-07 19:04 UTC by Andreas J. Guelzow
Modified: 2009-06-24 08:49 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
sample ods file (9.37 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-02-07 19:06 UTC, Andreas J. Guelzow 		Details

Description Andreas J. Guelzow 2009-02-07 19:04:25 UTC 
When opeing a file (to be atttached) create with OpenOffice3.0 teh following error appears:
Sheet1!E1 : Missing expression namespace?
and the corresponding formula is not being imported.

As far as I can tell neither ODF 1.0 nor 1.1 require a namespace. We should check that.
Comment 1 Andreas J. Guelzow 2009-02-07 19:06:13 UTC 
Created attachment 128183 [details]
sample ods file
Comment 2 Morten Welinder 2009-02-09 18:16:36 UTC 
ODF 1.0 certainly required an expression namespace, but conveniently forgot
to define what it means.  It is any prefix "foo:" on expressions.

This is one of the absolutely hopeless parts of ODF.  The prefix defines
the meaning of the rest of the expression.  In other words, I could invent
an "ciremung:" namespace where all the function names were written reversed
("MUS", "RAV", etc.)  The standard seems to expect all implementations to
read that.

Formulas in this file have an "of" prefix:

    "of:=FALSE()"
    "of:=VLOOKUP("MAYBE";[.C1:.C6];1;1)"

We seem to expect "oooc:" as the prefix.

So it's a bug in ODF that we need to work around.
Comment 3 Morten Welinder 2009-02-09 18:20:43 UTC 
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 4 Andreas J. Guelzow 2009-02-09 19:22:15 UTC 
of: will be the openformula prefix. I think we can expect that ODF 1.2 will have that namespace as default so we should probably starting to assume that if there is no namespace mentioned, that it is of:

Andreas
Comment 5 Andreas J. Guelzow 2009-06-24 08:49:33 UTC 
*** Bug 586828 has been marked as a duplicate of this bug. ***