Issue 59919

Summary: Wrong example for [HH].MM.SS in time format
Product: Calc Reporter: Andrea Pescetti <pescetti>
Component: formattingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P4 CC: issues,, lars_o_hansen, uwefis
Version: OOo 2.0.1Keywords: 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
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 ?

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
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 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 ->

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
Comment 10 ooo 2008-07-10 15:01:01 UTC
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
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 "".