X-Git-Url: https://pintos-os.org/cgi-bin/gitweb.cgi?a=blobdiff_plain;f=tests%2Flanguage%2Fdata-io%2Fget-data-spreadsheet.at;h=28b9686c863b4b64efba5bc8b3bf3967633f8a8a;hb=30e8709a43952db775843e3e72c9f51462ffc82e;hp=19b8964dcacdf4b8c2e980edfbfe2badd3534c88;hpb=2f7b367bf796c63c595ac837b716cce535ffd5bf;p=pspp
diff --git a/tests/language/data-io/get-data-spreadsheet.at b/tests/language/data-io/get-data-spreadsheet.at
index 19b8964dca..28b9686c86 100644
--- a/tests/language/data-io/get-data-spreadsheet.at
+++ b/tests/language/data-io/get-data-spreadsheet.at
@@ -147,6 +147,22 @@ vone,vtwo,vthree,v4
])
AT_CLEANUP
+dnl This syntax doesn't do anything particularly useful.
+dnl It has been seen to cause a few crashes, so we check here that it
+dnl doesn't do anthing bad.
+AT_SETUP([GET DATA /TYPE=$1 with no options])
+SPREADSHEET_TEST_PREP($1)
+AT_DATA([get-data.sps], [dnl
+* This sheet is empty
+GET DATA /TYPE=$1 /FILE='testsheet'.
+DISPLAY DICTIONARY.
+LIST.
+])
+AT_CHECK([pspp -o pspp.csv get-data.sps], [0], [ignore])
+AT_CLEANUP
+
+
+
AT_SETUP([GET DATA /TYPE=$1 with empty sheet])
SPREADSHEET_TEST_PREP($1)
AT_DATA([get-data.sps], [dnl
@@ -175,6 +191,206 @@ AT_BANNER([GET DATA Spreadsheet /TYPE=GNM])
CHECK_SPREADSHEET_READER([GNM])
+dnl Check for a bug where gnumeric files were interpreted incorrectly
+AT_SETUP([GET DATA /TYPE=GNM sheet index bug])
+AT_DATA([minimal3.gnumeric],[dnl
+
+
+
+
+ Sheet1
+ Sheet2
+ Sheet3
+
+
+
+ Sheet1
+ 2
+ 3
+
+
+ Print_Area
+ #REF!
+ A1
+
+
+ Sheet_Title
+ "Sheet1"
+ A1
+
+
+
+
+
+
+
+
+
+
+ Name
+ x
+ y
+ Sheet One
+ 1
+ 2
+ foo
+ 3
+ 4
+ bar
+ 5
+ 6
+
+
+
+ Sheet2
+ 2
+ 2
+
+
+ Print_Area
+ #REF!
+ A1
+
+
+ Sheet_Title
+ "Sheet2"
+ A1
+
+
+
+
+
+
+
+
+
+
+
+ Comment
+ DOB
+ wealth
+ Sheet Two
+ 24/5/1966
+ 0.02
+ wee
+ 37145
+ 3000
+
+
+
+ Sheet3
+ 2
+ 2
+
+
+ Print_Area
+ #REF!
+ A1
+
+
+ Sheet_Title
+ "Sheet3"
+ A1
+
+
+
+
+
+
+
+
+
+
+ 3
+ 4
+ 5
+ 6
+ 7
+ 8
+ 9
+ 10
+ 11
+
+
+
+
+])
+
+AT_DATA([gnum.sps], [dnl
+GET DATA
+ /TYPE=GNM
+ /FILE='minimal3.gnumeric'
+ /SHEET=index 3
+ /READNAMES=off
+ .
+
+LIST.
+])
+
+AT_CHECK([pspp -O format=csv gnum.sps], [0], [dnl
+Table: Data List
+VAR001,VAR002,VAR003
+3 ,4.00,5.00
+6 ,7.00,8.00
+9 ,10.00,11.00
+])
+
+
+AT_CLEANUP
+
+
+dnl Check for a bug where certain gnumeric files failed an assertion
+AT_SETUP([GET DATA /TYPE=GNM assert-fail])
+AT_DATA([read.sps],[dnl
+GET DATA
+ /TYPE=GNM
+ /FILE='crash.gnumeric'
+ .
+list.
+])
+
+
+AT_DATA([crash.gnumeric],[dnl
+
+
+
+
+
+ Sheet1
+
+
+
+ Sheet1
+ 2
+ 4
+
+
+
+
+
+
+
+ one
+ two
+ 1
+ 2
+ 1
+ 2
+ 1
+ 2
+
+
+
+
+])
+
+AT_CHECK([pspp -O format=csv read.sps], [0], [ignore])
+
+
+AT_CLEANUP
+
+
+
AT_BANNER([GET DATA Spreadsheet /TYPE=ODS])
CHECK_SPREADSHEET_READER([ODS])