Issue 56286

Summary: "738.01" autoformat to date
Product: Calc Reporter: joostew <wilhelm>
Component: formattingAssignee: spreadsheet <spreadsheet>
Status: CLOSED IRREPRODUCIBLE QA Contact: issues@sc <issues>
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 1.1.4   
Target Milestone: ---   
Hardware: All   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
range 738.00 thru 738.15 none

Description joostew 2005-10-19 17:23:27 UTC 
open new spreadsheet
type in "738.01"
The number is converted to a date "38/01/01".
right click on cell |Format Cells|Number .
the value changes to "-424406"

I cannot get the number "738.01" displayed in the cell. 
the above is true for the range "738.01"  thru "738.12".
If a formula is used and the result is "738.01" it is also converted 
to "38/01/01"
Comment 1 joostew 2005-10-19 17:27:03 UTC 
Created attachment 30639 [details]
range 738.00 thru 738.15
Comment 2 frank 2005-10-20 08:20:01 UTC 
Hi,

what's the decimal delimiter in the locale you use ?

Do you get the numbers if you type a comma instead of the period ?

Frank
Comment 3 joostew 2005-10-21 07:31:21 UTC 
Hi Frank

The decimal delimiter used is period.

If I use comma ie. "738,01"; the format remains number.

Regards

Wilhelm
Comment 4 frank 2005-11-07 15:14:39 UTC 
Hi,

please check this behaviour with the final version of OOo2.0 and please tell me
the locale used on your system. Also the settings under tools-options-Language
settings for the locale would help.

Frank
Comment 5 joostew 2005-11-09 08:48:06 UTC 
Hi Frank

This issue is resolved in OpenOffice.org 2.0 !

Thank you.

Regards

Wilhelm
Comment 6 joostew 2005-11-09 09:01:56 UTC 
Hi Frank

Locale is "South Africa" and my locale settings under Tools|Options|Language 
is "Default". Language is "English(South Africa)"

Regards

Wilhelm
Comment 7 frank 2005-11-10 15:03:21 UTC 
Hi,

so I close this Issue as worksforme.

Frank
Comment 8 frank 2005-11-10 15:03:58 UTC 
closed wfm