The first line of the GSS 1.0 file should be the 'version data' and the 'info data'.

Example:

gss1.0 112

After the first line, all other lines should be lines of data.

The GSS 1.0 spreadsheet format consists of lines of data of 6 fields, separated 
by a space.

The first field of a data line is the data type lead field.


ssp lead field The global spreadsheet book properties are controlled by the ssp lead field. The next 5 fields will contain general properties of the book. Field #2, after the ssp field, is the decimal point field. This is how many places to show after the decimal point. valid numbers are 0 to 6. Field #3 is if the default width of the cell. Valid numbers are 7 to 11. Any entry larger or smaller will default to the smallest allowed or largest allowed. Field #4 is if formula cells are highlighted or not. 0 = off, 1 = yellow highlighted cells that contain formulas 2 = blue highlighted cells that contain formulas Field #5 is the general properties field. 0 = blue text and black background (column head) 1 = blue text and white background (column head) Field #6, the last field, for the ssp lead field is the name of the spreadsheet. Example: ssp 2 10 1 0 Accounting
des lead field Data lines with formulas and strings will use the des lead field. Field #2 is column number Field #3 is row number Field #4 is general properties field. Field #5 is the text color. 0 = white 1 = red 2 = green 3 = yellow 4 = blue 5 = magenta 6 = cyan 7 = white Field #6 is the value. Examples: des 5 7 0 0 =avg(a1:c3) des 6 7 0 0 Average Valid formulas: =avg( ) average value of 2 or more number values =cou( ) count - counts the number of numbers in a range. =flr( ) floor - rounds down number to whole value =max( ) max value of 2 or more values =min( ) min value of 2 or more values =sum( ) sum of 2 or more values Fomulas will only process cells marked as numbers stored as numbers like with den
den lead field Data lines with numbers use the den lead field. Field #2 is column number Field #3 is row number Field #4 is general properties field. Field #5 is the text color. 0 = white 1 = red 2 = green 3 = yellow 4 = blue 5 = magenta 6 = cyan 7 = white Field #6 is the value. Examples: den 1 2 0 0 999.25 den 2 1 0 0 123
stp lead field End of file should end with the stp lead field. Example: stp 0 0 0 0 0