Bug 49027

Summary:	: time format code
Product:	LibreOffice	Reporter:	Julien Vroonen <jvroonen>
Component:	Spreadsheet	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED NOTABUG	QA Contact:
Severity:	normal
Priority:	medium
Version:	3.5.1 release
Hardware:	x86 (IA32)
OS:	Windows (All)
Whiteboard:	BSA
i915 platform:		i915 features:

Description Julien Vroonen 2012-04-20 14:28:10 UTC

Problem description: 
Using Time format code "[HH]:MM:SS" in format cell properties does not display hours > 24.


Steps to reproduce:
1. In cell A1, type the number "11245" (without quotes), representing a number of minutes.
2. In cell B1, type "=TIME(0;A1;0)"
3. Make sure that format cell properties is "Time", and that format code is "[HH]:MM:SS".


Current behavior:
"19:25:00" is displayed

Expected behavior:
"187:25:00" should be displayed ; I asked "[HH]" formatting and not "HH".


Platform (if different from the browser): 
Browser: Mozilla/5.0 (Windows NT 6.0; rv:11.0) Gecko/20100101 Firefox/11.0

Thank you !

Comment 1 Ferran Vidal 2012-04-22 11:11:19 UTC

[Reproducible] with "LibreOffice 3.5.2.2 - GNU/Linux Ubuntu 11.10,English
UI"

Comment 2 vitriol 2012-04-22 11:28:40 UTC

This behavior is not related with the cell format, but with the function TIME() that not return values > 24 h.
It's not a bug for me..

Comment 3 Markus Mohrhard 2012-04-23 14:43:04 UTC

OpenFormula specifies that Time always returns values between 00:00 and 24:00, so this is not a bug.

Comment 4 Julien Vroonen 2012-04-28 09:51:17 UTC

I think that what I described is functional in Openoffice and Excel, but ok... If it is a "feature", I will change my formula to achieve what i want.

Thanks for your feedback

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.