Issue 107474 - validity range not updated if cell area has been moved
Summary: validity range not updated if cell area has been moved
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.1.1
Hardware: PC Windows XP
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2009-12-06 14:28 UTC by addo2
Modified: 2013-01-29 21:42 UTC (History)
2 users (show)

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

Attachments
the problem in reality: the surounded cells do cary other information (9.03 KB, text/plain)
2009-12-06 14:34 UTC, addo2 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description addo2 2009-12-06 14:28:46 UTC 
I could not put my OOo in English so I try to translate all the functions from
dutch as good as I can...

when I am making a dropdown menu of several cells (=A2:A8) I went to tools?,
validity?, criteria: cellcreteria? and put the aria =A2:A8 in the aria source?.

At that moment I get in the cell I had selected an arrow where if i klick on the
arrow a dropdown menu appeals with the information in the cells. (let's say C1)

problem: if the cell when you move the C1 cell the selected aria changes too: 
C1 -> D1
=A2:A8 -> =B2:B8

When the table is moved the selected aria in cell C1 does not change.

If you make one mistake and you need to add a row the entire workspace does to
be manually updated (what is quite anoying;))
Comment 1 addo2 2009-12-06 14:34:12 UTC 
Created attachment 66518 [details]
the problem in reality: the surounded cells do cary other information
Comment 2 Rainer Bielefeld 2009-12-07 06:01:31 UTC 
Reproducible with "addo2.ods" (and own documents) and "Ooo 3.1.1 WIN XP
DE-multilingual version German UI activated [OOO310m19 (Build 9420)]"!
To see the problem more clearly:

1. open "addo2.ods"
2. click 'E5'
3. Type formula "=CONCATENATE(A3;A4)" , <enter>
   cell contents "ab" should be shown
4. now click 'a3' and select 'A3:A8' with pushed let mouse button
5. release mouse button 
   (selection stays highlighted)
6. click 'A8', drag and drop 'A8' to 'A20'
   now you have green cells 'A51:A20'
   expected: formula in 'E5' should be adapted to "=CONCATENATE(A15;A16)", so 
             that cell contents still is "ab"
   actual: as expected
   expected: validity criteria range for cell 'C1' should be adapted from 
             "A3:A8" to "A15:A20"
   actual: criteria range remains without change.

That's unexpected and inconsistent.