Issue 23239

Summary:	Entering numbers
Product:	Calc	Reporter:	jacven <pieterdp>
Component:	code	Assignee:	spreadsheet <spreadsheet>
Status:	CLOSED NOT_AN_OOO_ISSUE	QA Contact:	issues@sc <issues>
Severity:	Trivial
Priority:	P5 (lowest)	CC:	issues
Version:	OOo 1.0.1	Keywords:	oooqa
Target Milestone:	---
Hardware:	PC
OS:	Other OS
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

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 pieterdp@jv.bgr.co.za

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 
it. 
  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. 
 
HTH 
Steven

Comment 2 oc 2004-01-08 11:15:25 UTC

Closed because invalid