To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=42655 Issue #:|42655 Summary:|Time values entered in a formula are converted by |OOoCalc to decimal numbers. Component:|Spreadsheet Version:|OOo 1.1.4 Platform:|PC URL:| OS/Version:|Linux Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|editing Assigned to:|spreadsheet Reported by:|docpi
------- Additional comments from [EMAIL PROTECTED] Sat Feb 12 16:49:49 -0800 2005 ------- This one is simple, easy and clear-cut: 0) Enter "0:30" in a field in OOoCalc and the field correctly retains the value in its originally entered format, "00:30:00". BUT: 1) Enter "=0:30+0:40" in another field in OOoCalc and the value stored for that field is wrongly converted to "=0,0208333333333333+0,0277777777777778". This behavior of OOoCalc wrognly changing the stored value of a field to one of its possible representations, losing original format and inviting offset and rounding errors, has popped up around 1.0.x and has not been really squashed since. This is to say that it appears to be a problem in the fundamental cell handling routines and that any attempts so to get to it have so far not been satisfactory. --------------------------------------------------------------------- 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]
