Correct Characters
Correct Characters
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?
Last edited by MrProgrammer on Mon Aug 05, 2019 6:48 pm, edited 1 time in total.
Reason: Moved topic from Math forum to Calc
Reason: Moved topic from Math forum to Calc
OpenOffice 4.1.6 on Windows 10
Re: Correct Characters
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.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: Correct Characters
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.
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.