Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Calc List Box dialog: Source cell range could accept IF statements|
|Component:||ui||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Issue Type:||ENHANCEMENT||Latest Confirmation in:||---|
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".