https://bugs.documentfoundation.org/show_bug.cgi?id=137774
--- Comment #7 from vic <[email protected]> --- Reproduced ; not only with Hide feature but also with Group feature Version: 25.2.5.2 (X86_64) / LibreOffice Community Build ID: 03d19516eb2e1dd5d4ccd751a0d6f35f35e08022 CPU threads: 2; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded 1) is Hide and Group supposed to work the same, except for the obvious visual appearance (handles "+"/"-"..) ? 2) I agree that this needs to be fixed. I use Grouping mostly just because there are too many rows/ cols of same type (ex, hundreds of them!) and need to hide out of the way, but this does not mean autofill (either double click or drag the corner ) should not work on them. Proposed workaround (setting the width/height of cells to be 0.00..1) is very cumbersome. Apparently, some people like the current behaviour. Options for fixing: o1. Have 2 distinct kinds of grouping or hiding: independently accessible - one for hiding from view only; but autofill still works on them - one for hiding from calculations, Maybe Grouping - for hide out of view, and Hiding - for hiding from calculations? o2. Pop-up a dialog at autofill to ask user whether to also work with the hidden rows/cells o3. Allow a preference option for the user to choose one vs other behaviour. -- You are receiving this mail because: You are the assignee for the bug.
