<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Autofill overwrites data"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=108209">108209</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Autofill overwrites data
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>Inherited From OOo
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>critical
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>pedlino@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=133684" name="attach_133684" title="Simple spreadsheet with data to test autofill error">attachment 133684</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=133684&action=edit" title="Simple spreadsheet with data to test autofill error">[details]</a></span>
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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>