Bug 160750 - PivotTable expand/show buttons overlap with row title/header
Summary: PivotTable expand/show buttons overlap with row title/header
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.2.1.2 release
Hardware: All All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Pivot-Table
  Show dependency treegraph
 
Reported: 2024-04-20 17:27 UTC by Alex
Modified: 2024-04-21 05:36 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Screenshot of issue (41.34 KB, image/png)
2024-04-20 17:27 UTC, Alex
Details
Sample Workbook with issue (14.83 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2024-04-21 00:24 UTC, Alex
Details

Note You need to log in before you can comment on or make changes to this bug.
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.