diff options
Diffstat (limited to 'source/text/shared/00/00000208.xhp')
| -rw-r--r-- | source/text/shared/00/00000208.xhp | 13 |
1 files changed, 10 insertions, 3 deletions
diff --git a/source/text/shared/00/00000208.xhp b/source/text/shared/00/00000208.xhp index 0e6ce5b98e..38cdfd518b 100644 --- a/source/text/shared/00/00000208.xhp +++ b/source/text/shared/00/00000208.xhp @@ -108,11 +108,18 @@ <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/textimportcsv/detectspecialnumbers" id="bm_id315790922" localize="false"/> <h3 id="hd_id314847422">Detect special numbers</h3> -<paragraph id="par_id314995722" role="paragraph" xml-lang="en-US"><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 id="par_id314995722" role="paragraph" xml-lang="en-US"><ahelp hid=".">When this option is enabled, Calc will automatically detect all number formats, including special number formats such as dates and time. Scientific notation will also be detected as <emph>Detect scientific notation</emph> option must be enabled at the same time.</ahelp></paragraph> <paragraph id="par_id314995723" role="paragraph" xml-lang="en-US">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 id="par_id314995724" role="paragraph" xml-lang="en-US">When this option is disabled, Calc will detect and convert only numbers in decimal or scientific notation. The rest 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> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/textimportcsv/skipemptycells" id="bm_id315790923" localize="false"/> +<paragraph id="par_id314995724" role="paragraph" xml-lang="en-US">When this option is disabled, Calc will detect and convert only numbers in decimal notation. Detection of numbers in scientific notation will depend on <emph>Detect scientific notation</emph> option. The rest 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> + +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/textimportcsv/detectscientificnumbers" id="bm_id315790921" localize="false"/> +<h3 id="hd_id314847423">Detect scientific notation</h3> +<paragraph id="par_id314995721" role="paragraph" xml-lang="en-US"><ahelp hid=".">When this option is enabled, Calc will automatically detect numbers with scientific notation, like 5E2 for 500.</ahelp></paragraph> +<paragraph id="par_id314995726" role="paragraph" xml-lang="en-US">The selected language influences how scientific notation is detected, since different languages and regions many have different decimal separator.</paragraph> +<paragraph id="par_id314995727" role="paragraph" xml-lang="en-US">This option can be be disabled only if <emph>Detect special numbers</emph> option is previously disabled.</paragraph> +<paragraph id="par_id314995728" role="paragraph" xml-lang="en-US">When this option is disabled, Calc will detect and convert only numbers in decimal notation. The rest 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> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/textimportcsv/skipemptycells" id="bm_id315790923" localize="false"/> <h3 id="hd_id171220172142361711">Skip empty cells</h3> <paragraph id="par_id171220172144419125" role="paragraph" xml-lang="en-US"><ahelp hid=".">Available when using <menuitem>Paste Special</menuitem>: when this option is enabled, Calc preserves previous content of cells when pasting empty ones. Otherwise, Calc deletes content of previous cells.</ahelp></paragraph> <paragraph id="par_id171220172156279613" role="paragraph" xml-lang="en-US">In <emph>Text to Columns</emph> conversion, if cell content begins with a separator and this option is disabled, then first column will be emptied.</paragraph> |