What is Jeks?
Jeks is a Java® spreadsheet based on the Swing® JTable component and the JeksParser library computing mathematical expressions.

Features;
  • Edition of formulas in cells using a rich set of operators and functions.
  • Edition of parameterized functions using expressions defined by users.
  • Optimized calculation using a compiled version of formulas and functions.
  • Checking of circular reference in formulas.
  • Optimized update of formulas referencing other cells.
  • Cut / Copy / Paste with automatic shift of cell references in formulas.
  • Internationalization of the spreadsheet and of the syntax in formulas.
  • Save / Open files at spreadsheet format.
  • User's guide.
  • Reusability : Your existing model of data or table can be easily enriched to include features of Jeks.
  • Extensibility : As the component JTable, Jeks can be extended to include more features (cell attributes, charts,...).

System requirements
  • Minimum JRE: 1.4.2


Jeks on an eComStation machine with Open JDK


Installing Jeks
Download jeks_1.0.2.zip. Make a new directory/map with the name "jeks" on your drive. Open the zip file and you see the directory/map "jeks_1.0.2". Open this directory/map. Open the "bin" directory/map and copy the files "Budget.jks" and "Loan.jks" to the new created directory/map "jeks". You don't need the "*.bat" or the "*.sh" files because they don't work in our system. The html file is for starting the program JeksDisplay in a browser, but for now this seems a no go with our version of Java. Next copy the directory/map "images" to the new created directory/map "jeks". Open the "lib" directory/map and copy everything to the new created directory/map "jeks". That is if you want that the supplied commandfiles below do work.

The used cmd file
Jeks works with Open JDK in OS/2-eCS. I have a "jeks.cmd" file with the following contents; 
@echo off
rem Java 1.4.2
rem SET JAVA_HOME=[drive: java]\JAVA142
rem set BEGINLIBPATH=[drive: java]\JAVA142\bin
rem set path=[drive: java]\JAVA142\bin
rem Java 1.6.0
rem set PATH=[drive: java]\JAVA160\bin
rem set BEGINLIBPATH=[drive: java]\JAVA160\bin
rem Java 1.6.0ga5
set BEGINLIBPATH=[drive: java]\JAVA160ga5\bin
set path=[drive: java]\JAVA160ga5\bin
set CLASSPATH= 
[drive: jeks]
cd [drive: jeks]\jeks
java -Duser.home=[drive: jeks]\jeks -cp jeks.jar com.eteks.jeks.JeksFrame 2>jeksbugs.txt
I use 2 separate folders (directories), one for Java and one for Jeks. The references used in the cmd file;

  • [drive: java] = drive with Java
  • [drive: jeks] = drive with Jeks

should be replaced with real drive letters. Save the file and name it "jeks.cmd" or use the file from the distribution. This file is copied to the "jeks" folder (directory). Furthermore, different paths?, adjust according to your needs.
In the commandfile sample you see also remmed lines for other Java versions. If you want to use one of those versions you need to remove the "rem" and rem the lines of Java160ga5. I did test the program with Java142 and with Java160ga5.

Create a new program object. Specify the path and file name: "[drive: jeks]\jeks\jeks.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 "Jeks".

Parameters / options explained
  • The addition "2>jeksbugs.txt" ensures that errors are saved in the file "jeksbugs.txt". The 2 in "2>" is not a typo! The files stays empty on my system.

When you open the zipfile "jeks-ecs.zip" you also will find the files "jekscalc.cmd" and "jekspt.cmd". The file "jekscalc.cmd" is setup similar way as the one above, only the line starting with "java..." differs. This commandfile starts a calculator.

Jeks calculator on an eComStation machine with Open JDK


The other file "jekspt.cmd" does a performance test. The file is setup similar way to the above, with again that the last line starting with "java..." differs. This application can be used to compare the computing average speed of different functions parsed with JeksParser and their Java counterpart function with a speed meter dialog box. See picture below. I still do everything on a P4 single core and I don't know if what is presented is slow or fast, I don't mind.

Jeks performance test on an eComStation machine with Open JDK


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

revision May 5, 2017