My input Excel spreadsheets have dates in DD/MM/YYYY format, so today would be 14/05/2022 (this is normal in the UK; no-one is going enter a date as 2022-05-14). I convert these to csv with:

ssconvert --export-type=Gnumeric_stf:stf_assistant -O 'format=preserve quoting-mode=auto separator=,' file.xlsx file.csv

With 'preserve', the resulting csv shows 05-14-22, so it's assuming a US locale. Is there any way I can change this? The only mention of 'locale' in the man page refers to export, not import. Thanks.

_______________________________________________
gnumeric-list mailing list
gnumeric-list@gnome.org
https://mail.gnome.org/mailman/listinfo/gnumeric-list

Reply via email to