Bug 163238 - Calc doesn't retain Pivot Table Layout|Properties|Options|Total rows setting
Summary: Calc doesn't retain Pivot Table Layout|Properties|Options|Total rows setting
Status: RESOLVED DUPLICATE of bug 141410
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-10-01 17:37 UTC by zsjeff
Modified: 2024-10-02 16:12 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
XLSX example of the bug. (9.84 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2024-10-02 16:04 UTC, zsjeff 		Details
ODS version of the same XLSX file. (11.87 KB, application/vnd.oasis.opendocument.spreadsheet)
2024-10-02 16:09 UTC, zsjeff 		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 zsjeff 2024-10-01 17:37:30 UTC 
Description:
When I unclick the Pivot Table Layout|Properties|Options|Total rows setting, rows are no longer totaled, which is what I expect. But if I close the worksheet and then reopen it, the Total rows setting is turned back on.

Steps to Reproduce:
1. Unclick the Pivot Table Layout|Properties|Options|Total rows setting
2. Close the worksheet and reopen.
3. The Pivot Table Layout|Properties|Options|Total rows setting has been turned back on.

Actual Results:
The Total rows setting is on.

Expected Results:
Since I unclicked the Total rows setting, it should still be unclicked.


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 24.8.2.1 (X86_64) / LibreOffice Community
Build ID: 0f794b6e29741098670a3b95d60478a65d05ef13
CPU threads: 8; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
Comment 1 m_a_riosv 2024-10-02 15:48:41 UTC 
Please attach a sample file, reduce the size as much as possible without private information.
Comment 2 zsjeff 2024-10-02 16:04:03 UTC 
Created attachment 196844 [details]
XLSX example of the bug.
Comment 3 zsjeff 2024-10-02 16:09:53 UTC 
Created attachment 196845 [details]
ODS version of the same XLSX file.

I decided to try saving the file as an OSD file, and the bug is not present. In the ODS file, if you turn off Total rows, save and close and reopen the file, the option is preserved, and rows are not totaled. Do the same thing in the XLSX file, and the option reverts back to totaling rows.
Comment 4 m_a_riosv 2024-10-02 16:12:55 UTC 

*** This bug has been marked as a duplicate of bug 141410 ***