Re: ssconvert julian date by design?



Simples. Ty Morten. Bad RedHat :(

Tim Clarke
 

On 10/05/17 14:04, Morten Welinder wrote:
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 <tim clarke manifest co uk> 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
gnumeric-list gnome org
https://mail.gnome.org/mailman/listinfo/gnumeric-list



Attachment: smime.p7s
Description: S/MIME Cryptographic Signature



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