Issue 25771 - Clicking in a non-contiguous named range does not cause its name to appear in the formula bar's drop-down box
Summary: Clicking in a non-contiguous named range does not cause its name to appear in...
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1
Hardware: All All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2004-02-22 04:32 UTC by geofffarrell
Modified: 2013-02-07 22:38 UTC (History)
1 user (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-02-22 04:32:00 UTC
Open a new spreadsheet and rename 'Sheet1' to 'Test1'.  Click in cell A5.  Open
the Define Names dialog.  Enter the name 'TestRange' and select 'Add'.  Insert
'Matrix' in the name box.  Insert the following specification in the 'Assigned
to' box:


then click on 'Add', then 'OK'.  Re-select range B4:D5 (a contiguous selection).
 Open the Define Names dialog.  Enter the name 'Block' and select 'Add' and
'OK'.  Click in cell A5.  'TestRange' appears in the formula bar's drop-down
box.  Click in any of the cells B4:D5.  'Block' appears in the the formula bar.
 Clicking in any of the cells A1, B2:D3 or A4 does not make 'Matrix' appear in
the formula bar.  This shows that single or contiguous cells' named ranges are
shown in the formula bar's drop-down box when one of their contained cells are
selected, and that this does not work for non-contiguous cells' named ranges. 
Making named ranges for non-contiguous cells appear in the formula bar's
drop-down box when ckicking in one of their contained cells, as happens for
single and contiguous cells, would be a good enhancement for consistency and
productivity.  This is the default behaviour for Excel, for example.

Presently, the only way of seeing if a particular cell is contained within a
non-contiguous named range is to open the Define Names dialog and click on all
the named ranges to see if the cell appears in the highlighted cells thus
produced.  This is cumbersome and impractical for large spreadsheets with many
named ranges.
Comment 1 geofffarrell 2004-02-22 04:35:33 UTC
Sorry, this should have been entered as an Enhancement.
Comment 2 frank 2004-02-23 10:18:45 UTC
Hi Bettina,

one for you.

Comment 3 ace_dent 2008-05-16 02:56:38 UTC Issue Tracker - Feedback Request.

The Issue you raised has the status 'New' pending further action, but has not
been updated within the last 4 years. Please consider re-testing with one of the
latest versions of OOo, as the problem(s) may have already been addressed.
Either use the recent stable version:
or consider trying the new OOo 3 BETA (still in testing):
Please report back the outcome so this Issue may be Closed or Progressed as
necessary - otherwise it may be Resolved as Invalid in the future. You may also
wish to search for (and note) any duplicates of this Issue that may have
advanced further by checking the Issue Tracker:
Many thanks,
Cleaning-up and Closing old Issues as part of:
~ The Grand Bug Squash, pre v3 ~
Comment 4 bettina.haberer 2010-05-21 14:43:19 UTC
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements".