ssconvert assumes that Excel/xlsx dates are in US locale?
- From: EML <sa212+gnumeric cyconix com>
- To: gnumeric-list gnome org
- Subject: ssconvert assumes that Excel/xlsx dates are in US locale?
- Date: Sat, 14 May 2022 21:17:00 +0100
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.
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]