GNOME Bugzilla – Bug 114085
18.11 - References do not change in validate cells
Last modified: 2012-05-16 19:09:29 UTC
1. Start off with gnumeric_18_11.gnumeric [http://www.gnome.org/~chema/gnumeric_18_11.gnumeric] 2. Select B7 3. Right click -> Format Cells -> Validate tab 4. Note that Min=$B$3 and Max=$B$4 5. Exit format dialog 6. Select B3:B4 & Cut. Paset in D3:D4 7. Select B7 8. Right click -> Format Cells -> Validate tab 9. Note that Min=$B$3 and Max=$B$4 Should have changed to where the B3:B4 range was moved (D3:D4)
This is known and a tricky problem. Its the same issue as for names. To do it correctly I'll need to make the validation expressions into dependents which will take some care given that they are in styles. We probably have the tools, but I'll wait to tackle this later.
I don't see any tricky problems here. Bringing this back on the radar.
Unsurprisingly, if the validation data lives lives on a different sheet and that sheet is deleted, then Bad Things Happen. (Due to the undo queue, it's a little tricky to trigger, though.)
Critical and 6 and a half years old...
Fairly difficult and not experienced by many. The trouble is not keeping the validation data as a dependent and thereby have it change automatically. That's trivial these days. The trouble is that such a change can cause a style to match an existing style elsewhere. Our sheet style data structures will be most unhappy about that.
Well, Morten's recent changes to the validation has fixed the issue reported here initially. So I thin k this can be marked resolved.
For reference, this is a combination of bugs 674914 and 675955.