https://bugs.documentfoundation.org/show_bug.cgi?id=56799
--- Comment #29 from Colin <[email protected]> --- (In reply to vic from comment #28) > Hi Colin, > > I have the same procedure and found a reasonable compromise: > > Instead of grouping and hiding, I now select the rows or cells I would like > > to hide and redefine them as 1 pixel wide or deep. > > I've seen this suggestion too on other pages, but I find it very cumbersome > (slow to do /undo ; I'd have to choose a good hight/width depending on nr of > rows/cols to hide - or else if put just 0 then it looks like Hidden and easy > to forget about... ) > Hi vic, I think I could have been a little more specific; I rarely need to expand the columns because they are mostly helper column formulae that I won't be changing this century but they must be included in fill-downs, so leaving them as 1 pixel ensures they copy and also provides the partial overflow arrrow visual indication that there are indeed "active" cells in the array I only have grouped rows in the "header/dashboard" to maximise the onscreen data area. Like you, I prefer to have the simple control and absolute indication of rarely touched rows Like you, any real content in grouped columns is already a lesson learned - ensure I expand everything relevant before breaking it ;) -- You are receiving this mail because: You are the assignee for the bug.
