Issue 23239 - Entering numbers
Summary: Entering numbers
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.1
Hardware: PC Other OS
: P5 (lowest) Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Keywords: oooqa
Depends on:
Reported: 2003-12-05 11:49 UTC by jacven
Modified: 2004-01-08 11:15 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description jacven 2003-12-05 11:49:23 UTC
If I want to enter numbers with decimals I must enter it with a comma (,) and 
not a fullstop (.).  This makes entering numbers quite a bit more time-wasting.

Please E-mail sollution to
Comment 1 srobertson 2003-12-09 21:57:52 UTC
I suspect that this is due to an improper "Language" setting. 
If you would like to change the global language setting: 
  1. Go to Tools->Options. 
  2. Expand the "Language Settings" tree node by clicking on the plus next to 
  3. Click on "Languages". 
  4. Change the settings of "Language of Locale Setting", "Language of Default 
     Currency", and "Default languages for documents -> Western" to settings  
     appropriate for you. 
  5. Click "OK". 
Note, however, that this may not alter the number format in existing  
documents.  To change that, follow the instructions below. 
To change the number format of all the cells in a Calc document: 
  1. Open the document. 
  2. Click on the gray, unlabeled cell above [1] and to the left of [A]. 
   2a.  Alternately, you may use the Edit -> Select All menu option. 
  3. Choose Format->Cells... 
  4. Choose a new language setting from the "Language" drop-down box. 
     (You may preview the format of the language in the "Format" list.) 
  6. Click "OK". 
Note that you may have to do this for every existing document. 
I'll email you a copy of these instructions. 
Comment 2 oc 2004-01-08 11:15:25 UTC
Closed because invalid