[Issue 127578] New: Autofill overwrites data

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=127578

          Issue ID: 127578
        Issue Type: DEFECT
           Summary: Autofill overwrites data
           Product: Calc
           Version: 4.1.3
          Hardware: All
                OS: All
            Status: CONFIRMED
          Severity: Major
          Priority: P5 (lowest)
         Component: editing
          Assignee: issues@openoffice.apache.org
          Reporter: pedlino@gmail.com
  Target Milestone: ---

Created attachment 86245
  --> https://bz.apache.org/ooo/attachment.cgi?id=86245&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 as the next/previous column or until a filled cell is
reached.

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 AOO 4.2.0 Rev 1813467 (but also with 4.1.4 and 4.1.3)
under Windows 10 x64 and Windows 7 x64

-- 
You are receiving this mail because:
You are the assignee for the issue.