What is CleanSheets?
CleanSheets is the first spreadsheet application that is both extensible and platform-independent. It features a formula language that closely resembles that of Microsoft Excel, and extensions for aiding end-user programmers.

System requirements
  • Java version 1.6.0 (tested with version 1.6.0ga5)


CleanSheets on an eComStation machine with Open JDK


Installing CleanSheets
Download csheets-1.4b.zip (1.2Mb). Open the zip file and copy the directory/map "CleanSheets" to a drive/directory of your choice. That's it!

The used cmd file
CleanSheets works with Open JDK in OS/2-eCS. I have a "csheets.cmd" file with the following contents; 
@echo off
SET BEGINLIBPATH=[drive: java]\JAVA160ga5\bin
SET path=[drive: java]\JAVA160ga5\bin
SET CLASSPATH=
[drive: CleanSheets]
cd [drive: CleanSheets]\CleanSheets
java -Duser.home=[drive: CleanSheets]\CleanSheets -jar .\lib\csheets.jar 2>CleanSheets-bugs.txt
I use 2 separate folders (directories), one for Java and one for CleanSheets with the files created by this program. The references used in the cmd file;

  • [drive: java] = drive with Java
  • [drive: CleanSheets] = drive with CleanSheets

should be replaced with real drive letters. Save the file and name it "csheets.cmd" or use the file from "cleansheets-ecs.zip", see below. This file is copied to the "CleanSheets" directory/map. Furthermore, different paths?, adjust according to your needs.
Create a new program object. Specify the path and file name: "[drive: CleanSheets]\CleanSheets\csheets.cmd". In the tabpage Session check the boxes "OS/2 window", "Running as an icon" and "Close Window to end program". In the tabpage General you can enter the name "CleanSheets". There is an OS/2 icon in the file "cleansheets-ecs.zip".

Parameters / options explained
  • The statement "-Duser.home=[drive: CleanSheets]\CleanSheets" will ensure that CleanSheets will save all necessary files in own directory instead of saving them in the home directory.
  • The addition "2>CleanSheets-bugs.txt" ensures that errors are saved in the file "CleanSheets-bugs.txt". The 2 in "2>" is not a typo! The file stays empty on my system.

Remarks with running CleanSheets
The program uses a file extension "cls" and for me that stands for "clear screen". The saved file resembles Microsoft Excel format 2007 and older. Its should be the same as XLS format, but I didn't try that. I'm used to drag my mouse over the area needed in a formula, but this is a no go in CleanSheets, you have to enter cell references manually. There are very basic style options, so you can add a line between cells, do something with the used font, do something with alignment. I was unable to insert or remove a column or a row. Also preferences and help do not work, both stay grayed out. That's about it. In OS/2 we have more spreadsheet programs which do much better.

Download
In the file you can find above command file (all drive letters are on set to C:) and an OS/2 CleanSheets icon: cleansheets-ecs.zip.

revision July 24, 2020