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.


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

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

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