https://bugs.documentfoundation.org/show_bug.cgi?id=134293
--- Comment #10 from Dmitry T. <[email protected]> --- @Buovjaga Oops, was planning to respond, but it slipped my mind at some point, sorry. Just checked on LO 7.1.6.2, the test case file gives me the same result as in comment #1. I also had a chance to check out behavior of AutoFill in Excel 2019 (build 2110), turns out it's not affected by hidden rows at all. If we go by comment #1's steps, at step 3 AutoFill will set cells B11/B14 and stop, and at step 5 it will set both B18 and B19, and stop. In LO, on the other hand, AutoFill does not set hidden cells. Actually, turns out there is also a problem with manually filling cells by dragging the handle across the hidden row - in Excel it sets hidden cells, but in LO they remain unchanged. So, the question we first need to answer is, which behavior is actually expected - should hidden cells be filled (as they do in Excel), considered a stop (as cells B11/B14 do in LO) or ignored completely (as cells B18 and B19 do in LO (but in such case AutoFill should honor the neighboring columns))? -- You are receiving this mail because: You are the assignee for the bug.
