Issue 59919

Summary:	Wrong example for [HH].MM.SS in time format
Product:	Calc	Reporter:	Andrea Pescetti <pescetti>
Component:	formatting	Assignee:	AOO issues mailing list <issues>
Status:	CONFIRMED ---	QA Contact:
Severity:	Trivial
Priority:	P4	CC:	issues, jeongkyu.kim, lars_o_hansen, uwefis
Version:	OOo 2.0.1	Keywords:	oooqa
Target Milestone:	---
Hardware:	All
OS:	All
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

Description Andrea Pescetti 2005-12-31 16:04:37 UTC

1. Create a new Calc document.
2. Format -> Cells, Numbers, Time.
3. The example for format code [HH].MM.SS is 876613.37.46
4. It is rendered as 29629.37.46

As [HH] seems to overwrap at 65535, the example should have an hour field in the
range 25...65535 in order to be understandable.

An example that produces a different result when typed into a cell is definitely
wrong.

Comment 1 lars 2006-01-02 21:27:27 UTC

confirmed on Windows XP Pro SP2 with OOo 2.0.1

Comment 2 lars 2006-01-04 17:59:14 UTC

there are similar issues for date formats, eg. for TT.MM.JJJJ HH:MM:SS

Comment 3 frank 2006-01-31 15:24:12 UTC

Hi Daniel,

one for you ?

Frank

Comment 4 daniel.rentz 2006-01-31 15:40:34 UTC

The value in the listbox is independent from the preview. While the listbox uses 
fixed values, the preview uses the current value, e.g. from the sheet, or another 
default value. You can verify in a Calc cell that the number format works correctly 
with hours >65535.

Comment 5 daniel.rentz 2006-01-31 15:44:28 UTC

invalid->closed

Comment 6 lars 2006-01-31 16:06:03 UTC

the meaning of [] for time formats isn't explained in the help (-> new issue?), 
but a number like 876613 in the Format Box for [HH]:MM:SS or 29629 in the 
preview box for that format doesn't look like a hour (0-24) (or is it an "hour 
counter"?). Also the preview for the Date format T. MMM. JJJJ is 18. Mai. 1903. 
Not exactly a good choice, even if it gives the user a taste of how it looks 
when applied to short month names (perhaps this handling should be changed for 
short month names?)

Comment 7 lars 2006-02-02 14:14:04 UTC

see last comment; the problem with the date format is the dot after the month 
name; in general the examples in the numbers tab should be rechecked.

Comment 8 jeongkyu.kim 2007-10-01 15:46:41 UTC

*** Issue 82111 has been marked as a duplicate of this issue. ***

Comment 9 daniel.rentz 2008-07-09 15:25:41 UTC

DR->ER: confirmed.

In the tabpage (svx/source/dialog/numfmt.cxx), number format examples are
generated from the value SVX_NUMVAL_TIME = 36525.567893518499. Have a look to
the number format [HH]:MM:SS.00 which is shown (correctly) in the listbox as
876613:37:46.00 but in the preview window as 29629:37:45.70. Note the the
preview shows wrong hours *and* 1/100 seconds.

The listbox is filled using SvNumberFormatter::GetPreviewString (via
SvxNumberFormatShell::MakePrevStringFromVal), but the preview is filled using
SvNumberFormatter::GetOutputString (via SvxNumberFormatShell::FormatChanged ->
SvxNumberFormatShell::GetPreviewString_Impl)

A similar problem appears when entering such numbers into a Calc cell: type
123456:00:00 into the cell, but it will contain 57920:00:00 afterwards (modulo
2^16).

Comment 10 ooo 2008-07-10 15:01:01 UTC

Indeed..

Comment 11 ooo 2009-01-21 23:35:35 UTC

Won't make it for 3.1, targeting to 3.2

Comment 12 thorsten.ziehm 2009-11-05 08:42:23 UTC

OOo 3.2 is in show-stopper stage and only critical issue will be accepted
anymore. This issue will be targeted to OOo 3.x. If a solution is found, please
target this issue to a suitable target.

Comment 13 Rainer Bielefeld 2009-11-17 19:11:09 UTC

@ufi:
can you please check help concerning this formatting issue?

Comment 14 Rainer Bielefeld 2009-11-17 19:11:28 UTC

*** Issue 106977 has been marked as a duplicate of this issue. ***

Comment 15 Uwe Fischer 2009-11-18 07:01:19 UTC

ufi->reinerbielefeld: Help text is issue 104361

Comment 16 Marcus 2017-05-20 11:11:23 UTC

Reset assigne to the default "issues@openoffice.apache.org".