Bug 137420 - Pivot Table named range does not list database ranges
Summary: Pivot Table named range does not list database ranges
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.6.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Pivot-Table
  Show dependency treegraph
 
Reported: 2020-10-12 12:03 UTC by mshiner
Modified: 2020-10-25 07:14 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Calc spreadsheet with database range (14.57 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-10-12 19:09 UTC, mshiner
Details
the csv file to import into the db range (1.76 KB, text/csv)
2020-10-12 19:10 UTC, mshiner
Details

Note You need to log in before you can comment on or make changes to this bug.
Description mshiner 2020-10-12 12:03:06 UTC
Hi

In the past I've used base and registered data sources to get data into calc but I'm experimenting with the data provider.

When trying to create a pivot table 

Data->Pivot Table->Insert or Edit 

the option Named Range only includes 'named ranges' whereas it should probably also include ranges defined through the Data->define range option.... or provide these as another radio button with a list.

Martyn
Comment 1 Xisco Faulí 2020-10-12 18:40:00 UTC
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. 
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
(Please note that the attachment will be public, remove any sensitive information before attaching it. 
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
Comment 2 mshiner 2020-10-12 19:09:25 UTC
Created attachment 166322 [details]
Calc spreadsheet with database range

The database range is defined at $A$1 as listimport.
Comment 3 mshiner 2020-10-12 19:10:11 UTC
Created attachment 166323 [details]
the csv file to import into the db range

this files needs to be in ~/Downloads
Comment 4 mshiner 2020-10-12 19:16:08 UTC
Hi

I've uploaded the files.

If you open the calc spreadsheet there is a defined database range at $A$1:$O$14

This is not a normal range as created by Insert->Named Range or Expression and does not appear in the navigator.

The option Data->Pivot table->Insert or Edit gives a dialog with three choices one of which is Named Range - this option is greyed out even though a database range exists
Comment 5 m_a_riosv 2020-10-14 18:34:37 UTC
Because named ranges are no part of the Menu/Data/Define range and has nothing to do with it (Menu/Sheet/Named Ranges and expressions), to access database data, must be selected the option 'Data source registered' and from base file select the data.
Comment 6 mshiner 2020-10-14 19:40:41 UTC
(In reply to m.a.riosv from comment #5)
> Because named ranges are no part of the Menu/Data/Define range and has
> nothing to do with it (Menu/Sheet/Named Ranges and expressions), to access
> database data, must be selected the option 'Data source registered' and from
> base file select the data.

I understand the registered database option for external data (I use them all the time).

But (and with respect) if Calc is going to allow an option for 'normal' named ranges as a source for a Pivot Tables  then surely database ranges must also be allowed for consistency?

This is especially true if one is trying to use a database range based on a link to another sheet (say a csv file).

M
Comment 7 QA Administrators 2020-10-15 04:11:58 UTC Comment hidden (obsolete)
Comment 8 m_a_riosv 2020-10-15 08:05:40 UTC
Then this is not a bug but a request for enhancement. Please change the importance, accordingly.