OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Number Formats and Locale Settings
Goto page Previous  1, 2, 3, 4
 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
jade30
Newbie
Newbie


Joined: 27 Apr 2012
Posts: 1

PostPosted: Fri Apr 27, 2012 11:43 pm    Post subject: Reply with quote

You mean the system locale, the second option in the language settings? Well, this is what I thought until I had a long discussion with one of our russian members.
Now my understanding is that all formatting is up to you. First, the value has to be a number at all. Number formatting on text is pointless. What is considered as number depends on the cell's individual number format locale (NFL). If input is a number (1.23, 31/12/2000, 23E-4, 13%, true) it will be formatted according to your formatting. If you did not apply any then your input gets formatted automatically according to the cell's number NFL.
You set the default NFL for newly created documents through the third setting in the options-panel. Of course this will not affect your custom templates.
If one cell has number format "General" with NFL en-GB 31/12/2000 is a number 12/31/2000 is text. The next cell with US-NFL handles this the other way round. "DD/MM/YY" explicitly set in a US-cell is a custom number format (in a british cell it's default date). "DD/MM/YY" with US NFL treats input 31/12/07 as number and shows 12/31/07, whereas input 12/31/07 is not a number at all. So don't do this except for proof of concept.

Removed spam link - floris v, moderator
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Goto page Previous  1, 2, 3, 4
Page 4 of 4

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group