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.
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?
Right now I am using Windows 10 Preview 64-bit (English). LibreOffice is version 4.3.2.2. 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.
I don't see this bug under Win7x64 using LibO 4.3.2.2 with italian localization. I can type "i" in any Calc cell and no autocapitalization or autocorrection happens. may be Linux specific issue.
@ 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
I installed Ubuntu 14.04 LTS 64-bit English with LibreOffice 4.2.6.3 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.
Ok, thanks for the further informations. I set version to 4.2.6.3 which is the earliest release where you reproduced the bug.
Changed the status to New as nobody does it. I guess, the issue is easily reproducible by any one.
@Yerlan 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
Reproducible with LO 4.3.2.2 (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 Result: "i" gets "I" -> it is not possible to simply write a small "i" in a cell
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.
@Yerlan did you try my workaround? did it solve your issue?
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