Public bug reported:
If you import a tab delimited spreadsheet into gnumeric, and resave it,
and you are in the US locale, it will convert all your date/time fields
to european format. EG:
4/6/2006 -> 2006/04/06
This doesn't make sense for a few reasons. First, I'm in the US locale,
so it shouldn't do this. Second, in gnumeric window onscreen it
properly shows you the 4/6/2006 format, so you would have no idea saving
it would 'convert' these fields. Third, even if you highlight the
column and change the format of the column to m/d/yyyy, it will still
export it in yyyy/m/d format.
Unfortunately this makes gnumeric quite useless for me. I can't come up
with any workaround for this. If I try to make gnumeric just treat
those columns as text, it'll convert 04/06/2006 to 38813... Which is
presumably the number of days since 1970.
Gnumeric should use the date format in the originally imported file, or
respect what format it displays on screen.
Note: the original reporter indicated the bug was in package 'gnumeric';
however, that package was not published in Baltix.
** Affects: gnumeric (Ubuntu)
Importance: Untriaged
Status: Unconfirmed
** Affects: Baltix
Importance: Medium
Status: Unconfirmed
--
gnumeric does not properly export datetimes to Text format
https://launchpad.net/bugs/40349
--
desktop-bugs mailing list
desktop-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/desktop-bugs
