[Libreoffice-bugs] [Bug 134293] New: Inconsistent double-click AutoFill behavior

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 134293
           Summary: Inconsistent double-click AutoFill behavior
           Product: LibreOffice
           Version: 6.3.6.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: minor
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: contradictious.one at gmail.com

Description:
Double-click AutoFill behavior is inconsistent (and probably incorrect in some
cases) when some rows are hidden.

Steps to Reproduce:
1. Enter random data into the column A.
2. Add data to some rows in the column B.
3. Hide rows with data (and a few without) in the column B.
4. Put data into the column B in the cell right above any hidden row(s).
5. Double-click the handle.
6. Repeat with different cells (that are right above hidden rows).

Actual Results:
Depending on hidden cells in the column B, results may wary:
1. If hidden cell below the "origin" cell is empty, expected behavior is
observed - visible cells are filled down to last row with data in the column A.
2. If hidden cell below the "origin" cell is not empty, and the first visible
cell after the hidden row(s) is not empty, expected behavior is observed - all
consecutive non-empty cells are filled down.
3. If hidden cell below the "origin" cell is not empty, but the one after it is
empty, AutoFill fails.
4. If there are two hidden cells below "origin" cell that are not empty,
different behavior is observed - AutoFill works, but ignores the column A, and
fills cells down to bottom of the sheet (could be resource heavy).

Expected Results:
AutoFill should work on all visible cells the same way it works on cells if
there are no hidden rows.


Reproducible: Always


User Profile Reset: No



Additional Info:
Notice that problem occurs when a hidden cell right below the "origin" cell has
data.

-- 
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/20200625/ecdc83ee/attachment.htm>