Issue 110143 - When Validation uses fixed addressing '$' ... It shouldn't always ...
Summary: When Validation uses fixed addressing '$' ... It shouldn't always ...
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOO320m12
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-03-15 16:29 UTC by gregmcc
Modified: 2013-08-05 07:30 UTC (History)
2 users (show)

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

Attachments
Error_with_PullDowns.ods (9.30 KB, application/vnd.oasis.opendocument.spreadsheet)
2010-03-15 16:31 UTC, gregmcc 		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 gregmcc 2010-03-15 16:29:21 UTC 
When using a pulldown - using the Validity selection from the Menu. If you use 
the '$' in your selection  ie I$16:I$20 - and then go and insert or delete rows 
ahead of Row 16 - the software should change the 'fixed' references - AS THEY 
SHOULD ONLY BE FIXED from a CUT and PASTE perspective and not when the software 
is handling deletions and insertions of Rows - which obviously will affect the 
intended location of the 'list' that is to be accessed.

( I don't want to mention Excel - but it wouldn't happen in that implementation 
of a spreadsheet )
Comment 1 gregmcc 2010-03-15 16:31:19 UTC 
Created attachment 68356 [details]
Error_with_PullDowns.ods
Comment 2 Edwin Sharp 2013-08-05 07:28:28 UTC 
Modifying rows above pull downs has no affect.

Rev. 1507307 Win 7
Comment 3 Edwin Sharp 2013-08-05 07:29:25 UTC 
My mistake, sorry.
Comment 4 Edwin Sharp 2013-08-05 07:30:40 UTC 
right hand side pull down entries disappear as rows are added above pull downs.