Bug 160750

Summary: PivotTable expand/show buttons overlap with row title/header
Product: LibreOffice Reporter: Alex <aseguin012>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: minor CC: dennisfrancis.in, miguelangelrv, raal
Priority: medium    
Version: 24.2.1.2 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 103381    
Attachments: Screenshot of issue
Sample Workbook with issue

Description Alex 2024-04-20 17:27:36 UTC
Created attachment 193770 [details]
Screenshot of issue

When copying xlsx files containing a pivot table, the expand/collapse buttons overlap with the row headers.

To re-create: 
1. create a xlsx file with a PivotTable and sample data. Ensure there are more than one Row fields and enable the "show expand/collapse buttons" under Options.

2. Use Python and openpyxl to load the workbook and save a new copy.

3. Open the copy in LibreOffice Calc, and observe that the expand/collapse buttons and the row heads overlap.

4. The issues persists despite deleting the PivotTable and creating an new one, on disabling and re-enabling the expand/collapse button.

Expected behavior: 
There should be padding around the expand/collapse button, so the row header text starts to the right of the button.
Comment 1 m_a_riosv 2024-04-20 21:54:19 UTC
Please attach a sample file, reduce the size as much as possible without private information, and paste the information in Menu/Help/About LibreOffice, there is a copy icon.
Comment 2 Alex 2024-04-21 00:24:00 UTC
Created attachment 193779 [details]
Sample Workbook with issue
Comment 3 Alex 2024-04-21 00:24:32 UTC
(In reply to m_a_riosv from comment #1)
> Please attach a sample file, reduce the size as much as possible without
> private information, and paste the information in Menu/Help/About
> LibreOffice, there is a copy icon.

Ok, I added a workbook with the described issue as an attachement.
Comment 4 raal 2024-04-21 05:36:44 UTC
Confirm with Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 8df17c340193c89549d8c563b04d015156afa3fb
CPU threads: 4; OS: Linux 6.5; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded Jumbo


Adding Dennis Francis to CC. He implemented this feature in 2f8d10b0b9baa03b8a713e9fd1342fe6c8094fb4.