Description: In Calc, I make a simple spreadsheet, select two columns, and do Data -> Define Range. I give it a name. I then do Data -> Pivot Table. The "Named range" option is always grayed out. Steps to Reproduce: See description. Actual Results: Named Range grayed out Expected Results: Named Range active, I can select one. Reproducible: Always User Profile Reset: No Additional Info: User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:52.0) Gecko/20100101 Firefox/52.0
Hello David, 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 132741 [details] test file Test case. But the data is trivial, it's the actions that show the bug.
Test with 5.2.6 on Windows Vista. Confirmed when a *database* range is created. (Data > Define range) Works when a *named range* is created whith Insert > Named expression or range. I'm not sure this is the normal behavior...
Confirming on Version: 5.3.2.2 Build ID: 6cd4f1ef626f15116896b1d8e1398b56da0d0ee1 Threads CPU : 8; Version de l'OS :Mac OS X 10.12.4; UI Render : par défaut; Moteur de mise en page : nouveau; Locale : fr-FR (fr_FR.UTF-8); Calc: group following steps in original report with test file.
Reproduced in Version: 5.1.6.2 Build ID: 07ac168c60a517dba0f0d7bc7540f5afa45f0909 Threads CPU : 8; Version de l'OS :Mac OS X 10.12.4; UI Render : par défaut; Locale : fr-FR (fr_FR.UTF-8); Calc: group
Also reproduced in Version 3.6.7.2 (Build ID: e183d5b) OSX 10.12.4
There is no corresponding entry in the OOo321 data pilot, so I am assuming that this was only made available after LibreOffice 330 release.
Reproduced also with Version: 4.1.6.2 Build ID: 40ff705089295be5be0aae9b15123f687c05b0a The entry is there, but greyed out.
*** This bug has been marked as a duplicate of bug 37268 ***