Description: Bug #128258 implemented a way to actually notice that there are hidden rows/columns without needing an eagle's eye. Bug #147301 disabled it by default. However, the existence of this toggleable option can only be discovered if using the traditional user interface (or turning on the full menubar). It is not available in any toolbars or menubutton when running any of these UI layout types: * Tabbed * Tabbed Compact * Groupedbar Compact It should ideally be available as a button in the View group (if available space allows), or at least present in the menubutton. It could also benefit from being available as a checkbox/toggle menu item in the right-click menu in spreadsheet headers, next to the actions to hide/show rows/columns. Actual Results: Expected Results: Reproducible: Always User Profile Reset: No Additional Info:
Also: I would suggest that this option be enabled by default, rather than disabled by default; I believe users who have so many hidden non-adjacent rows or columns are a minority, who would be easily able to turn off the feature (if it was clearly exposed in the tabbed, tabbed compact, and groupedbar compact UIs), and that the benefits of turning this on by default would be greater for the majority of people. That said, while this is my suggestion from a HCI point of view, but it's not a hill I'm willing to die on.
Thank you Jeff. Confirmed that it is missing in: Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 579d144290c1617fdb38d09b30900a6bbe390b8d CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded With Tabbed UI.
The fact that columns numbers/letters are missing is a pretty telling indicator all by itself that rows are missing. This is such an exotic, little used item that it does not deserve to waste any precious space on the notebookbar/menus.