Bug 140573

Summary:	Choose default date format after importing from CSV
Product:	LibreOffice	Reporter:	J. B. Rainsberger <me>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED DUPLICATE
Severity:	enhancement	CC:	peter
Priority:	medium
Version:	3.3.0 release
Hardware:	All
OS:	All
See Also:	https://bugs.documentfoundation.org/show_bug.cgi?id=46448
Whiteboard:
Crash report or crash signature:		Regression By:

Description J. B. Rainsberger 2021-02-21 00:40:37 UTC

Description:
When I import from CSV, I always need to format the resulting date columns with my desired date format. I would prefer to tell Calc to use this date format as the default for all future imports from CSV.

I would be thrilled, for example, with a sticky option in the import-from-CSV dialog.

I do _not_ want to change my operating system's locale to get this effect.

Steps to Reproduce:
1. Import a CSV document containing a date column. Mark the column correctly to detect the value as a date.

Actual Results:
The date column is formatted according to the locale default, rather than my desired standard date format.

Expected Results:
I would prefer to be able to choose the default date format for date columns when importing from CSV. I would love for this option to be sticky, so that it is remembered for future imports-from-CSV.


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.0.3.1
Build ID: 00(Build:1)
CPU threads: 8; OS: Linux 5.8; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Ubuntu package version: 1:7.0.3-0ubuntu0.20.10.1
Calc: threaded

Comment 1 J. B. Rainsberger 2021-02-21 00:48:44 UTC

I would like to clarify this more, since someone has already seemed confused by what I'm asking for.

My CSV file contains "10/23/2019". In the Import from CSV dialog, I mark that column as "Date (MDY)". Calc imports the column correctly.

I would like Calc to apply my desired format to that column automatically, rather than assuming that it should be the locale setting (or however it makes that decision now).

It might be that this behavior has nothing to do with importing from CSV. I could not find any other way to say to Calc, "Use date format YYYY-MM-DD by default for new date values, including ones imported from CSV." I'm looking for _that_.

Comment 2 Mike Kaganski 2021-07-04 06:20:00 UTC

(In reply to J. B. Rainsberger from comment #0)
> I do _not_ want to change my operating system's locale to get this effect.

The format depends on your LibreOffice locale (that defaults to your OS locale, but may be changed independently on Options->Language Settings->Languages). Unfortunately, there's not much locales that have ISO date format as a default - e.g., en-CA is one, but even there the ISO format is only default for date+time, not for date only (the latter uses YY-MM-DD instead of YYYY-MM-DD).

Your question relates to bug 46448.

Comment 3 J. B. Rainsberger 2021-07-06 14:53:06 UTC


*** This bug has been marked as a duplicate of bug 46448 ***