[Libreoffice-bugs] [Bug 130215] New: Upper/lower case and autofill problem

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 130215
           Summary: Upper/lower case and autofill problem
           Product: LibreOffice
           Version: 6.0.0.3 release
          Hardware: x86-64 (AMD64)
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: themightyloki at free.fr

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

-- 
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/20200127/f0d1c79b/attachment.htm>