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