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 346223 - Defined names may not be recognized by expression parser
Defined names may not be recognized by expression parser
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: GUI
git master
Other All
: Normal minor
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2006-06-29 16:56 UTC by Andreas J. Guelzow
Modified: 2007-08-12 19:42 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Andreas J. Guelzow 2006-06-29 16:56:49 UTC 
Define the name test-a1 to refer to cell A1. Try using that name in cell C1 as =sum(test-a1)
The parser changes this to sum(test-A1) interpreting it as a sum of a difference.
Comment 1 Morten Welinder 2007-08-06 00:45:04 UTC 
I am tempted to say "then don't do that"...

However, we should probably either

1. Reject such names
2. Make them work

depending on whether we can get those from XL import.
Comment 2 Morten Welinder 2007-08-06 20:43:15 UTC 
XL rejects such names and I think I agree that we don't want to deal with
them.  Some strings would end up having multiple possible parse trees.
Comment 3 Morten Welinder 2007-08-12 19:42:12 UTC 
"reject", it is.

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.