Spreadsheet Portlet

Product Overview

The Spreadsheet portlet provides a completely customisable data table/grid functionality. The potential uses for this portlet are only limited by one's imagination. For example it could be used to as a way to record a dynamically editable task list, with columns defined for task name, description, priority and due date. Or it could be utilised to record project expenses, with columns for expense description, price and purchase date.

The portlet's core function is to display and provide row-level editing of a single dataset. These Datasets are created and modified via the portet's preferences page. A dataset consists of a unique name and one or more columns. Each column has a name and data type constraint plus optional display properties. All datasets defined and the data subsequently entered are persisted in a RDBMS.

Data entry permissions are controlled via extensions to the standard Liferay permissions framework. For example, it is possible to allow portal users to add new rows to the spreadsheet, but only members of the community in which the portlet is deployed to be permitted to edit or delete existing rows (there is a limitation to this however - guest users are not allowed to modify the portlet or its contents in any way).

Data entered by users is interactively validated against the columns data type, eg. the portlet will prevent entry of a letters in a column defined as being numeric.

Features

  • Provides user friendly and intuituve Spreadsheet like functionality
  • Define and edit custom datasets to be displayed and edited via the portlet
  • Datasets can apply basic validation constraints to user's input on a per-column basis
  • Multi user data entry
  • Dataset data is persisted in an RDBMS
  • Configurable permissions for portlet configuration and data entry

Supported Technologies

The Spreadsheet Portlet has been tested to work in the following environments:

Deployment:

  • Liferay 6.0.6, Tomcat bundle
  • Liferay 6.1.0, Tomcat bundle

Client browser:

  • Microsoft Internet Explorer 7, 8 & 9
  • Mozilla Firefox 4 & 5
  • Google Chrome 12
  • Opera 11
  • Safari 5

Database:

  • MySQL 5.1
  • PostgeSQL 8.4
View the Demo Download the Free Trial Buy Now