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 650639 - Incorrect interpretation of [$#REF!.$A$1] during ODF import
Incorrect interpretation of [$#REF!.$A$1] during ODF import
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: import/export OOo / OASIS
git master
Other Linux
: Normal normal
: ---
Assigned To: Andreas J. Guelzow
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2011-05-20 04:25 UTC by Andreas J. Guelzow
Modified: 2011-05-20 21:10 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
sample file (7.85 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-05-20 04:25 UTC, Andreas J. Guelzow 		Details

Description Andreas J. Guelzow 2011-05-20 04:25:29 UTC 
Created attachment 188200 [details]
sample file

The attached file, created by localc 3.3.2, contains the named expression ProblemName defined as [$#REF!.$A$1]. Cell A1 uses that name in its formula.

The expression [$#REF!.$A$1] is invalid (see the bug https://bugs.freedesktop.org/show_bug.cgi?id=37391 filed against localc).

On import Gnumeric interprets this expression as [.$A$1]. This is incorrect.

Since the expression is invalid it should be interpreted as an error, namely an invalid reference, (or in the case of a named expression it would be justifiable to ignore that expression). Both of these actions should have the same effect that A1 obtains the value #REF!.
Comment 1 Andreas J. Guelzow 2011-05-20 06:25:41 UTC 
A patch that would fix this problem has been attached to bug # 650640.
Comment 2 Andreas J. Guelzow 2011-05-20 16:11:51 UTC 
LibreOffice Calc will also save stuff such as [$Sheet1.$#REF!$1] and [$Sheet1.$A$#REF!] which aren't valid OpenFormula but we should probably handle too.
Comment 3 Andreas J. Guelzow 2011-05-20 17:51:42 UTC 
[$#REF!.$A$1] is now handled correctly. Keeping open for [$Sheet1.$#REF!$1] and
[$Sheet1.$A$#REF!].
Comment 4 Andreas J. Guelzow 2011-05-20 21:10:59 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.