To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112198 Issue #|112198 Summary|Date+time values, displayed as time, may be corrupted |with edit Component|Spreadsheet Version|OOo 3.2 Platform|PC URL|http://user.services.openoffice.org/en/forum/viewtopic |.php?f=9&t=27197 OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P4 Subcomponent|editing Assigned to|spreadsheet Reported by|jes
------- Additional comments from [email protected] Mon Jun 7 17:56:41 +0000 2010 ------- Any recent date+time value, when displayed as time, will be corrupted when edited. This is apparently a limit in the entry conversion for times having greater than 65535 hours. Steps to reproduce: 1) File > New > Spreadsheet 2) A1: Enter a date+time: 2010-06-07T12:34 3) Format > Cells > Numbers > Category: Time, Format: HH:MM (first in list) The value display in the editing area now shows: 968076:34:00 4) Edit the value but don't change it (add a space at the end, then press Enter) 5) The value in the cell is now: 50572:34:00 The new hours value appears consistent with truncation to 16 bits at some point: =MOD(968076;65536) --> 50572. This problem also occurs if the user creates a chart with date+time values formatted without the date. Trying to set the axis limits will offer a date shown as hours:minutes and editing the value will truncate, giving a huge axis range. See the sample sheet attached to Issue 25706 for one example: http://www.openoffice.org/nonav/issues/showattachment.cgi/55112/bad%20datetime%20graph.ods I'm not sure what the real bug is here. Removing the limit in the input conversion would be good, but it would be better if Calc did not require the user to edit a date+time in this format at all. The workaround in any case is to display the date+time values in some format that shows both the date and the time, e.g. "MM-DD HH:MM". That allows editing in a reasonable format, without truncation errors on entry. --------------------------------------------------------------------- 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]
