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 306686 - Expressions using names saved incorrectly in .gnumeric format
Expressions using names saved incorrectly in .gnumeric format
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: General
git master
Other All
: Normal normal
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2005-06-06 17:53 UTC by Morten Welinder
Modified: 2009-04-28 21:08 UTC
See Also:
GNOME target: ---
GNOME version: ---



Description Morten Welinder 2005-06-06 17:53:55 UTC
See also bug 306684 and bug 306685.

If a workbook level name FOO and a sheet-level name FOO both exits,
then expressions referencing either will simply use FOO when converted
to text, including when saved to .gnumeric format.

This corrupts the global reference.
Comment 1 Morten Welinder 2006-12-29 18:30:33 UTC
Fixed in the development version. The fix will be available in the next major release. Thank you for your bug report.

This was actually a parsing problem.  When defining a global name, one should
not be allowed to refer to sheet-local names without a sheet name qualifier.
Comment 2 Morten Welinder 2006-12-30 01:09:37 UTC
Closed wrong bug.
Comment 3 J.H.M. Dassen (Ray) 2008-08-28 14:38:59 UTC
Morten, from
http://svn.gnome.org/viewvc/gnumeric?view=revision&revision=15343 it looks
like you fixed this issue a long time ago. If that's indeed the case, please
close this bug.
Comment 4 Morten Welinder 2008-08-28 15:09:10 UTC
Still there.

1. Create FOO in Sheet1 with value of $A$1
2. Create FOO in workbook with value of 42.
3. Enter =FOO in Sheet!A1 and Sheet2!A1.
4. Copy Sheet2!A1 into Sheet1!A2

[A2 evaluates to 42 as it references the global FOO]

5. Save, exit, load

==> A2 now references the sheet-local FOO and evaluates to 0.
Comment 5 Morten Welinder 2008-09-11 22:33:49 UTC
Basically we need a syntax that says "the global FOO, not the sheet-local one".
I suggest "!FOO".  Objections?
Comment 6 Morten Welinder 2009-04-28 21:08:23 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.

The syntax became []FOO which is a syntactically close to referencing
names in other workbooks.