Issue 28317 - Calc List Box dialog: Source cell range could accept IF statements
Summary: Calc List Box dialog: Source cell range could accept IF statements
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-04-24 07:59 UTC by geofffarrell
Modified: 2013-02-07 22:40 UTC (History)
1 user (show)

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

Attachments
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 geofffarrell 2004-04-24 07:59:07 UTC 
Calc 'Properties: List Box' dialogs only accept standard column-row nomenclature
(ie, A1:A4) when specifying a 'Source cell range'.  It would be a very useful
enhancement for users to be able to specify an IF statement; eg
=IF(A12="Selection1";E2;IF(A12="Selection2";E4;IF(A12="Selection3";E7;""))). 
Users would then be able to construct list boxes based on the selections of
other list boxes.  This would be a very powerful feature.  For this to work, the
List Box's 'Source cell range' would need to access the same function that
spreadsheet cells use to evaluate IF statements, and the field's contents would
need to be evaluated and updated whenever the spreadsheet was modified.
Comment 1 frank 2004-04-26 09:32:17 UTC 
Hi Bettina,

one for you.

Frank
Comment 2 bettina.haberer 2010-05-21 14:54:58 UTC 
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements".