[ooo-build-commit] test/csv

Kohei Yoshida kohei at kemper.freedesktop.org
Wed Jul 15 17:47:35 PDT 2009

 test/csv/README |   52 ++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 52 insertions(+)

New commits:
commit 3561294798a5bc3e0c426a43538d40d930f1517a
Author: Kohei Yoshida <kyoshida at novell.com>
Date:   Wed Jul 15 20:43:30 2009 -0400

    Added README for csv test documents.
    * test/csv/README:

diff --git a/test/csv/README b/test/csv/README
new file mode 100644
index 0000000..db30bcb
--- /dev/null
+++ b/test/csv/README
@@ -0,0 +1,52 @@
+= CSV Import Test Instructions =
+== Test Documents Naming Convention ==
+There are two types of csv test files included in this directory.  The ones 
+prefixed by "space_" are space-separated csv files, while those prefixed by 
+"fixed_" are fixed width csv's.  
+The files contain three types of number formats: 1-1 (num_dash_num), 1.1 
+(num_dot_num) and 1,1 (num_comma_num).  Also, the ones ending with "_quoted" 
+have their values quoted.  
+== When Importing Each File == 
+Import each file with and without the "Quoted field as text" option, and with 
+and without "Detect special numbers" option.  Also import using at minimum, 
+'English (USA)' and 'French (France)' as the Language.  
+== Importing Fixed Width CSV with Quoted Values ==
+When importing a fixed-width CSV file with quoted values, set the "Separator 
+options" to "Fixed width", and set partitions between the quoted values.
+== Importing Space-Separated CSV ==
+Set the "Separator options" to "Separated by", and check "Space" check box and 
+"Text delimiter" to '"' (double quote).  
+== Language ==
+Selecting different languages affects how thousands separators and decimal 
+separators are interpreted.  For example, selecting 'French (France)' expects 
+a valid number to be formatted as "123 456,789" whereas in 'English (USA)' the 
+same number is expressed as "123,456.789".  In 'English (USA)', the thousands 
+and decimal separators are ',' and '.' respectively, while in 'French 
+(France)' they are ' ' and ',', respectively.  
+== Quoted Field as Text ==
+When this option is checked, any quoted value (such as "1.34") is imported as 
+text, without automatic conversion to numeric value.  Since all texts 
+internally carry a value of 0, performing arithmetic on such value always 
+yields zero.  That's one way to test whether a cell has a text or a number.  
+Also, using ISTEXT or ISNUMBER cell function is helpful in determining whether 
+the value is text or number.  
+== Detect Special Numbers ==
+With this option checked, Calc tries to detect special numbers such as dates, 
+scientific notations etc.  For instance, a value such as 1-1 will be converted 
+to date using 'English (USA)' as the language, and a value such as 1.1 will be 
+converted to date using 'French (France)', and so on.  

More information about the ooo-build-commit mailing list