Bug 35216 - UI: Advanced filter: Cannot specify named range for criteria
Summary: UI: Advanced filter: Cannot specify named range for criteria
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.3.1 release
Hardware: Other Mac OS X (All)
: medium minor
Assignee: Not Assigned
Depends on:
Reported: 2011-03-11 08:07 UTC by freedesktopbugzilla534
Modified: 2011-03-11 09:16 UTC (History)
0 users

See Also:
Crash report or crash signature:

Demo spreadsheet (7.93 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-03-11 08:07 UTC, freedesktopbugzilla534

Note You need to log in before you can comment on or make changes to this bug.
Description freedesktopbugzilla534 2011-03-11 08:07:18 UTC
Created attachment 44360 [details]
Demo spreadsheet

When setting up an advanced filter (Data -> Filter -> Advanced filter...) the dialogue box does not permit the specification of a previously-defined named range for the criteria.

To reproduce, using the attached spreadsheet:
1) Note that the ranges filter_data, filter_criteria, and filter_results are defined.
2) Select the filter_data range.
3) Data -> Filter -> Advanced filter...
4) Note that the dropdown box offers only "-undefined-"
5) click on <More>, select "Copy results to"
6) Note, by contrast, that the "Copy results to" dropdown box _does_ offer the defined ranges.

Expected behaviour:
User should be able to select the range "filter_criteria" in step 4 above.
Comment 1 freedesktopbugzilla534 2011-03-11 09:16:49 UTC
The named range containing criteria _must_ be specified as "Area type = filter" using the hidden option in Insert -> Names -> Define... <More>

Only when this is done can the named range be seen step 4, above.

I'm closing this as "NOTABUG" although, having spent the better part of a day on it, I think the user interface and documentation could be improved.