GNOME Bugzilla – Bug 306686
Expressions using names saved incorrectly in .gnumeric format
Last modified: 2009-04-28 21:08:23 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.
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.
Closed wrong bug.
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.
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.
Basically we need a syntax that says "the global FOO, not the sheet-local one". I suggest "!FOO". Objections?
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.