Re: time format

Jody Goldberg:
On Tue, Oct 21, 2003 at 11:02:54PM +0300, Ain Vagula wrote:

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.


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]