Bug 140573 - Choose default date format after importing from CSV
Summary: Choose default date format after importing from CSV
Status: RESOLVED DUPLICATE of bug 46448
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.3.0 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-02-21 00:40 UTC by J. B. Rainsberger
Modified: 2021-07-06 14:53 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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 ***