Re: time format

[Ain Vagula <ain riiska ee>]

Jody Goldberg:
> On Tue, Oct 21, 2003 at 11:02:54PM +0300, Ain Vagula wrote:
> > hi,
> >
> > when i format cell as [h]:mm:ss and enter in this cell eg. 0:03:44, the
> > value changes to 0:03:43, also occurs this with some other values, like
> > 0:01:02 (changes to 0:01:01). If I reformat the cell to h:mm:ss, cell
> > changes to his right value. What's up with this?
>
> I can't replicate that.  It could be related to some rounding
> but before patching anything I'd like to be able to see the effect.
>
> Please bugzilla with a sample sheet, or explicit directions on
> exactly what order to do things.


I want to be sure before filing a bug. :)

There is no need for a sample sheet, just take a new document.
1. Pre-format cell(s) as 'Time' or 'Custom' with format code [h]:mm:ss
2. Type 0:3:44 or 0:03:44
3. After pressing enter, value changes to 0:03:43
4. If we now change format to h:mm:ss (was [h]:mm:ss), cell shows right value, 
i.e 0:03:44

We could replicate this with Gnumeric 1.2.0 on Debian and 1.2.1 on SuSE, also 
tried with different locale settings, always the same.

ain