ssconvert julian date by design?

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

ssconvert julian date by design?

Tim Clarke
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
[hidden email]
https://mail.gnome.org/mailman/listinfo/gnumeric-list

smime.p7s (4K) Download Attachment
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: ssconvert julian date by design?

Morten Welinder-2
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 <[hidden email]> 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
> [hidden email]
> https://mail.gnome.org/mailman/listinfo/gnumeric-list
>
_______________________________________________
gnumeric-list mailing list
[hidden email]
https://mail.gnome.org/mailman/listinfo/gnumeric-list
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: ssconvert julian date by design?

Tim Clarke
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 <[hidden email]> 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
>> [hidden email]
>> https://mail.gnome.org/mailman/listinfo/gnumeric-list
>>


_______________________________________________
gnumeric-list mailing list
[hidden email]
https://mail.gnome.org/mailman/listinfo/gnumeric-list

smime.p7s (4K) Download Attachment
Loading...