https://bugs.documentfoundation.org/show_bug.cgi?id=161166
Bug ID: 161166
Summary: show column and row totals option not saved to .xlsx
format file
Product: LibreOffice
Version: unspecified
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: paul.cl...@gmx.co.uk
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!
--
You are receiving this mail because:
You are the assignee for the bug.
