Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|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:|
|Priority:||P4||CC:||issues, jeongkyu.kim, lars_o_hansen, uwefis|
|Issue Type:||DEFECT||Latest Confirmation in:||---|
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
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
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. ***