Issue 28316 - Calc List Box dialog: Source cell range could accept Named Ranges
Summary: Calc List Box dialog: Source cell range could accept Named Ranges
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1.1
Hardware: All All
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
: 101502 (view as issue list)
Depends on:
Blocks: 15522
  Show dependency tree
Reported: 2004-04-24 07:56 UTC by geofffarrell
Modified: 2013-02-07 22:35 UTC (History)
2 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description geofffarrell 2004-04-24 07:56:28 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 Named Ranges in this field (and
perhaps others).  Obvious advantages would be the same as those attached to
using Named Ranges in the spreadsheet cells; eg, user-defined names have
familiar meaning in context. In addition, changing range specifications would
then need only be done in one place - the Named Range.  At the moment, users
have to go to every list box and make individual changes manually.
Comment 1 frank 2004-04-26 09:34:10 UTC
Hi Bettina,

a very usefull suggestion I think.

Comment 2 Regina Henschel 2009-05-03 16:39:44 UTC
*** Issue 101502 has been marked as a duplicate of this issue. ***
Comment 3 bettina.haberer 2010-05-21 14:59:41 UTC
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements".