Hi, Am 23.07.2012 09:00, schrieb Zhe Liu:
Hi, I use Calc to open a csv. "Text Import" dialog pops up. Semicolon & Space are checked by default as separators. Most of csv files in the world use comma as separator, right? I prefer comma. In addition, when I use AOO to save a csv, I found the default separator is comma. When I reopen the csv, I have to change separator to comma. IMHO, it's a bad experience.
defined in https://tools.ietf.org/html/rfc4180 the default separator should be a comma. I'm not sure why AOO does it differently but there must be a reason to do it like this. Maybe Eike Rathke knows more about the reason. (CCed him)
Kind regards, Joost
