Apache OpenOffice (AOO) Bugzilla – Issue 107191
Data Validity Cell Range changes
Last modified: 2017-05-20 11:33:24 UTC
Data validity using different cell ranges are not stable when the cells with the different cell ranges are adjacent. Example... $Sheet1.$C$1 validity cell range = $Sheet1.$A$2:$A$8 (letters a-g) $Sheet1.$C$2 validity cell range = $Sheet1.$B$2:$B$8 (numbers 1-7) Operate the drop down selection lists and you will find that either C1's list will change from letters to numbers or C2's list will change from numbers to letters. However this instability does not occur when the cells are not adjacent.
After a bit of experimenting I notice that the instability does not occur if after setting up C1's validity the validity intended for C2 is setup in C3 then C3 is dragged to C2.
I cannot reproduce it at all. For me the lists are also correct, if I use cell C1 and C2 directly without step C3.
OK, I got it now. The error occurs, when the option "Automtically find column and row labels" is switched on in Tools > Options > Calc > Calculate. You see an #Ref error in the lists, if you have clicked on a cell outside the affected area and then come back to the lists.
After deselecting "Automatically find column and row labels" in Tools > Options > Calc > Calculate the problem persists. Also, I don't see any #Ref! errors.
First unchecked and then set validity? Unchecking it afterwards when the lists are already broken, does not help.
That's right, uncheck first then reset validities and the problem still occurs.
My problem has been solved. I have reset my user profile and the Data Validity has returned to it normal, stable behavior.
Reset assigne to the default "issues@openoffice.apache.org".