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
Status: CONFIRMED
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:
URL:
Keywords:
: 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:
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: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.

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