Bug 161166 - show column and row totals option not saved to .xlsx format file
Summary: show column and row totals option not saved to .xlsx format file
Status: RESOLVED DUPLICATE of bug 122469
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-05-18 16:48 UTC by Paul Cluse
Modified: 2024-05-19 02:53 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
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 Paul Cluse 2024-05-18 16:48:36 UTC 
Version Info from Calc Help about:
Version: 7.3.7.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-GB (en_GB.UTF-8); UI: en-US
Ubuntu package version: 1:7.3.7-0ubuntu0.22.04.4
Calc: threaded

Change to turn off pivot table column and row totals lost when saved as .xlsx and then reopened. Works correctly if saved as .ods format.

To Reproduce:
Using spreadsheet with pivot table saved in .xlsx format. Turn off column and row totals.
Total turned off by: right click on pivot table. select properties..
select options.
uncheck Total Columns and/or Total Rows. and hit OK. Totals are correctly removed.
Save (as .xlsx). Close.
Reopen .xlsx format sheet and the pivot table row and column totals are shown again.

My first bug posting so hope it ok!
Comment 1 m_a_riosv 2024-05-18 16:50:34 UTC 
Please attach a sample file.
Comment 2 m_a_riosv 2024-05-18 16:53:50 UTC 

*** This bug has been marked as a duplicate of bug 122469 ***
Comment 3 Paul Cluse 2024-05-18 17:18:58 UTC 
You are correct its the same scenario as described in 122469.
Do you still need a sample file?
Comment 4 m_a_riosv 2024-05-19 02:53:44 UTC 
I think no, there is a sample file on tdf@122469.

But if you want, add there your comment and your sample file.