Apache OpenOffice (AOO) Bugzilla – Issue 59919
Wrong example for [HH].MM.SS in time format
Last modified: 2017-05-20 11:11:23 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.
confirmed on Windows XP Pro SP2 with OOo 2.0.1
there are similar issues for date formats, eg. for TT.MM.JJJJ HH:MM:SS
Hi Daniel, one for you ? Frank
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.
invalid->closed
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?)
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.
*** Issue 82111 has been marked as a duplicate of this issue. ***
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).
Indeed..
Won't make it for 3.1, targeting to 3.2
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.
@ufi: can you please check help concerning this formatting issue?
*** Issue 106977 has been marked as a duplicate of this issue. ***
ufi->reinerbielefeld: Help text is issue 104361
Reset assigne to the default "issues@openoffice.apache.org".