Issue 56286 - "738.01" autoformat to date
Summary: "738.01" autoformat to date
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 1.1.4
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-10-19 17:23 UTC by joostew
Modified: 2005-11-10 15:03 UTC (History)
1 user (show)

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

Attachments
range 738.00 thru 738.15 (6.73 KB, application/vnd.oasis.opendocument.spreadsheet)
2005-10-19 17:27 UTC, joostew 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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