Difference between revisions of "Calc/Features/Numbers import for plain text files"
m (→Detailed Specification) |
(→Detailed Specification: added some text.) |
||
Line 59: | Line 59: | ||
== Detailed Specification == | == Detailed Specification == | ||
[[file:CsvImportOptionsDlg.png|300px|thumb|center|Modified CSV import options dialog with new controls.]] | [[file:CsvImportOptionsDlg.png|300px|thumb|center|Modified CSV import options dialog with new controls.]] | ||
− | [[file:TextImportOptionsDlg.png|300px|thumb|center| | + | [[file:TextImportOptionsDlg.png|300px|thumb|center|Import options dialog for HTML import.]] |
+ | |||
+ | === Language === | ||
+ | Language (and regions in case the language is associated with multiple regions) determines how the number strings are parsed during import. If the language option is set to Default (in the CSV Options dialog) or Automatic (in the HTML Import Options dialog), Calc uses the language that OOo uses globally. If the language option is set to a specific language, that language is used for parsing numbers. | ||
+ | |||
+ | === Detect special numbers === | ||
+ | When this option is enabled, Calc will automatically detect all number formats, including special number formats such as dates. When this option is disabled, Calc will detect and convert decimal numbers only while the rest will be imported as strings. A decimal number string can have digits 0-9, thousands separators (aka group separators), and a decimal separator. Thousands separators and decimal separators may vary with the selected language and region. | ||
== Migration == | == Migration == |
Revision as of 20:28, 6 August 2009
Contents
Numbers import for plain text files
Specification Status | |
Author | Kohei Yoshida |
Last Change | See wiki history |
Status | In progress in CWS koheicsvimport |
Abstract
References
Reference Document | Check | Location (URL) |
Issue ID (required) | available | Issue 3687 Issue 97416 Issue 102141 |
Test case specification (required) | n/a |
Contacts
Role | Name | E-Mail Address |
Developer | Kohei Yoshida | kyoshida@novell.com |
Quality Assurance | Oliver Craemer | oliver.craemer@sun.com |
Documentation | up for grabs | |
User Experience | up for grabs |
Detailed Specification
Language
Language (and regions in case the language is associated with multiple regions) determines how the number strings are parsed during import. If the language option is set to Default (in the CSV Options dialog) or Automatic (in the HTML Import Options dialog), Calc uses the language that OOo uses globally. If the language option is set to a specific language, that language is used for parsing numbers.
Detect special numbers
When this option is enabled, Calc will automatically detect all number formats, including special number formats such as dates. When this option is disabled, Calc will detect and convert decimal numbers only while the rest will be imported as strings. A decimal number string can have digits 0-9, thousands separators (aka group separators), and a decimal separator. Thousands separators and decimal separators may vary with the selected language and region.
Migration
N/A
Configuration
File Format
N/A