That is a very old version of Gnumeric you have there.  It's from 2010.
With the current version of Gnumeric you get the value formatted in xlsx.

Morten


On Wed, May 10, 2017 at 8:09 AM, Tim Clarke <[email protected]> wrote:
> I'm getting some (unexpected?) results converting SQL CSV output to
> Excel spreadsheets:
>
> Centos 6.9
>
> ssconvert --version:
> ssconvert version '1.10.10'
> datadir := '/usr/share/gnumeric/1.10.10'
> libdir := '/usr/lib/gnumeric/1.10.10'
>
> echo \"31/03/2014 00:00:00\" | ssconvert --import-encoding="UTF8"
> --export-type=Gnumeric_Excel:excel_biff8 fd://0 "my.xls"
> echo \"31/03/2014 00:00:00\" | ssconvert --import-encoding="UTF8"
> --export-type=Gnumeric_Excel:xlsx fd://0 "my.xlsx"
>
> The .xls file formats the date fine but the .xlsx remains as a
> user-confusing Julian.
>
> Is this by design? Is there a work-around?
>
> --
> Tim Clarke
>
>
>
> _______________________________________________
> gnumeric-list mailing list
> [email protected]
> https://mail.gnome.org/mailman/listinfo/gnumeric-list
>
_______________________________________________
gnumeric-list mailing list
[email protected]
https://mail.gnome.org/mailman/listinfo/gnumeric-list

Reply via email to