Created attachment 86245 [details]
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