To start GLASS, run the glass.exe executable on Windows, or glass on Linux or
MacOS.
How to load a GSS spread sheet file:
To load an existing GSS file, you may use the format.
glass [file] [option]
Example:
c:\temp\glass\glass book1.gss n
The command line paramater n will launch the file in "normal mode"
If a file name is given, both paramaters are required.
If starting a new book manually, just have an empty gss file that ends with
the line "stp 0 0 0 0 0".
If you need to see if the gss file is being parsed correctly, replace the
n paramater with d. This will run GLASS in debug mode.
Working with formulas.
Note: The GLASS engine will not process numbers in a cell, if the cell content
has been marked as a string and not a number.
Formulas:
Valid formulas:
=avg( ) average value of 2 or more number values
example:
=avg(a1:a7)
=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
Example of =sum( )
=sum(a1,a7)
will add two cells a1 and a7
=sum(a1:a7)
will add all the cells starting with a1 to a7.
Note: any entry in a cell that you don't want to get saved, prefix with
double underscores: __