Created attachment 47738 [details] current default settings The first time I used open office I had trouble because I went to open a csv file and it was very confusing. This confusing was caused by the default selections. When opening a csv file the default delimiters are semicolon and space... not comma. I think the default delimiter should be a comma for csv files. Thanks You guys are awesome -J
Created attachment 47739 [details] proposed default settings
The request souds logical because of the file type name COMMA separated values, and also <http://tools.ietf.org/html/rfc4180> only mentions comma as separator. But in countries where the decimal separator is a comma people would not be very happy with comma column separator. I can not confirm reporter's default settings, I see comma + semicolon + blank selected aa delimiters, but that might not be LibO default but remembered from a former csv import. My LibO remembers latest used settings for separators as default for next import, and I believe that is a very good solution. Most users will have to import csv files always from the same source and so with the same delimiters. Currently I can't see any bug here, if no new information will be contributed, I will close this report.
I don't think other countries use a decimal as delimiter. I found this link on an EU site <http://www.eea.europa.eu/data-and-maps/data/reference-waterbase-groundwater/reference-waterbase-groundwater-chemical-quality-data/chemicals_groundwater.csv> When I open a csv file with another well known spreadsheet software it doesn't even give me an import window. It just opens with comma as a delimiter. I think defaults should be assumed for a standardized file like csv and the options should be shown if the user selected to import the file. I believe this is a major issue and more people should weigh in. When I first used Libre Office I saw this as it was broken and not that it was very accommodating to other countries.
RC2 is bit by bit identical with release version, so separate items in the version picker are useless. Changes have been discussed with Michael Meeks.
Please consider to implement a more general approach like described in 38637 - Better handling for csv-Files
The approach on the bug cited in the previous comment is simply to auto-detect the separator, which is probably possible and definitely the best option. FWIW, Excel 2007 in French uses ";" as separator, which wouldn't play well with "," as a default, even if the CSV standard says the contrary.
[This is an automated message.] This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it started right out as NEW without ever being explicitly confirmed. The bug is changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases. Details on how to test the 3.5.0 beta1 can be found at: http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1 more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
(In reply to comment #6) > The approach on the bug cited in the previous comment is simply to auto-detect > the separator, which is probably possible and definitely the best option. Auto-detection is doomed to fail in many situations, consider the following data: This is one field; but it continues here, and here, as the field separator is a TAB However, what we can do is to initially preselect the separators comma, tab and semicolon, and not space.
In master http://cgit.freedesktop.org/libreoffice/core/commit/?id=58e562e730485e860dfe484cdc09c67f1d73dc5a