To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=66092 Issue #:|66092 Summary:|Time format "mm" shows month instead of minutes Component:|Spreadsheet Version:|OOo 2.0.3 Platform:|All URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|formatting Assigned to:|spreadsheet Reported by:|pescetti
------- Additional comments from [EMAIL PROTECTED] Sun Jun 4 07:41:04 -0700 2006 ------- 1. Insert "12.34.56" in a cell. It is interpreted as a time value. 2. Format -> Cell -> Time -> Code: hh.mm 3. "12.34" appears as expected. 4. Format -> Cell -> Time -> Code: hh 5. "12" appears as expected. 6. Format -> Cell -> Time -> Code: mm Expected: 7. "34" appears. Actual: 7. "01" appears, as "mm" is interpreted as month. Note that I used the lowercase format codes "hh" and "mm" instead of "HH" and "MM" because the documentation (date formats;number format codes) suggests using lowercase for hours-minutes-seconds and uppercase for year-month-day. Anyway, the problem still appears with the common uppercase codes. It seems that there is no way to get minutes as a cell format (the function MINUTE() could be used, but it would just be a workaround). [Reported by Dario Burattini during Italian QA tests] --------------------------------------------------------------------- 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]