Bug 141410

Description:
Hi

I am using Calc 7.1.1.2 (x64) Windows version of Libre Office. I have a .XLSX file (Excel 2007-365 format) that I created using Libre Office from scratch (not imported from Excel or anything).

I have created a simple pivot table in the below format.

Month   Sales     % of Sales

Jan        10           20%

Feb        15           30%

Mar        25           50%

Total      50          100%

The 2nd and 3rd column in the above table both are sourced from a single column called Sales. The 2nd column has "Sum" function. The 3rd column also has "Sum" function applied, but in the displayed value I have chosen type as "% of Total".

The problem is that the "% of Total" type in the Displayed Value setting doesn't persist forever. When I save the spreadsheet, close and again reopen it, the "% of Total" setting is gone. It reverts back to just normal "Sum" settings only. So both the columns above just show the "Sum" only. When I close and reopen it, it shows like below.

Month   Sales     % of Sales

Jan        10           10

Feb        15           15

Mar        25           25

Total      50           50

Can you please help fix this issue. I have had this issue through version 6 and version 7 so far. I keep upgrading to latest versions hoping that this would be fixed and it hasn't been so far.

Thanks.

Steps to Reproduce:
1. Create a new spreadsheet and save it in .XLSX file (Excel 2007-365 format).
2. Type the below values in sheet in 2 columns along with their titles.

Month   Sales     
Jan        5
Jan        5
Feb        10
Feb        5
Mar        5
Mar        10
Mar        10

3. Create Pivot Table from the above data. 
   a. The Month should be Row Fields.
   b. The Sales field should be in Data Fields.
   c. Select Data field 2 times and drop it in the Data Fields Section.
   d. Double click on Sales field (1st occurrence) and Choose the Function Sum. Click OK.
   e. Double click on Sales field (2nd occurrence) and Choose the Function Sum again.
   d. Expand the Displayed Value Option and Choose "% of Total" from Type Drop Down. Click OK.

3. Save the Spreadsheet and Close it.

4. Reopen it and examine the Pivot Table.

Actual Results:
Month   Sales     % of Sales

Jan        10           10

Feb        15           15

Mar        25           25

Total      50           50


Expected Results:
Month   Sales     % of Sales

Jan        10           20%

Feb        15           30%

Mar        25           50%

Total      50          100%



Reproducible: Always


User Profile Reset: Yes



Additional Info:
This problem will happen even if you had only one field and you selected % of Total for that field and XLSX format for saving the file.

Choosing the same field twice and displaying Sum for one field and displaying % of Total for the second field is NOT the trigger/prerequisite for this issue. 

This is simply the % of Total Setting not getting saved/perpetuated and getting lost once closed and then reopened again.