Matrex is a vectorial spreadsheet. It is better than usual spreadsheets when working with large amounts of data coming from databases, files, or networks. It is strongly multithreaded, expandable, and improves readability. It has adapters to Matlab, Scilab, Octave, and R.
| Tags | Scientific/Engineering Visualization Office/Business Financial Spreadsheet |
|---|---|
| Licenses | GPLv3 |
| Operating Systems | Unix Windows Windows Mac OS X |
| Implementation | Java SWT |
Recent releases


Changes: This version works with Java 5 and Java 6 on Mac OS X thanks to SWT 3.5. Incompatibilities with Java 5 have been fixed together with some potential problems maximizing the main window.


Changes: This release has a project diagram, flexible configuration files, a project loading progress bar, a smart toolbar, and bugfixes.


Changes: New functions were added for Fourier transformations and a direct search solver. A "columns fit" button was added in the matrix and presentation viewer. A function viewer, high low charts, a plugins dialog, a search bar for the trees, and a menu to move items in a tree were added. A big part of the project is now covered by unit testing. GUI unit testing was added with SWTBot. The code was tested with Findbugs. ISQLLib is now a separated library. The class loader is based on configuration files.


Changes: The big step forward of this version is the new ISQL module. The ISQL module is a function template to apply SQL queries to vectors in a Matrex project. Other enhancements are the ability to print matrices and presentations, the ability to export matrices and presentations to CSV and XLS, and the ability to import data from a database using an SQL query. Menus were added to remove multiple items, duplicate matrices and functions, and add a function from a matrix (the function will have the matrix as the first argument). A summary step was added for the expression parser. The colors of the windows headers can be changed.


Changes: The purpose of this version is to make the system more open, easier to use, and complete. Matrex is now able to import xls (Excel) files. Context help was added. 2D charts support was improved. Operators are allowed in the expression parser.