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 610175 - incorrect handling of error literals in ODF export/import
incorrect handling of error literals in ODF export/import
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: import/export OOo / OASIS
git master
Other All
: Normal normal
: ---
Assigned To: Andreas J. Guelzow
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2010-02-16 17:12 UTC by Andreas J. Guelzow
Modified: 2010-02-18 19:19 UTC
See Also:
GNOME target: ---
GNOME version: ---


Attachments
fix for this problem (758 bytes, patch)
2010-02-16 17:41 UTC, Andreas J. Guelzow
none Details | Review

Description Andreas J. Guelzow 2010-02-16 17:12:43 UTC
A1:  #N/A
A2:  '#N/A

B1:  =iserror(A1)
B2:  =iserror(A2)


B1 will show TRUE and B2 will show FALSE

save as ODF file.
reopen
recalculate

now both B1 and B2 show as FALSE since A1 has become a string.



This is aprtially due to the requirement that error literals in ODF are stored as value-type=string. 

OOo does not know error literals so it is not an issue
Excel converts error literals into a formula =#N/A

In ODF1.2 with OpenFormula we might be seeing a new value-type=error but that is not available in ODF 1.1.
Comment 1 Andreas J. Guelzow 2010-02-16 17:41:45 UTC
Created attachment 153944 [details] [review]
fix for this problem

Morten, this seems like a save patch. May I commit?
Comment 2 Morten Welinder 2010-02-18 15:53:37 UTC
Heh.  It is indeed a "save" patch, but I suspect you meant "safe".

Go ahead, but perhaps add a comment and a reference to this bug.
This is a weird thing to have to do.
Comment 3 Andreas J. Guelzow 2010-02-18 19:19:33 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.