Issue 107191 - Data Validity Cell Range changes
Summary: Data Validity Cell Range changes
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOO310m19
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2009-11-25 01:48 UTC by ken_johnson
Modified: 2017-05-20 11:33 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description ken_johnson 2009-11-25 01:48:40 UTC
Data validity using different cell ranges are not stable when the cells with the
different cell ranges are adjacent.
$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

However this instability does not occur when the cells are not adjacent.
Comment 1 ken_johnson 2009-11-25 02:13:31 UTC
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.
Comment 2 Regina Henschel 2009-11-25 14:22:35 UTC
I cannot reproduce it at all. For me the lists are also correct, if I use cell
C1 and C2 directly without step C3.
Comment 3 Regina Henschel 2009-11-25 14:31:30 UTC
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.
Comment 4 ken_johnson 2009-11-25 15:36:10 UTC
After deselecting "Automatically find column and row labels" in Tools > Options
> Calc > Calculate the problem persists.

Also, I don't see any #Ref! errors. 
Comment 5 Regina Henschel 2009-11-25 15:40:42 UTC
First unchecked and then set validity? Unchecking it afterwards when the lists
are already broken, does not help.
Comment 6 ken_johnson 2009-11-25 15:48:14 UTC
That's right, uncheck first then reset validities and the problem still occurs.
Comment 7 ken_johnson 2009-11-26 00:24:14 UTC
My problem has been solved. I have reset my user profile and the Data Validity
has returned to it normal, stable behavior. 
Comment 8 Marcus 2017-05-20 11:33:24 UTC
Reset assigne to the default "".