[Libreoffice-bugs] [Bug 137420] Pivot Table named range does not list database ranges
https://bugs.documentfoundation.org/show_bug.cgi?id=137420 Aron Budea changed: What|Removed |Added Blocks||103381 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=103381 [Bug 103381] [META] Pivot table (aka Data Pilot) bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 137420] Pivot Table named range does not list database ranges
https://bugs.documentfoundation.org/show_bug.cgi?id=137420 Xisco Faulí changed: What|Removed |Added Status|UNCONFIRMED |NEW Severity|normal |enhancement Ever confirmed|0 |1 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 137420] Pivot Table named range does not list database ranges
https://bugs.documentfoundation.org/show_bug.cgi?id=137420 --- Comment #8 from m.a.riosv --- Then this is not a bug but a request for enhancement. Please change the importance, accordingly. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 137420] Pivot Table named range does not list database ranges
https://bugs.documentfoundation.org/show_bug.cgi?id=137420 QA Administrators changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 137420] Pivot Table named range does not list database ranges
https://bugs.documentfoundation.org/show_bug.cgi?id=137420 --- Comment #7 from QA Administrators --- [Automated Action] NeedInfo-To-Unconfirmed -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 137420] Pivot Table named range does not list database ranges
https://bugs.documentfoundation.org/show_bug.cgi?id=137420 --- Comment #6 from mshi...@uzerp.com --- (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 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 137420] Pivot Table named range does not list database ranges
https://bugs.documentfoundation.org/show_bug.cgi?id=137420 m.a.riosv changed: What|Removed |Added Ever confirmed|0 |1 CC||miguelangelrv@libreoffice.o ||rg Status|UNCONFIRMED |NEEDINFO --- Comment #5 from m.a.riosv --- 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. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 137420] Pivot Table named range does not list database ranges
https://bugs.documentfoundation.org/show_bug.cgi?id=137420 mshi...@uzerp.com changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 --- Comment #4 from mshi...@uzerp.com --- 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 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 137420] Pivot Table named range does not list database ranges
https://bugs.documentfoundation.org/show_bug.cgi?id=137420 --- Comment #3 from mshi...@uzerp.com --- Created attachment 166323 --> https://bugs.documentfoundation.org/attachment.cgi?id=166323=edit the csv file to import into the db range this files needs to be in ~/Downloads -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 137420] Pivot Table named range does not list database ranges
https://bugs.documentfoundation.org/show_bug.cgi?id=137420 --- Comment #2 from mshi...@uzerp.com --- Created attachment 166322 --> https://bugs.documentfoundation.org/attachment.cgi?id=166322=edit Calc spreadsheet with database range The database range is defined at $A$1 as listimport. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 137420] Pivot Table named range does not list database ranges
https://bugs.documentfoundation.org/show_bug.cgi?id=137420 Xisco Faulí changed: What|Removed |Added Ever confirmed|0 |1 CC||xiscofa...@libreoffice.org Status|UNCONFIRMED |NEEDINFO --- Comment #1 from Xisco Faulí --- 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.) -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs