https://bugs.documentfoundation.org/show_bug.cgi?id=85170
--- Comment #27 from Colin <[email protected]> --- (In reply to Buovjaga from comment #26) > Bug 137774 comment 4 says > > (In reply to Justin L from comment #4) > > I would consider autofill affecting hidden rows as a bug it if were to > > happen. It very intentionally does not work that way. See bug 113785. > > So let's show this to Justin as well. I can't envisage anybody working with an array that DOESN'T include formulae - they use a school note book for that. How destructive would it be if a user selected a part of the array that contained the formulae, changed one cell formula and filled down using any method available in a spreadsheet. I can just imagine how far the next Mars transit would get if half the fuel calculations were still in metric and not updated when NASA realised that the USA utilises imperial measurements and only changed the METRIC formulae on SOME of the calculations. Perhaps you could give a use case where you WOULDN'T want all the formulae to be identical for the same task. If somebody hides descriptive text rows because they're in the way then they probably didn't really need the text rows in the first place. If they have produced their work flow around hidden text rows and don't have the mouse to correctly select the area for formulaic change then they should probably stick to a school note book. Perhaps somebody should thoroughly investigate and update OASIS to fit into the new era. -- You are receiving this mail because: You are on the CC list for the bug.
