2 m4_define([SPREADSHEET_TEST_PREP],[dnl
4 AT_CHECK([gzip -c $top_srcdir/tests/language/data-io/Book1.gnm.unzipped > Book1.gnumeric])dnl
5 m4_define([testsheet],[Book1.gnumeric])dnl
6 AT_SKIP_IF([test n$GNM_SUPPORT != nyes])dnl
9 AT_CHECK([cp $top_srcdir/tests/language/data-io/test.ods test.ods])dnl
10 m4_define([testsheet],[test.ods])dnl
11 AT_SKIP_IF([test n$ODF_READ_SUPPORT != nyes])dnl
15 m4_define([CHECK_SPREADSHEET_READER],
17 AT_SETUP([GET DATA /TYPE=$1 with CELLRANGE])
18 SPREADSHEET_TEST_PREP($1)
19 AT_DATA([get-data.sps], [dnl
20 GET DATA /TYPE=$1 /FILE='testsheet' /READNAMES=off /SHEET=name 'This' /CELLRANGE=range 'g9:i13' .
24 AT_CHECK([pspp -o pspp.csv get-data.sps])
25 AT_CHECK([cat pspp.csv], [0], [dnl
26 Variable,Description,,Position
27 VAR001,Format: F8.2,,1
29 ,Display Alignment: Right,,
33 ,Display Alignment: Left,,
35 VAR003,Format: F8.2,,3
37 ,Display Alignment: Right,,
50 AT_SETUP([GET DATA /TYPE=$1 with CELLRANGE and READNAMES])
51 SPREADSHEET_TEST_PREP($1)
52 AT_DATA([get-data.sps], [dnl
53 GET DATA /TYPE=$1 /FILE='testsheet' /READNAMES=on /SHEET=name 'This' /CELLRANGE=range 'g8:i13' .
57 AT_CHECK([pspp -o pspp.csv get-data.sps])
58 AT_CHECK([cat pspp.csv], [0], [dnl
59 Variable,Description,,Position
62 ,Display Alignment: Right,,
66 ,Display Alignment: Left,,
68 VAR001,Format: F8.2,,3
70 ,Display Alignment: Right,,
83 AT_SETUP([GET DATA /TYPE=$1 without CELLRANGE])
84 SPREADSHEET_TEST_PREP($1)
85 AT_DATA([get-data.sps], [dnl
86 GET DATA /TYPE=$1 /FILE='testsheet' /SHEET=index 3.
90 AT_CHECK([pspp -o pspp.csv get-data.sps])
91 AT_CHECK([cat pspp.csv], [0], [dnl
92 Variable,Description,,Position
95 ,Display Alignment: Left,,
99 ,Display Alignment: Right,,
101 height,Format: F8.2,,3
103 ,Display Alignment: Right,,
115 AT_SETUP([GET DATA /TYPE=$1 with missing data])
116 SPREADSHEET_TEST_PREP($1)
117 AT_DATA([get-data.sps], [dnl
118 * This sheet has no data in one of its variables
119 GET DATA /TYPE=$1 /FILE='testsheet' /READNAMES=on /SHEET=index 5.
123 AT_CHECK([pspp -o pspp.csv get-data.sps])
124 AT_CHECK([cat pspp.csv], [0], [dnl
125 Variable,Description,,Position
128 ,Display Alignment: Right,,
132 ,Display Alignment: Right,,
136 ,Display Alignment: Left,,
140 ,Display Alignment: Right,,
150 AT_SETUP([GET DATA /TYPE=$1 with empty sheet])
151 SPREADSHEET_TEST_PREP($1)
152 AT_DATA([get-data.sps], [dnl
153 * This sheet is empty
154 GET DATA /TYPE=$1 /FILE='testsheet' /SHEET=name 'Empty'.
156 AT_CHECK([pspp -o pspp.csv get-data.sps], [0], [dnl
157 warning: Selected sheet or range of spreadsheet `testsheet' is empty.
161 AT_SETUP([GET DATA /TYPE=$1 with nonexistent sheet])
162 SPREADSHEET_TEST_PREP($1)
163 AT_DATA([get-data.sps], [dnl
164 * This sheet doesnt exist.
165 GET DATA /TYPE=$1 /FILE='testsheet' /SHEET=name 'foobarxx'.
167 AT_CHECK([pspp -o pspp.csv get-data.sps], [0], [dnl
168 warning: Selected sheet or range of spreadsheet `testsheet' is empty.
174 AT_BANNER([GET DATA Spreadsheet /TYPE=GNM])
176 CHECK_SPREADSHEET_READER([GNM])
178 AT_BANNER([GET DATA Spreadsheet /TYPE=ODS])
180 CHECK_SPREADSHEET_READER([ODS])