Issue 28317

Summary: Calc List Box dialog: Source cell range could accept IF statements
Product: Calc Reporter: geofffarrell <gfarrell>
Component: uiAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 1.1.1   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---

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

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