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]

Reply via email to