[Bug 85170] FillAuto doesn't fill formulas in hidden columns

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=85170

--- Comment #27 from Colin <that.man.colin at gmail.com> ---
(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.