Correct Characters

Discuss the spreadsheet application
Post Reply
Sm111
Posts: 1
Joined: Wed Nov 21, 2018 5:40 pm

Correct Characters

Post 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?
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
OpenOffice 4.1.6 on Windows 10
FJCC
Moderator
Posts: 9248
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Correct Characters

Post 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.
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.
User avatar
keme
Volunteer
Posts: 3699
Joined: Wed Nov 28, 2007 10:27 am
Location: Egersund, Norway

Re: Correct Characters

Post 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.
Post Reply