A "named range" as defined in Insert>Names>Define... can be any formula expression including constants, function results, calculated references. For instance a range name may refer to OFFSET($Sheet1.$A$1:$B$1;0;0;COUNTA($Sheet1.$A$1:$A$1048576)) Using this "named range" as a data pilot source fails. The new data pilot source selector should support database ranges. -- A database range is supposed to be a database-like list just like database row sets. A data pilot relies on a database-like list. -- Database ranges always refer to an unambiguous, absolute range address.
(In reply to comment #0) > Using this "named range" as a data pilot source fails. +1 Named ranges referring to ranges of data whose references are calculated by formula should be accepted... (cf. this RFE https://bugs.freedesktop.org/show_bug.cgi?id=33152) > The new data pilot source selector should support database ranges. +1 and more : pivot table display a data range name in the filter dialog if exists ! This makes it even more incomprehensible that it is not possible to use them as "source". Steps to reproduce : (open DataPilotNameRange1.ods for going directly to step 8) 1. Create a new spreadsheet 2. Sheet1, type "Name, A, B, C" respectively in A1:A4 3. Sheet1, type "Value, 1, 2, 3" respectively in B1:B4 4. Select A1:B4 5. Insert > Names > Define > Scope : Global > Name : NameByInsertName > Assigned to : $Sheet1.$A$1:$B$4, Add 6. Data > Pivot table > Create > Selection > Name range : "NameByInsertName" 7. Drag field Name to Row Fields, Value to Data Fields (for example) > Ok > Data pilot is created 8. Click on Filter button, the filter dialog appears 9. Click in this dialog on the "More" button 10. Dialog display "Data range: (_Anonymous_sheet_DB_)" We could expect "Data range: (NameByInsertName)" but it is not the problem (open DataPilotNameRange2.ods for going directly to step 12) 11. Select $Sheet1.$A$1:$B$4 12. Data > Define Range > Name : NameByDataDefineRange > Range : $Sheet1.$A$1:$B$4, Add 13. Click on Filter button of Data pilot, the filter dialog appears 14. Click in this dialog on the "More" button 15. Dialog display "Data range: (NameByDataDefineRange)" So, Data pilot is able to "see" the data define range name... but not to use it. Best regards
Created attachment 49456 [details] DataPilotNameRange1.ods
Created attachment 49457 [details] DataPilotNameRange2.ods
[This is an automated message.] This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it started right out as NEW without ever being explicitly confirmed. The bug is changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases. Details on how to test the 3.5.0 beta1 can be found at: http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1 more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
Dear bug submitter! Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs. To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem. Yours! Florian