Page 1 of 1

Correct Characters

Posted: Wed Nov 21, 2018 6:19 pm
by Sm111
The question I'm asking may be covered in the forum, but I don't have the vocabulary (yet) to search for it. I'm entering data into a column and need for it to appear EXACTLY as I type it. Math is making assumptions for case and symbols. How do I get Math to take entries Exactly as they are typed?

Re: Correct Characters

Posted: Wed Nov 21, 2018 6:33 pm
by FJCC
It sounds like you are using Calc rather than Math. Math is for displaying mathematical formulas in documents and it has nothing to do with columns. Calc is a spreadsheet program and entries are made in rows and columns. To have Calc take entries exactly as written, format the cells as text. To do that, select the cells then go to the menu Format -> Cells and on the Numbers tab set the Category to Text. Formatting a cell as text will prevent using the content in most calculations.

Re: Correct Characters

Posted: Thu Nov 22, 2018 10:07 am
by keme
Also, assumptions for upper-/lowercase are most likely caused by Calc trying to make the entry conform to spellcheck data and/or previous input.
Tools - AutoCorrect options: untick everything to avoid assumptions from Calc based on predefined or previously collected "transliteration".
Tools - Cell contents - AutoInput toggles the "unifying" of input. You want to remove the tick at the menu entry to avoid assumptions based on what you have written previously in the current file.