To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=75245 Issue #|75245 Summary|Error in Date Formats - for specific dates only Component|Spreadsheet Version|OOo 2.1 Platform|Macintosh URL| OS/Version|Mac OS X Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|formatting Assigned to|spreadsheet Reported by|icanseethepubfromhere
------- Additional comments from [EMAIL PROTECTED] Fri Mar 9 06:21:26 +0000 2007 ------- The error occurs in entering the date March 4th or January 4th. The display puts the date in correct for April 2nd as 02/Apr, however, the former dates mentioned gets the [1/4] = one quarter or [3/4] = three quarter notation This exists in English and Japanese versions The bug occurred under very -- strictly -- limited condition. 1. Please select a cell in Calc arbitrarily. 2. Set its format as following; a) Category (the left column) - date. b) Format (options - the centre column) - the 6th item from bottom (31/Dec). c) language (the right column) - standard (=default). d) Sample window shows 03/May 3. Then enter the string '3/4'. You will get not a date 03/04/2007 but a number 3/4. Strings such as '03/04', '03/4', '3/04', '2007/3/4', do not rise this bug. Another dates (e.g. 3/5, 3/3) neither. Interestingly, the preview image works correctly. This bug can be avoided selecting other options (Japanese instead of standard, "12.31" instead of the 6th from bottom). That's also interesting. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
