| Summary: | When opening a CSV file, default to CSV-spec-compliant options | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Eyal Rozenberg <eyalroz1> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | UNCONFIRMED --- | ||
| Severity: | enhancement | CC: | gabriel.masei, himajin100000 |
| Priority: | medium | ||
| Version: | 6.0 all versions | ||
| Hardware: | All | ||
| OS: | All | ||
| See Also: | https://bugs.documentfoundation.org/show_bug.cgi?id=156879 | ||
| Whiteboard: | needsUXAdvice | ||
| Crash report or crash signature: | Regression By: | ||
Hi Eyal, Take a look over this improvement: https://bugs.documentfoundation.org/show_bug.cgi?id=160355 Gabriel |
Currently, when opening a CSV file, the parsing dialog has its options set to (IIANM) the last settings for parsing any textual data. Instead, when opening a CSV file (that is, with a ".csv" extension or with a "text/csv" MIME type) - the settings should correspond to the CSV spec, in RFC 4180. So, for example, only a comma separates records, and the string delimiter is double-quotes ("). The _second_ a later times the same CSV file is opened, this may be relaxed to the previous settings for that file, but perhaps that's a separate bug, so let's start with just the default. Settings which are orthogonal to the CSV spec should behave... actually, I'm not entirely sure what to recommend here.