Bug 105275 - No option to create a new pivot table in LibreOffice 5.2.4.2 on Ubuntu
Summary: No option to create a new pivot table in LibreOffice 5.2.4.2 on Ubuntu
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.2.4.2 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-01-12 06:54 UTC by grofaty
Modified: 2017-01-13 06:26 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
libreoffice-PPA_Ubuntu.png (106.54 KB, image/png)
2017-01-12 06:54 UTC, grofaty 		Details
libreoffice-PPA_Ubuntu.png (106.54 KB, image/png)
2017-01-12 06:55 UTC, grofaty 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description grofaty 2017-01-12 06:54:28 UTC 
Created attachment 130341 [details]
libreoffice-PPA_Ubuntu.png

I was trying to reproduce a bug 105254 related to Pivot Table on LibreOffice/Windows, but I see I can't even create a pivot table in LibreOffice/Ubuntu.

I did the following:
1. Open LibreOffice Calc.
2. In fields type in:
A1: Name
A2: Alice
A3: Bob
A4: Connie
B1: Size
B2: 170
B3: 180
B4: 160
3. Select fields from A1:B4.
4. Data | Pivot Data and what I see there are only two options "Refresh" and "Delete" and both are greyed out.

I expected to see "Data | Pivot Table | Pivot Table" like it is on LibreOffice 5.2.4.2 on Windows 7 SP1.
Comment 1 grofaty 2017-01-12 06:55:43 UTC 
Created attachment 130342 [details]
libreoffice-PPA_Ubuntu.png
Comment 2 grofaty 2017-01-12 06:58:18 UTC 
I have added two attachment:
1. File: libreoffice-PPA_Ubuntu.png print screen no "Pivot table" menu option available.
2. File: libreoffice-PPA_Ubuntu.png print screen of the LibreOffice PPA.

This problem may be related only to Linux or maybe even only to Ubuntu.
I tested this problem on LibreOffice 5.2.4.2 using PPA on Ubuntu 16.04.
Comment 3 Xisco Faulí 2017-01-12 08:58:26 UTC 
This is weird, as LibreOffice 5.2.5.2 hasn't been released yet.
Could you please copy the information from Help - About LibreOffice ?
Comment 4 grofaty 2017-01-12 09:35:52 UTC 
@Xisco, sorry for confusing I made a typo in bug title. I've fixed the title.
Comment 5 Maxim Monastirsky 2017-01-12 09:50:01 UTC 
This item was moved in 5.2 to a different menu. Now it's Insert > Pivot Table...

(In reply to grofaty from comment #0)
> I expected to see "Data | Pivot Table | Pivot Table" like it is on
> LibreOffice 5.2.4.2 on Windows 7 SP1.
It shouldn't be there by default. I guess under Windows you have some pre-5.2 user profile with a customized menubar...
Comment 6 Kevin Suo 2017-01-12 09:54:46 UTC 
It should be in: Insert -> Pivot Table.

There was a change in the UI menu in 5.2 so the "Create" menu entry was missing in your version. 

In master and version 5.3 you will see that the "Create" menu entry is back again.
Comment 7 grofaty 2017-01-13 06:26:44 UTC 
I can confirm that in Ubuntu it exists Inset | Pivot Table. Also on Windows I can confirm if I rename the profile I can see the same menu structure as on Ubuntu. I have also installed master version and I see Data | Pivot Table | Create is back again. Nice.

I didn't know menu structure is also saved in profile. Sorry for the false positive report. 
Regards