Summary: | Pivot Table named range does not list database ranges | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | mshiner |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | ||
Severity: | enhancement | CC: | miguelangelrv, xiscofauli |
Priority: | medium | ||
Version: | 6.4.6.2 release | ||
Hardware: | All | ||
OS: | All | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 103381 | ||
Attachments: |
Calc spreadsheet with database range
the csv file to import into the db range |
Description
mshiner
2020-10-12 12:03:06 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.) Created attachment 166322 [details]
Calc spreadsheet with database range
The database range is defined at $A$1 as listimport.
Created attachment 166323 [details]
the csv file to import into the db range
this files needs to be in ~/Downloads
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 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. (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 [Automated Action] NeedInfo-To-Unconfirmed Then this is not a bug but a request for enhancement. Please change the importance, accordingly. |