How do I disable csv opening prompt / dialog window

After night of searches I was found the solution on bugs.documentfoundation.org
edit by @karolus escaping quotes "

1. Open cmd
2. Copy-paste
   assoc .csv=LibreOffice.Csv
   ftype LibreOffice.Csv="C:\Program Files\LibreOffice\program\scalc.exe" "--infilter='Text - txt - csv (StarCalc)':44,34,0,1" "%1"

Where:
44 is comma Field Separator (converted HEX ASCII code to DECimal. You can find code in windows character map and convert in programmer calc or search converter in web.
34 - " Double quotes Text Delimiter (converted ASCII too),
0 - Character Set (Full list at the link below)
1 - Number of First Line
5th arg is Cell Format Codes for the four columns.

For cyrillic 1251 encoding with ";" separator use in arg 59,34,34,1

  1. Open csv file from Open with → Choose another app and choose unused LibreOffice Calc

More info about arguments described here wiki.openoffice.org

1 Like

Please correct your quotes in the copy-paste part or add 2a “try again with non-typographic quotes” - I don’t think cmd will support this.

I was told this is no bug but a beautyful feature of this site: