[Libreoffice-bugs] [Bug 126767] Autofill doesn't overwrite data in continuously filled cells

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Fri Aug 30 16:19:48 UTC 2019


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

--- Comment #12 from p199999991 at gmail.com ---
(In reply to p199999991 from comment #11)
> 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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190830/8274221d/attachment.html>


More information about the Libreoffice-bugs mailing list