(In reply to Jonny Grant from comment #0)
> Lately I have noticed that opening a CSV file (Comma Separated Value) file
> and Calc defaults to TAB. Can it default to searching for Comma.

The import filter settings are stored and reinitialized from the settings you made during last use and the default is [x] Tab, [x] Comma, [x] Semicolon being set (when using a fresh user profile).

(In reply to Uwe Auer from comment #1)
> (In reply to Jonny Grant from comment #0)
> > Lately I have noticed that opening a CSV file (Comma Separated Value) file
> > and Calc defaults to TAB. Can it default to searching for Comma.
> 
> The import filter settings are stored and reinitialized from the settings
> you made during last use and the default is [x] Tab, [x] Comma, [x]
> Semicolon being set (when using a fresh user profile).


Hello Uwe

Feels sensible to keep "Comma" ticked, as it is a Comma Separated Value file?

I also opened a TSV (Tab Separated Values) file, I assume it is that that changed the default. Probably it should not impact CSV loading.

Opening a .tsv file automatically sets the field separator to tab, but opening a .csv file preserves the last used separator. On purpose, because the extension .csv is often used for everything comma or semicolon or even tab separated.

(In reply to Eike Rathke from comment #3)
> Opening a .tsv file automatically sets the field separator to tab, but
> opening a .csv file preserves the last used separator. On purpose, because
> the extension .csv is often used for everything comma or semicolon or even
> tab separated.

I just reproduced it again.

1. Open CSV, observe it is set to Commas.
2. Close CSV.
3. Open TSV
4. Close TSV
5. Open CSV
6. Observe it is set to TAB only

It's a defect. Because a TSV file changes the CSV settings. the TSV change is retained. a TSV file only contains Tab Separated Values.
My feedback is a waste of time. I'll consider not reporting bugs anymore, they never get fixed in Calc.