[Libreoffice-bugs] [Bug 141410] New: Calc Pivot Table "% of Total" Display Value Setting not getting saved permanently for .XLSX format files

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=141410

            Bug ID: 141410
           Summary: Calc Pivot Table "% of Total" Display Value Setting
                    not getting saved permanently for .XLSX format files
           Product: LibreOffice
           Version: 6.3 all versions
          Hardware: Other
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: rsreeny at yahoo.com

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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210331/bc14c266/attachment.htm>