43

LibreOffice Calc Version 5.2.7.2.

I have everything I can find under Tools -> AutoCorrect turned off.

However, I still see capitalizations in certain cases.

Is there anything more I need to turn off to completely disable it?

It seems to be related to hyphens. Some strings with hyphens separating words such as this in a cell "foo -- bar -- baz" will capitalize bar to Bar. However, similar sentences, in a new cell, will not experience this behavior.

AlphaCentauri
  • 877

3 Answers3

46

Deactivate the following option:

Tools > AutoCorrect Options... > Options > Capitalize first letter of every sentence

LibreOffice Calc: Capitalize first letter of every sentence

It seems that it doesn't typically trigger (i.e., I can put a cell that contains table, or another one that contains this is a message and nothing autocorrects). But under certain circumstances, it is indeed triggered (e.g. when you put this-notasentence, t is capitalized). I am not sure why LibreOffice decides that having a hyphen means that it is a sentence and thus should be triggered.

It seems a misbehaviour of LibreOffice, or a bad heuristic. I am not sure if that's your specific case, but for sure it is what was happening to me, @dennisjbell and @AlphaCentauri.

@m93a comments may be relevant: If you are using LibreOffice version >=7, menus may be moved, and you can access the traditional ones by

⚙️>User Interface and change to Standard Toolbar

And change back by:

View>User Interface>Tabbed

David Tonhofer
  • 1,314
MariusSiuram
  • 596
0

I fail to see how the answer, or comments, given so far solve the problem when an hyphen is involved. That could be due to not being a native English speaker. In any case, I find the answer to a question that concentrates on the hyphen issue to fully solves that particular issue.

nh4c
  • 11
0

assuming "Capitalize first letter of every sentence" is unchecked (in "Options" tab, when selecting "AutoCorrect Options..." in the "Tools" menu)

I too was having the same problem, but specifically with one cell (where two other very similar cells didn't suffer the auto cap):

magenta bldg-name => Magenta bldg-name

yellow bldg-name => yellow bldg-name

cyan bldg-name => cyan bldg-name

SOLUTION (apologies: equally annoying answers):

  1. avoid using a hyphen (in my case, make it "magenta bldg.name")
  2. or Ctrl+z (after leaving the cell or hitting enter/return, hold Ctrl and type "z": the undo will be the autocorrect, not any edits you did)
hunter3740
  • 61