diff options
Diffstat (limited to 'helpcontent2/source/text/shared/00/00000208.xhp')
| -rw-r--r-- | helpcontent2/source/text/shared/00/00000208.xhp | 27 |
1 files changed, 26 insertions, 1 deletions
diff --git a/helpcontent2/source/text/shared/00/00000208.xhp b/helpcontent2/source/text/shared/00/00000208.xhp index f4171df4ec..fe47971b17 100644 --- a/helpcontent2/source/text/shared/00/00000208.xhp +++ b/helpcontent2/source/text/shared/00/00000208.xhp @@ -6,7 +6,7 @@ *********************************************************************** * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. - * + * * Copyright 2000, 2010 Oracle and/or its affiliates. * * OpenOffice.org - a multi-platform office productivity suite @@ -53,6 +53,14 @@ <paragraph role="heading" id="hd_id3147588" xml-lang="en-US" level="2" l10n="U" oldref="45">Import</paragraph> <bookmark xml-lang="en-US" branch="hid/sc:ListBox:RID_SCDLG_ASCII:LB_CHARSET" id="bm_id3155934" localize="false"/><paragraph role="heading" id="hd_id3154788" xml-lang="en-US" level="3" l10n="U" oldref="9">Character Set</paragraph> <paragraph role="paragraph" id="par_id3149495" xml-lang="en-US" l10n="U" oldref="10"><ahelp hid="SC:LISTBOX:RID_SCDLG_ASCII:LB_CHARSET">Specifies the character set to be used in the imported file.</ahelp></paragraph> + + +<bookmark xml-lang="en-US" branch="hid/sc:ListBox:RID_SCDLG_ASCII:LB_CUSTOMLANG" id="bm_id315593499" localize="false"/><paragraph role="heading" id="hd_id315478899" xml-lang="en-US" level="3" l10n="NEW">Language</paragraph> +<paragraph role="paragraph" id="par_id314949588" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Determines how the number strings are imported.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id314949587" xml-lang="en-US" l10n="NEW">If Language is set to Default (for CSV import) or Automatic (for HTML import), Calc will use the globally set language. If Language is set to a specific language, that language will be used when importing numbers.</paragraph> +<paragraph role="paragraph" id="par_id314949586" xml-lang="en-US" l10n="NEW">When importing an HTML document, the Language selection can conflict with the global HTML option <link href="text/shared/optionen/01030500.xhp" name="Use">Use 'English (USA)' locale for numbers</link>. The global HTML option is effective only when the Automatic language option is selected. If you select a specific language in the HTML Import Options dialog, the global HTML option is ignored.</paragraph> + + <bookmark xml-lang="en-US" branch="hid/sc:NumericField:RID_SCDLG_ASCII:NF_AT_ROW" id="bm_id3153377" localize="false"/><paragraph role="heading" id="hd_id3154894" xml-lang="en-US" level="3" l10n="U" oldref="47">From Row</paragraph> <paragraph role="paragraph" id="par_id3150247" xml-lang="en-US" l10n="U" oldref="48"><ahelp hid="SC:NUMERICFIELD:RID_SCDLG_ASCII:NF_AT_ROW">Specifies the row where you want to start the import.</ahelp> The rows are visible in the preview window at the bottom of the dialog.</paragraph> <paragraph role="heading" id="hd_id3149999" xml-lang="en-US" level="2" l10n="U" oldref="3">Separator Options</paragraph> @@ -76,6 +84,23 @@ <paragraph role="paragraph" id="par_id3153827" xml-lang="en-US" l10n="U" oldref="60"><ahelp hid="SC:CHECKBOX:RID_SCDLG_ASCII:CB_ASONCE">Combines consecutive delimiters and removes blank data fields.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/sc:ComboBox:RID_SCDLG_ASCII:CB_TEXTSEP" id="bm_id3147619" localize="false"/><paragraph role="heading" id="hd_id3155341" xml-lang="en-US" level="3" l10n="U" oldref="15">Text delimiter</paragraph> <paragraph role="paragraph" id="par_id3156326" xml-lang="en-US" l10n="CHG" oldref="16"><ahelp hid="SC:COMBOBOX:RID_SCDLG_ASCII:CB_TEXTSEP">Select a character to delimit text data. You can can also enter a character in the text box.</ahelp></paragraph> + + + +<paragraph role="heading" id="hd_id315538811" xml-lang="en-US" level="2" l10n="NEW">Other options</paragraph> +<paragraph role="paragraph" id="par_id315366511" xml-lang="en-US" l10n="NEW">Sets some other import options.</paragraph> +<bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCDLG_ASCII:CB_QUOTED_AS_TEXT" id="bm_id315790911" localize="false"/> +<paragraph role="heading" id="hd_id314847411" xml-lang="en-US" level="3" l10n="NEW">Quoted fields as text</paragraph> +<paragraph role="paragraph" id="par_id314995711" xml-lang="en-US" l10n="NEW"><ahelp hid=".">When this option is enabled, fields or cells whose values are quoted in their entirety (the first and last characters of the value equal the text delimiter) are imported as text.</ahelp></paragraph> + +<bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCDLG_ASCII:CB_DETECT_SPECIAL_NUMBER" id="bm_id315790922" localize="false"/> +<paragraph role="heading" id="hd_id314847422" xml-lang="en-US" level="3" l10n="NEW">Detect special numbers</paragraph> +<paragraph role="paragraph" id="par_id314995722" xml-lang="en-US" l10n="NEW"><ahelp hid=".">When this option is enabled, Calc will automatically detect all number formats, including special number formats such as dates, time, and scientific notation.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id314995723" xml-lang="en-US" l10n="NEW">The selected language influences how such special numbers are detected, since different languages and regions many have different conventions for such special numbers.</paragraph> +<paragraph role="paragraph" id="par_id314995724" xml-lang="en-US" l10n="NEW">When this option is disabled, Calc will detect and convert only decimal numbers. The rest, including numbers formatted in scientific notation, will be imported as text. A decimal number string can have digits 0-9, thousands separators, and a decimal separator. Thousands separators and decimal separators may vary with the selected language and region.</paragraph> + + + <paragraph role="heading" id="hd_id3155388" xml-lang="en-US" level="2" l10n="U" oldref="61">Fields</paragraph> <paragraph role="paragraph" id="par_id3153665" xml-lang="en-US" l10n="U" oldref="62">Shows how your data will look when it is separated into columns.</paragraph> <bookmark xml-lang="en-US" branch="hid/sc:ListBox:RID_SCDLG_ASCII:LB_TYPE1" id="bm_id3157909" localize="false"/><paragraph role="heading" id="hd_id3148474" xml-lang="en-US" level="3" l10n="U" oldref="63">Column type</paragraph> |