Issue 28317

Summary:	Calc List Box dialog: Source cell range could accept IF statements
Product:	Calc	Reporter:	geofffarrell <gfarrell>
Component:	ui	Assignee:	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
=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".