GNOME Bugzilla – Bug 668691
Abs/rel mode (F4) is sticky
Last modified: 2012-01-27 22:11:05 UTC
A1: = [right] [enter] (you get =b1) A2: =h4 [F4] [enter] (you get =$h$4) A3: = [right] [enter] (you get =$b$3) This should not be sticky. That last one should yield =b3.
Hmm, if this were not sticky how would you switch to absolute mode?
I don't want it to be a "mode". I want it to change the current reference when F4 is pressed and nothing else.
XL seems to do the same thing I argued for. It's certainly the only thing that fits my usage pattern. Specifically I use F4 while entering a formula because a single cell needs to be fully or partially absolute. It is definitely on a per-cell or even per-reference basis.
This problem has nothing to do with F4. Try the following: A1: = [right] [enter] (you get =b1) A2: =$h$4 [enter] (you get =$h$4) A3: = [right] [enter] (you get =$b$3) We seem to not resetting the gnumeric-expr-entry correctly when we move to a new cell.
If you track the state of rs->ref.a.col_relative with rs = &gee->rangesel in gnm_expr_entry_load_from_range you see that it is set to false when we A3: = [right] [enter] (you get =$b$3) but I don't see why...
col_relative changes precisely when you finish entering a ref, i.e., when you type the "4" in "=$h$4" or "=h4". It doesn't reset on, say, adding a "+" afterwards.
Fix in hand.
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.