Description: Columns and rows can be grouped by selecting their headers and [F12) or Menu>Data>Group&Outline>Group. This produces a button by which the pertinent elements can be concealed or revealed. "Quick Response" buttons are created at the top left of the header locations to facilitate conceal/reveal of all groups. If the Menu>View>View Headers toggle is deactivated to hide the headers then those "Quick Reponse" buttons also disappear Steps to Reproduce: Either examine the attached sheet as per the instructions below or make your own Create Column and row groups by selecting as appropriate and pressing [F12) on the menu Play with the little "Quick Response" buttons to reveal and conceal the appropriate groups Select from the menu ribbon View>ViewHeaders and toggle to deactivate viewing of the headers Now play with the "Quick Response" buttons Actual Results: No "Quick Response" buttons Expected Results: "Quick Response" buttons to remain Reproducible: Always User Profile Reset: No Additional Info: Version: 7.4.7.2 (x64) / LibreOffice Community Build ID: 723314e595e8007d3cf785c16538505a1c878ca5 CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: sv-SE (en_GB); UI: en-GB Calc: threaded
Created attachment 188596 [details] Example Calc
(In reply to Colin from comment #0) > If the Menu>View>View Headers toggle is deactivated to hide the headers then > those "Quick Reponse" buttons also disappear The intention for hiding the row/column headers, among others, is to "gain" screen space. Those "Quick Response" buttons you mention are lined up with the headers (respectively). Are you suggesting that, when "View Headers" is OFF, then the actual row/column headers should not be displayed but the screen space should remain (just) so the "Quick Response" buttons would still be displayed? If not, please clarify.
In any case, a request for enhancement, not a bug.
(In reply to ady from comment #2) > (In reply to Colin from comment #0) > > > If the Menu>View>View Headers toggle is deactivated to hide the headers then > > those "Quick Reponse" buttons also disappear > > The intention for hiding the row/column headers, among others, is to "gain" > screen space. Those "Quick Response" buttons you mention are lined up with > the headers (respectively). One of the anomalies is that the Alpha buttons are vertical so they actually increase the header real estate and the numeric ones are horizontal so they also increase their header real estate. > Are you suggesting that, when "View Headers" is OFF, then the actual > row/column headers should not be displayed but the screen space should > remain (just) so the "Quick Response" buttons would still be displayed? If > not, please clarify. I'm suggesting that the QR buttons and the individual conceal/reveal buttons should always be visible and that the header toggle should just hide the coordinate identifiers A:XFD and 1:1048576. Clearly, the length of the coordinate ID implies the possibility of 7 activation buttons for the columns but only 3 for rows as that's the "growth" limit of their numbering system. Would it be feasible to allow the QR buttons to "overflow" the existing cell boundaries to maintain visibility and somehow monitor the creation of column/row groups to permit them to coexist? if you look at the sample I attached it does demonstrate that you could maintain a vertical button array "alongside the regular +- buttons for rows and a horizontal row above or below the existing +- buttons If they were aligned with their respective header in the existing locations then they would only take up the same header profile as the regular QR and +- buttons with the view toggle "on". Conversely if there are "many" grouped columns/rows in the existing treatment then that in itself will increase the real estate needed by the "Quick Response" buttons when the view toggle is "on". To activate them "en masse" you still have to bring headers back into view so there's not really much to be gained from concealing them in the first place.
(In reply to Colin from comment #4) > (In reply to ady from comment #2) > > (In reply to Colin from comment #0) > > > If they were aligned with their respective header in the existing locations > then they would only take up the same header profile as the regular QR and > +- buttons with the view toggle "on". Conversely if there are "many" grouped > columns/rows in the existing treatment then that in itself will increase the > real estate needed by the "Quick Response" buttons when the view toggle is > "on". Excel permits "nested" grouping so D:F can be grouped inside C:H then they have multiple layers of QR buttons which does obviate the benefit of concealing the headers. If "nesting" is feasible then I would suggest just two buttons conceal/reveal everything. If the nested columns need to be hidden again then it's just a case of activating its own - button.
(In reply to m.a.riosv from comment #3) > In any case, a request for enhancement, not a bug. agreed
I've attached a revised Calc demonstrating how nesting the grouped arrays increases the header real estate regardless of the View toggle or the nested level that is revealed It's much easier to perceive the QR buttons being aligned along their respective planes and they could possibly align with the QR button for the highest numbered array. In that manner there should always be enough "white space" between the cell boundaries and the group indicators. Even if the first columns were only a few points wide then that shouldn't cause a presentation clash as it's !"dead space".
Created attachment 188599 [details] Replacement with more nested groups
Private message from @Colin " Sorry, I have a massive crash so I'm letting it overwrite your suggestion to make it an enhancement as opposed to a bug - which I fully support. Perhaps we need a better solution for crashes - is it not possible to just queue them into place? Colin " For the crashes it's right a different report. Please test in safe mode, Menu/Help/Restart in Safe Mode
I can't confirm the problem, because I still see the grouping buttons when I hide headers in Calc Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: e26aeb882dd236adf19679d5df9b7ba5da1ed226 CPU threads: 16; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: ru-RU (ru_RU); UI: en-US Calc: CL threaded
Created attachment 188643 [details] Buttons in current 24.2 version
(In reply to Roman Kuznetsov from comment #11) > Created attachment 188643 [details] > Buttons in current 24.2 version Those are the conventional hide/reveal buttons. When you have multiple sets of grouped columns you get an override group in the far left upper corner of that ribbon with numbers. What I called "Quick Reveal" or QR If you have a single parallel layer of buttons the QRs are numbered 1 & 2 with one button revealing them all and the other hiding them all. If you have nested groups within the "outer groups" then you get an extra numbered button for each nest level. Each number will reveal up to and including its own "nest layer". you can have; I--------------------I I----------------I I----------I I---------I I-----I I------I I--I I--I and get five numbered buttons 1 operates on everything 2 operates everything up to its own level 3 operates everything up to its own level 4 operates everything up to its own level 5 operates everything up to its own level Try my attachment and youll also notice how the numbered buttons are stacked in such a manner that they increase the ribbon area. Wouldn't it make more sense for the column QR to be horizontal and the row QR to be vertical?
(In reply to Colin from comment #12) > (In reply to Roman Kuznetsov from comment #11) > Try my attachment and you'll also notice how the numbered buttons are stacked > in such a manner that they increase the ribbon area. Wouldn't it make more > sense for the column QR to be horizontal and the row QR to be vertical? Notice that the QR buttons are actually framed in the same plane as the margins being hidden which is why they disappear with "Hide Headers" If they are placed in the same ribbon space as the group buttons then notice how there's adequate space as there's always an extra plane in the margin either below or alongside the group indicators
Created attachment 188644 [details] Image showing suggested location
(In reply to Roman Kuznetsov from comment #11) > Created attachment 188643 [details] > Buttons in current 24.2 version @Roman, please set View Headers to ON and take a new screenshot; you should see the group _numeric_ buttons in the top-left corner, aligned with the row/column headers.
You will also notice from my screen grab that the numbered QR buttons always exceed the layers of grouped cells by one - thereby forcing the ribbon to use enough space to accommodate those buttons. It's the "Lord of the Buttons" with an extra button to control them all. Aligning them in the same plane as the existing buttons thereby releases the "dead space" between the grouping lines and the margin - and I reiterate; once there are layered groups then there is always available space alongside the lowest level which could accommodate the QR buttons
(In reply to ady from comment #15) > (In reply to Roman Kuznetsov from comment #11) > > Created attachment 188643 [details] > > Buttons in current 24.2 version > > @Roman, please set View Headers to ON and take a new screenshot; you should > see the group _numeric_ buttons in the top-left corner, aligned with the > row/column headers. @ady Is "group_numeric_buttons" the formal name convention for those buttons? I just utilised QR for want of an understandable definition and hoped it wouldn't be confused with QRCode terminology
(In reply to Colin from comment #17) > @ady Is "group_numeric_buttons" the formal name convention for those buttons? As you know, the feature is located in menu Data > Group and Outline. AFAIK, the "plus/minus" mini-icons are "outline symbols" and the numeric mini-icons represent "outline levels", so I would call the icons "outline level symbols". Generally speaking, the UI areas in Calc (and to some extent, in spreadsheet tools in general) are not well-known, and are not documented enough, with clear screenshots with proper (official) names (with pointing arrows to each UI feature/area). Regarding my comment 15, it was an attempt to reduce confusion (for @Roman and other readers) with brevity, using _numeric_ as opposed to _plus/minus_ miniature buttons / icons.
(In reply to ady from comment #18) > (In reply to Colin from comment #17) > > @ady Is "group_numeric_buttons" the formal name convention for those buttons? > > Generally speaking, the UI areas in Calc (and to some extent, in spreadsheet > tools in general) are not well-known, and are not documented enough, with > clear screenshots with proper (official) names (with pointing arrows to each > UI feature/area). > I couldn't agree more. Some time ago I lodged an amendment request suggesting that some method to uniquely identify all elements of the package - perhaps included in the hover over prompt - with a unique reference number so users could just quote the reference number when reporting issues or seeking online help See Bug 143700
To show the QR buttons if the header is off effectively means to put it in the first row/column, which is clearly a no-go. a) We could keep the extra space meaning to just hide the labels. b) Disable the command and always show headers if groups exist. c) Accept the user configuration since done intentionally; also with the idea that you still can show/hide groups individually The discussion around screen real estate is something different. I could imagine a "responsive" width/height depending on how many group levels are visible. My take => c), and to not put effort in saving space for multiple nested groups. Missing also a good use case that makes a change necessary.
The topic was on the agenda of the design meeting but did not receive further input. My take in comment 20 is to accept the shortcoming because it is a corner case, user-driven, and the alternatives are not acceptable. => WF (feel free to reopen, as always)