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 410609 - Impossible to enter functions beginning with 'R' or 'C' on a worksheet using R1C1-style references
Impossible to enter functions beginning with 'R' or 'C' on a worksheet using ...
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: GUI
git master
Other All
: Normal major
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2007-02-21 23:59 UTC by Oliver Burnett-Hall
Modified: 2007-02-22 14:26 UTC
See Also:
GNOME target: ---
GNOME version: ---



Description Oliver Burnett-Hall 2007-02-21 23:59:41 UTC
The expression parser is not working correctly on a worksheet formatted to use R1C1-style references.

For example, try entering the expression '=CONVERT(1,"m","m")' -- you get told this is an invalid expression.  This happens whether you use the expression entry widget, or if you build that expression using the formula guru.

The problem is in the parser; the first token generated in yyparse() is a RANGEREF, when it should be a STRING.  This is happening when r1c1_rangeref_parse() is called -- as 'C' is a valid cell reference in R1C1 style (the entire column of the current cell) it is interpreting it as such, so the RANGEREF token gets generated.

For a fix I guess that r1c1_rangeref_parse() needs to check the following character after the cell reference to see if it is legal (one of [-+*/(),=<>\0] plus maybe a few others).  Or maybe something else; I'm really not sure what would be the right way to do this.
Comment 1 Morten Welinder 2007-02-22 14:26:31 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.