Bug 85090 - Autocorrect always capitalizes small "i" in a cell
Summary: Autocorrect always capitalizes small "i" in a cell
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Linguistic (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2014-10-16 13:48 UTC by Yerlan
Modified: 2015-08-16 18:00 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Yerlan 2014-10-16 13:48:55 UTC
Since autocorrect changes small i into capital I when typed individually, it makes it impossible to type a small i into a cell.
I tried many options, like typing a space before or after the letter, then typing double ii then deleting one, nothing helps.

The problem is also the capital I is not always visually distinct from small i, so it lead me to a hard to find bug in my spreadsheet.

There should be a way to override autocorrect in a cell without disabling it globally.
Comment 1 tommy27 2014-10-16 18:19:15 UTC
it reminds me Bug 76964 - Automatic capitalization of "i" in a non-english language

please give details about your O/S, LibO versione and language localization.
do you experience the same issue on Writer documents as well or just in Calc cells?
Comment 2 Yerlan 2014-10-16 20:10:04 UTC
Right now I am using Windows 10 Preview 64-bit (English).
LibreOffice is version
It is true that I changed the interface language to Kazakh (kk).

However, I think I had this same problem on Ubuntu 14.04 LTS 64-bit English with LibreOffice 4.2 English that I had a couple of weeks ago.

Tomorrow I will install Ubuntu again and will confirm it.

Regarding Writer. I just tried setting document language to English and yes, autocorrection kicks in and capitalizes i. But this is OK. In Writer, you can at least do something about it. I get around it by typing an additional space, then press left arrow, type i, and then press right arrow. This works because autocorrection gets triggered by Enter or non-word character.
The problem in Calc is that the trigger is leaving a cell by any method, i.e. Enter, arrow button, mouse click, so the small i is always capitalized.
Comment 3 tommy27 2014-10-17 04:15:46 UTC
I don't see this bug under Win7x64 using LibO with italian localization.
I can type "i" in any Calc cell and no autocapitalization or autocorrection happens. may be Linux specific issue.
Comment 4 tommy27 2014-10-17 08:55:36 UTC
@ b1990994@gmail.com

I see you changed status to NEW and platform to ALL.
please drop a comment here describing which version and O/S do you reproduce the bug. unless we have a clear statement about that I have to revert status to UNCONFIRMED
Comment 5 Yerlan 2014-10-17 09:38:17 UTC
I installed Ubuntu 14.04 LTS 64-bit English with LibreOffice English and I was able to reproduce it.

However, to reliably reproduce this you need to set locale and default language for documents to English (USA).
If you just change the language of a few cells, it will not work.

Just to clarify a bit more. Capitalization of i in English language is an expected behavior and I believe it's a useful feature for many people.

The problem is just in Calc that there's no means to override it because as I explained in my previous comment, the trigger for autocorrection is leaving a cell no matter which way you do it.
Comment 6 tommy27 2014-10-17 09:51:48 UTC
Ok, thanks for the further informations. I set version to which is the earliest release where you reproduced the bug.
Comment 7 Yerlan 2014-10-22 17:41:00 UTC
Changed the status to New as nobody does it.
I guess, the issue is easily reproducible by any one.
Comment 8 tommy27 2014-10-22 17:55:01 UTC
I revert status to UNCONFIRMED
You cannot set as NEW your own bugs unless you have an independent confirmation by another user which has not happened yet
Comment 9 A (Andy) 2014-10-24 19:24:06 UTC
Reproducible with LO (Win 8.1)

Steps to Reproduce:
1. Open CALC and create a new spreadsheet
2. Select all cells (e. g. CTRL + A)
3. Go to FORMAT -> CELLS -> tab FONT
4. In the field LANGUAGE select "English (UK)"
5. Go to any cell and type "i" and press the Enter key

"i" gets "I" -> it is not possible to simply write a small "i" in a cell
Comment 10 tommy27 2014-10-24 19:56:39 UTC
I think there's a workaround using wildcard autocorrection...

click "Tools/Autocorrect Options/Autocorrect/replace"

scroll the English(UK) or English(USA) list and remove the i --> I autocorrect replacement and add a new replacement such as:
i .* --> I

this would disable the automatic i to I autocorrect and make the autocorrect kick in only when the i is followed by a space

tell me if that works.
Comment 11 tommy27 2015-01-20 05:42:38 UTC
did you try my workaround? did it solve your issue?
Comment 12 tommy27 2015-08-16 18:00:21 UTC
since there's no user feedback after many months and an easy solution to the bug (which is just an autocorrect collision you can easily workaround as explained in comment 3) I close this bug as RESOLVED WORKSFORME