User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:44.0) Gecko/20100101 Firefox/44.0 Build Identifier: LibreOffice 5.1.1.2 Hello. I have noticed I cannot create pivot table with the version of LO Calc (5.1.1.2) that is running on my Linux Mint. I first thought I did not know of a designed feature that was preventing me from creating pivot tables but I also tried with sample files used in tutorials about pivot tables, so with which I should normally be able to create a pivot table easily. Since my computer has a dual-boot with also Windows 7 installed on it, I booted Windows and opened the same files with installed version of LO (5.0.5.2) and to my surprise I was able to create pivot tables with the same files and the same data ! I suppose this is a bug in LO Calc 5.1.1.2, a quite annoying one. The version of LO I am running is the default version in the Linux Mint 17.1 depots. Reproducible: Always Steps to Reproduce: 1. Take a file with data tables (provided two with which I found the problem). 2. click on any cell of a data table (examples : cell H7 of sheet 'U1+U2' for file 'Parc machines et Bilan production ALPEN TECH.ods' and cell C4 of sheet 'SourceData' for file 'Stooge.ods') 3.In the main menu, select Data > Pivot table. Actual Results: The list of options in Data > Pivot table only includes two items ('Delete' and 'Refresh'). No option 'Create' is offered. Expected Results: Shoud show the 'Create' option. Or did I miss something ? [Information automatically included from LibreOffice] Locale: en-US Module: StartModule [Information guessed from browser] OS: Linux (All) OS is 64bit: yes Reset User Profile?No
Created attachment 123226 [details] File downloaded from a tutotial for Pivot table in LO
Created attachment 123227 [details] My first file.
Hello, it's in menu Insert> Pivot table or you can use button on toolbar.