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
The option compact layout was introduced with https://gerrit.libreoffice.org/c/core/+/151057 (without discussion on BZ). Not sure that everyone wants this, so A is not my favorite. But it's true that expander without drill make no sense and some dependency is needed. Indentation and a disabled state sound appropriate to me.
+1 -- an indentation *and* a disabled state
We discussed the topic in the design meeting. There is no objection to the improved feedback. The ui is defined in sc/uiconfig/scalc/ui/pivottablelayoutdialog.ui, to conditionally enable the checkbox a few lines of code in sc/source/ui/dbgui/PivotLayoutDialog.cxx are required.