<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - Autofill doesn't overwrite data in continuously filled cells" href="https://bugs.documentfoundation.org/show_bug.cgi?id=126767#c12">Comment # 12</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - Autofill doesn't overwrite data in continuously filled cells" href="https://bugs.documentfoundation.org/show_bug.cgi?id=126767">bug 126767</a> from <a class="email" href="mailto:p199999991@gmail.com" title="p199999991@gmail.com">p199999991@gmail.com</a> <pre>(In reply to p199999991 from <a href="show_bug.cgi?id=126767#c11">comment #11</a>) > The old Excel's behaviour (I'm not sure what they did to enhance it in 2013 > and later) is: > In each column, beginning with just below the selection, we count the number > of cells until it changes from empty to non-empty or vice versa (0 if not > found*). > Let x be the minimum of the above list of numbers. > Let y = x if x>0, otherwise y = max of the number of consecutive non-empty > cells for the adjacent columns. > Fill down y more rows below the selection. I forgot to mention that we can make it even better by ignoring the 0's in the list.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>