<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 - Upper/lower case and autofill problem"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=130215">130215</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Upper/lower case and autofill problem
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.0.0.3 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</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>themightyloki@free.fr
</td>
</tr></table>
<p>
<div>
<pre>Description:
In Calc, Autofill does not allow to edit the letter case of a cell if another
cell with the same text exists.
Also, autofill won't use the suggested content when editing cells containing
multiple versions of the same text only differentiated by the letter case.
Steps to Reproduce:
1. Open a new sheet in Calc
2. In cell A1 and A2 enter "banana peel"
3. Try to edit cell A2 to enter "Banana peel" => it gets replaced by "banana
peel"
4. Play around by entering things like "banana Peel" or "Banana Peel" in cells
A3 and A4, then try to edit the letter case in any of A1-A4 cells. Notice how
sometimes autofill suggests a replacement but does not use it (ie it suggests
"Banana Peel" but will fill the cell with "banana peel" if you press enter or
an arrow key)
5. After some time of editing, you might lose ALL case variations and end up
with cells A1-A4 all containing the same text...
Actual Results:
Autofill completely messes up the cell contents.
Expected Results:
Autofill should use the text it itself suggests to be inserted ! What you see
should be what you get ! ^_^
Manual editing should get the priority other autofill when the cell content
already exists in the sheet, to allow creating cells with same text BUT
different letter case.
Reproducible: Always
User Profile Reset: No
Additional Info:
Has been happening in Windows and Linux for years...
Current version I use is :
Version: 6.2.8.2
Build ID: 1:6.2.8~rc2-0ubuntu0.18.04.1
Threads CPU : 4; OS : Linux 5.3; UI Render : par défaut; VCL: gtk3;
Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR
Calc: threaded</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>