Bug 295431 – app-office/openoffice-bin-3.1.1: TIMEVALUE(), ZEITWERT() don't work correct anymore

• Status: RESOLVED FIXED
• Product: Gentoo Linux

[Description Thomas Kohler 2009-12-02 12:31:34 UTC]

example bad case (bug was found in function used german language):
A1 is formatted as "TEXT"

A1="24:00:00"
A2=ZEITWERT(A1)*24*60
-> at "app-office/openoffice-bin-3.0.0": result=1440
-> at "app-office/openoffice-bin-3.1.1": result=0

example good case (bug was found in function used german language):
A1="23:59:59"
A2=ZEITWERT(A1)*24*60
-> at "app-office/openoffice-bin-3.0.0": result=1440
-> at "app-office/openoffice-bin-3.1.1": result=1440

In my opinion the format "[HH]:MM:SS" was used before. Now the format "HH:MM:SS" is used.

The problem is also good shown with this example:
A1 is formatted as time "[HH]:MM:SS"

A1=24:00:00
A2=ZEITWERT(TEXT(A1;"[HH]:MM:SS"))*24*60

-> at "app-office/openoffice-bin-3.0.0": result=1440
-> at "app-office/openoffice-bin-3.1.1": result=0


Reproducible: Always




In my opinion the cause for this problem is i94765 at http://development.openoffice.org/releases/3.1.0.html

[Comment 1 Thomas Kohler 2009-12-02 19:57:14 UTC]

(In reply to comment #0)
Hello, problem is fixed quite simple:

A1 is formatted as time "[HH]:MM:SS"
A1=24:00:00
A2=A1*24*60

A1 is formatted as "TEXT"
A1="24:00:00"
A2=WERT(A1)*24*60

-> at "app-office/openoffice-bin-3.0.0": result=1440
-> at "app-office/openoffice-bin-3.1.1": result=1440

Background: The "new" functionality now works like "MS Excel".