Issue 110143 - When Validation uses fixed addressing '$' ... It shouldn't always ...
Summary: When Validation uses fixed addressing '$' ... It shouldn't always ...
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:
Depends on:
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: ---

Error_with_PullDowns.ods (9.30 KB, application/vnd.oasis.opendocument.spreadsheet)
2010-03-15 16:31 UTC, gregmcc
no flags Details

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]
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.