Description: When using LO Calc version 7.0.1.2 (x64), build 7cbcfc562f6eb6708b5ff7d7397325de9e764452, whenever I enter a word beginning with lower case and having a # sign as part of the word, Calc changes the word's first character to upper case. That was not the case in previous versions of Calc. The example below exemplifies the issue. The word I entered: city#1 Calc changed it to: City#1 When I enter: city1, Calc does not make changes. Steps to Reproduce: 1. Type the following in a cell 2. city#1 3. Calc will change it to 4. City#1 Actual Results: Calc changed my entry from city#1 to City#1 Expected Results: My entry should have remained as I entered it: city#1 Reproducible: Always User Profile Reset: No Additional Info: Going to Tools > AutoCorrect Options > Options and unchecking the option "Capitalize first letter of every sentence" seems to stop it; however that should not be considered the solution since changing this option negatively affects Writer. Please feel free to email me if you need clarification/more details.
While I can confirm the reported autocorrect behavior "city#1" -> "City#1" with 7.0.1, I can't confirm that this is a change of behavior, as 6.4.6 does the same autocorrection for me: Version: 6.4.6.2 (x64) Build ID: 0ce51a4fd21bff07a5c061082cc82c5ed232f115 CPU threads: 2; OS: Windows 10.0 Build 18363; UI render: default; VCL: win; Locale: zh-CN (zh_CN); UI-Language: en-US Calc: threaded Not sure if this is a bug or intended behavior.
Tools - AutoCorrect Options - Options - Capitalize first letter of every sentence
Calc is a spreadsheet where no is expected to write "sentences". The Options of "Capitalize first letter of every sentence" should be disabled by default. I think this is a good enhancement request.
(In reply to Shantanu from comment #3) > Calc is a spreadsheet where no is expected to write "sentences". > The Options of "Capitalize first letter of every sentence" should be > disabled by default. I think this is a good enhancement request. Toggling the 'Capitalize first letter of every sentence' AutoCorrect Option, has no effect on full sentences entered into a Calc cell. A full sentence in calc is never capitalized by Autocorrect. Rather, there is weirdness in the Autocorrect action on Calc cells. Oddly the capitalize first autocorrect does affect text snippets with mixed text and numbers separated with any punctuation other than "@" so [!#$%^&*()_+-+{}[]\|;:'",<.>/?] inserted between a text run and a number will capitalize the text run. How are those a sentences, and why sould the calc edit shell respond to that autocorrect setting? Is the autoformatting serving some purpose for data formatting--for data labels perhaps? If so, why is it linked to the generic autocorrect capitalize first when clearly not a sentence punctuation. Is an additional control needed in autoformat for use with Calc?
A new major release of LibreOffice is available since this bug was reported. Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version.
I tried the original "concern" in version 7.3.0.3 (x64)/LibreOffice Community (build 0f246aa12d0eee4a0f7adcefbf7c878fc2238db3) and the issue has not been resolved. Details: The word I entered in Calc: city#1 Calc changed it to: City#1 When I entered: city1, Calc did not changes my entry. Steps to Reproduce: 1. Type "city#1" in a cell (without the quotes) 2. Calc will change it to City#1
[Automated Action] NeedInfo-To-Unconfirmed
- Verified that this is still happening when typing city#1 in the cell, and it capitalizes City#1. - Verified by using various symbols such as: !, &, or -. -Verified that this is still happening when pressing enter, selecting the tab key, or even selecting the up or down arrow, it still capitalizes. -Verified by selecting -Verified by navigating to Tools > AutoCorrect Options > Options and unchecking the option "Capitalize the first letter of every sentence" which seems to stop it It appears that it capitalizes on complete words. When I tried c#ity#1, it stays in lowercase even if the user presses enter, selects the tab key, or uses the up or down arrow. Version: 7.4.2.3 (x64) / LibreOffice Community Build ID: 382eef1f22670f7f4118c8c2dd222ec7ad009daf CPU threads: 8; OS: Windows 10.0 Build 22000; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 98f0dd5e15733ac7f1d929d06ab230b5f04121d5 CPU threads: 8; OS: Windows 10.0 Build 22000; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded
I have a similar problem, which occurs in text with an isolated lower case i. LO Version 7.3.7_Win_x64 Example: Enter in columns A to J, lower case letters a b ....i j The i is capitalised. Type 'Enter i' results in 'Enter I'. Should this should be a new bug?
(In reply to Richard Cooper from comment #9) > I have a similar problem, which occurs in text with an isolated lower case i. > LO Version 7.3.7_Win_x64 > Example: > Enter in columns A to J, lower case letters a b ....i j > > The i is capitalised. > Type 'Enter i' results in 'Enter I'. > > Should this should be a new bug? That happens when the language for the cells is defined as English. You can disable the behaviour by going to Tools - AutoCorrect Options - Options, uncheck "Use replacement table". It is a feature, not a bug.
Thank you for reporting the bug. I can confirm that the bug is present in Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: a2265e8faa099d9652efd12392c2877c2df1d1eb CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded as well as Version: 24.2.1.2 (X86_64) / LibreOffice Community Build ID: db4def46b0453cc22e2d0305797cf981b68ef5ac CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded