https://bugs.documentfoundation.org/show_bug.cgi?id=165270

            Bug ID: 165270
           Summary: Relationship between "Show expand/collapse buttons"
                    and "Enable drill to details" options in pivot table
                    is unclear
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

In the pivot table layout dialog's "Options" expander, there are things
including:

1. Enable drill to details
2. Show expand/collapse buttons

It turns out that they affect each other, but that relationship is never made
explicit in the UI. If you disable "Enable drill to details" (I don't know why
you would actually want to do that), the expand/collapse buttons do not work
even if they are shown.


My main recommendation (approach A) would be to merge the two settings into
only one: either you show the expand/collapse buttons when you want this thing
to be drillable/collapsible, or you don't.

Failing that, if you really want to preserve the ability to enable/disable
drilling, then approach B would be:

* Expansion/collapse "+"/"-" buttons should not be shown in the spreadsheet
when drilling is disabled (because you can't interact with them anyway)

* The "Show expand/collapse buttons" checkbox should be marked as insensitive
in that dialog as soon as the user unchecks "Enable drill to details".

As you can imagine, I'd much prefer approach A.

---

Observed on 

Version: 25.2.0.3 (X86_64) / LibreOffice Community
Build ID: e1cf4a87eb02d755bce1a01209907ea5ddc8f069
CPU threads: 8; OS: Linux 6.12; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Flatpak
Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to