[Libreoffice-bugs] [Bug 108209] New: Autofill overwrites data

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 108209
           Summary: Autofill overwrites data
           Product: LibreOffice
           Version: Inherited From OOo
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: critical
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: pedlino at gmail.com

Created attachment 133684
  --> https://bugs.documentfoundation.org/attachment.cgi?id=133684&action=edit
Simple spreadsheet with data to test autofill error

To autofill a column with a value/string the user can double click on the small
square on the bottom right corner of the cell selection. This should fill the
cells down as far the next/previous column or until a filled cell is reached.

LibreOffice (as did/does OpenOffice.org/AOO) ignores cells containing
values/strings and overwrites all column causing data loss.

How to replicate

1)In the attached file select cell A1 and double click on the small square on
the bottom right corner of the cell selection.

Observed: Column A is filled with letter A until cell A10 thus overwriting
information in cells A7 and A10
Expected: Column A is filled with letter A until cell A6

If Calc behaved as expected, after Step 1 selecting cell A7 and repeating the
double click should result in cells A1 to A6 containing A, cells A7 to A9
containing B and cell A10 containing C

This is what is expected based on how other spreadsheets (e.g. Gnumeric, Excel)
perform.

This was tested with LibreOffice 5.3.2.2 x64 and x86 (but also with AOO 4.1.3
and LO 3.3.4) under Windows 10 x64

-- 
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/20170528/e0c6cdbc/attachment.html>