Bug 137010 - Calc Changes First Letter Case When Adding # Sign to a Word
Summary: Calc Changes First Letter Case When Adding # Sign to a Word
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: AutoCorrect-Complete
  Show dependency treegraph
Reported: 2020-09-24 22:16 UTC by Crusader
Modified: 2020-09-24 23:24 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 Crusader 2020-09-24 22:16:01 UTC
When using LO Calc version (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.
Comment 1 Ming Hua 2020-09-24 23:24:26 UTC
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: (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.