Bug 166344 - Pivot tables loses FORMATTING setting for no column or row totals even after saving file
Summary: Pivot tables loses FORMATTING setting for no column or row totals even after ...
Status: NEEDINFO
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.8.6.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-04-25 18:45 UTC by Ronald Sonntag
Modified: 2025-09-08 14:55 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Ronald Sonntag 2025-04-25 18:45:57 UTC
Description:
1. Create a pivot table
2. Right-click on any cell and select Properties
3. Expand the Options at bottom of dialog
4. Uncheck Total columns and Total rows
5. Save file
6. Open file
7. Go to Pivot table, row and column totals are back

Steps to Reproduce:
1.See above description
2.
3.

Actual Results:
See above description

Expected Results:
The total row and columns should not have reappeared.


Reproducible: Always


User Profile Reset: No

Additional Info:
LibreOffice also seems to be missing a robust Python API that allows an external Python program to manage pivot table formatting. The UNO interface is extremely fragile and I have not been able to get it to work through an external python script. Only an internal macro works and I haven't found a reliable way to execute that macro from an external invocation of headless Calc.
Comment 1 m_a_riosv 2025-04-25 22:50:44 UTC
What file format do you use to save?

Please attach a sample file.


About Python, seems you are asking for help
https://help.libreoffice.org/latest/en-US/text/sbasic/python/main0000.html?&DbPAR=SHARED&System=WIN

There are a lot of questions about python in
https://ask.libreoffice.org/c/english/5/l/latest
Comment 2 Piotr Osada 2025-09-08 14:55:20 UTC
Not reproduced in:

Version: 25.8.1.1 (X86_64)
Build ID: 54047653041915e595ad4e45cccea684809c77b5
CPU threads: 16; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Raster; VCL: win
Locale: pl-PL (pl_PL); UI: en-US
Calc: CL threaded

'Show totals row' does not show after file save and LO restart.