To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101292 Issue #|101292 Summary|INT() of a processed time value displays different val |ue than non-INT() of the same time value Component|Spreadsheet Version|OOo 3.0.1 Platform|PC URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P4 Subcomponent|viewing Assigned to|spreadsheet Reported by|rustycar54
------- Additional comments from [email protected] Wed Apr 22 22:04:23 +0000 2009 ------- (Note - I just downloaded OOO300m15 Build 9379 and tested it with the below. I did not see OOO300m15 in the 'Found in version' list! Since that was the case, I decided to download the windows version (3.0.1, it says) and try it out. It happens there too.) Summary: If you are using time values, and doing arithmetic on them (probably the wrong way, but this sort of worked), and you foolishly do an 'int' to make sure that your minutes value is minutes only, you will find that you will be off by one sometimes. To reproduce this issue, do the following: Cell Enter A1 8:10 B1 11:25 C1 =B1-A1 D1 =INT(C1*24) E1 =(c1*24-D1)*60 F1 =INT((c1*24-D1)*60) E1 will show the expected 15 (minutes), but F1 will show 14 (minutes). For even more fun, continue with: Cell Enter G1 =INT(E1) And you ALSO get 14. I found that '=INT(E1+0.0000001)' gives me the expected '15'. My current workaround (if you want to call it that) is to not use the 'INT', since it turns out to not be needed. Disclaimer: I probably should have looked for a howto on using time values in OOo, which probably would have told me a better way. However, someone with OOo should probably look at this and either document it as a 'feature', or maybe fix it :-) One more note - this is submitted from a different machine (windows) than I tested on (Ubuntu 8.10, x86, with the OOO300m15 download, running it via direct execution of /opt/openoffice.org3/program/scalc). This worked the same way in OOCalc 2.0, Novell edition, and 2.4.1 as came with Ubuntu 8.10) --------------------------------------------------------------------- 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]
