-1

I have LibreOffice 4.1.2 on my winbox and I cannot make it accept an arbitrary input.

The minimal test:

  1. create a new Calc document;
  2. input KBr;
  3. press Enter.

Then the text turns into Kbr. Setting the cell format to Text does not help at all.

The similar question How to prevent OpenOffice/LibreOffice Calc from changing what you input (data, numbers,...) was mainly about importing and didn't help me either.

So, is there a way to insert an arbitrary text piece into a cell - at least my minimal example?

Community
  • 1
  • 1
naudhr
  • 11
  • 1
  • Thank you for this question, Bowdzone has the answer, Tools → AutoCorrect → Options, and in your case there's a specific TWo CApital correction setting. LibreOffice, listen to me, put all options under Options, not some unknown other place – gseattle May 13 '22 at 06:46

2 Answers2

1

Copied from question:

It has turned out that the options related to autocorrecting the text are located under the separate menu Tools → AutoCorrect

The description: https://help.libreoffice.org/Calc/Deactivating_Automatic_Changes

In my case, I just turned this feature off in Tools → AutoCorrect → Options

Bowdzone
  • 3,827
  • 11
  • 39
  • 52
0

It is just the effect of a dumb language corrector trying to avoid typos. Disable all of them and your input will be kept. Tools → Options... → Language settings → Writing aids. I usually disable everything here; but trying you can keep a bare minimum while avoiding case correction.

ShinTakezou
  • 9,432
  • 1
  • 29
  • 39
  • Didn't help, though helped me to start searching in the right direction. I've updated the post with the description. – naudhr Jan 18 '14 at 06:44
  • I haven't checked the version, in fact I have a different version from yours. Though, we are talking about the same stuff. – ShinTakezou Jan 18 '14 at 10:59