summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorEike Rathke <erack@redhat.com>2012-04-04 20:57:22 +0200
committerEike Rathke <erack@redhat.com>2012-04-04 20:57:42 +0200
commit58e562e730485e860dfe484cdc09c67f1d73dc5a (patch)
treeb5236e055039979308b895d2585903cc853cf91e
parent61af0e1c3c1c9003c741d64840f9b6f39ea87ead (diff)
fdo#33088 better CSV import default separators
-rw-r--r--officecfg/registry/schema/org/openoffice/Office/Calc.xcs2
-rw-r--r--sc/source/ui/dbgui/scuiasciiopt.cxx2
2 files changed, 2 insertions, 2 deletions
diff --git a/officecfg/registry/schema/org/openoffice/Office/Calc.xcs b/officecfg/registry/schema/org/openoffice/Office/Calc.xcs
index 700d7165d13e..0cd2ff32ec37 100644
--- a/officecfg/registry/schema/org/openoffice/Office/Calc.xcs
+++ b/officecfg/registry/schema/org/openoffice/Office/Calc.xcs
@@ -1098,7 +1098,7 @@
<desc>List of Separators - as a String</desc>
<label>Separators</label>
</info>
- <value>; </value>
+ <value>,;&#9;</value>
</prop>
<prop oor:name="TextSeparators" oor:type="xs:string" oor:nillable="false">
<info>
diff --git a/sc/source/ui/dbgui/scuiasciiopt.cxx b/sc/source/ui/dbgui/scuiasciiopt.cxx
index 93d5cfcf6b15..2a3a2b949579 100644
--- a/sc/source/ui/dbgui/scuiasciiopt.cxx
+++ b/sc/source/ui/dbgui/scuiasciiopt.cxx
@@ -268,7 +268,7 @@ ScImportAsciiDlg::ScImportAsciiDlg( Window* pParent,String aDatName,
SetText( aName );
// Default options
- OUString sFieldSeparators(RTL_CONSTASCII_USTRINGPARAM("\t"));
+ OUString sFieldSeparators(RTL_CONSTASCII_USTRINGPARAM(",;\t"));
OUString sTextSeparators(mcTextSep);
bool bMergeDelimiters = false;
bool bFixedWidth = false;