Apache OpenOffice (AOO) Bugzilla – Issue 25770
Non-contiguous named ranges don't appear in the formula bar's drop-down box
Last modified: 2013-02-07 22:36:44 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: $Test1.$A$1;$Test1.$B$2:$D$2;$Test1.$B$3:$D$3;$Test1.$A$4 then click on 'Add', then 'OK'. Click on the drop-down box in the formula bar. Only 'TestRange' is shown; 'Matrix' is absent. Re-open the Define Names dialog and click on 'Matrix'. The specified cells in 'Matrix' will be highlighted in sheet Test1. Exit the Define Names dialog by clicking on 'Cancel'. Although not shown in the drop-down box, the named range 'Matrix' will work in formulas. Enter the number 15 in cells A1, B2:D3 and A4. Click in cell C6 and enter the formula _=SUM(Matrix)_. The result (120) will be shown in cell C6. Re-select range B4:D5 (a contiguous selection). Open the Define Names dialog. Enter the name 'Block' and select 'Add' and 'OK'. The formula bar drop-down box shows both 'TestRange' and 'Block'; selecting 'TestRange' or 'Block' activates those selections correctly. This shows that single or contiguous cells' named ranges are shown in the formula bar's drop-down box, that selecting them there activates their respective selections, 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, 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 selecting a non-contiguous named range is to open the Define Names dialog, click on the range's name, see the highlighted cells, memorize them, then exit and select them manually. This is cumbersome and impractical for even one selection event, let alone having to do it multiple times.
Hi Bettina, one for you. Frank
OpenOffice.org 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: http://download.openoffice.org/index.html or consider trying the new OOo 3 BETA (still in testing): http://download.openoffice.org/3.0beta/ 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: http://www.openoffice.org/issues/query.cgi Many thanks, Andrew Cleaning-up and Closing old Issues as part of: ~ The Grand Bug Squash, pre v3 ~ http://marketing.openoffice.org/3.0/announcementbeta.html
To grep the issues easier via "requirements" I put the issues currently lying on my owner to the owner "requirements".