[Solved] Number changed after entering it in table

Discuss the word processor

[Solved] Number changed after entering it in table

Postby native » Thu Feb 20, 2020 10:01 pm

Created a new document with a table with 3 columns and twelve rows. Inserted the text .223, clicked in the next cell and the text I just entered changed to 0.22.

HELP!
Last edited by Hagar Delest on Fri Feb 21, 2020 9:01 am, edited 2 times in total.
Reason: tagged solved
OpenOffice 4.1.6 on Windows 10
native
 
Posts: 3
Joined: Thu Feb 20, 2020 9:57 pm

Re: HELP!

Postby RusselB » Thu Feb 20, 2020 10:13 pm

Welcome to the Forums.
Did you format the column that the entry was entered? If you did, then what you see will change to look like what you used as a format. The actual entry itself will still be recognized as .223 so if you do any math with that number, the math will work with all 3 digits, not just the two being displayed.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 6209
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: HELP!

Postby Bidouille » Thu Feb 20, 2020 10:17 pm

HELP is not good for a title. We knows that you need help.

Try a search in this forum on "number format recognition".
User avatar
Bidouille
Volunteer
 
Posts: 366
Joined: Mon Nov 19, 2007 10:58 am
Location: France

Re: HELP!

Postby native » Thu Feb 20, 2020 11:14 pm

Sorry, did not know what to put in the title area.
 Edit: I created another topic title for you. — MrProgrammer, forum Moderator, 2020-02-20 09:17 UTC 
OpenOffice 4.1.6 on Windows 10
native
 
Posts: 3
Joined: Thu Feb 20, 2020 9:57 pm

Re: Number changed after entering it in table

Postby native » Thu Feb 20, 2020 11:49 pm

Thanks for changing the topic tile for me.

I did figure this out.

I highlighted all the cells in my table and unchecked the "Number Recognition" option and that fixed the problem.

(I've made this type of document before and never had this issue.)
OpenOffice 4.1.6 on Windows 10
native
 
Posts: 3
Joined: Thu Feb 20, 2020 9:57 pm


Return to Writer

Who is online

Users browsing this forum: No registered users and 15 guests