Remotegrid is a spreadsheet component for edit and view of tabularly-structured documents. It works in offline mode with local file storage and application server on the J2SE/J2EE (JBoss 4, SLSB, BMP) platform.
Main grid implemented features are:
Cell and text colors.
Cell margins.
Cell split/merging.
Multiple cell selection.
Copy/paste cell fragments.
Cell formulas.
Charts with JFreeChart.
User interface components embedding with editing support.
Database grid data storage in hi-resolution mode (cells, styles, spans, ... etc in a table record).
Formulas evaluation in different modes: forward (on-update) evaluation, backward evaluation (all-in-one-transaction) evaluation in offline and application server modes.
Component layout modification: insert/remove rows and columns.
Formula refactoring support (need primarily for grid layout modifications).
Notification about data updates through JMS.
Web-view of grid data (as html tables with css).
In the application server mode component supports multiuser multithreaded edition/viewing.
This project is not intended to be a replacement for desktop spreadsheet applications. It's intended to provide lightweight, highly configurable and customizable solution for enterprise information systems.
This project codebase partially based on JGrid code (jeppers.sourceforge.net).