Table-Bean 1.5 released

Classic Servoy
1

Today we released version 1.5 of the Table-Bean. It adds significant improvements to drag and drop, new features that allow even more flexible formatting of tables and several other enhancements and bug fixes.

Drag and drop functionality has been greatly improved in these areas:

  • Dragging of several rows now behaves just like the Windows explorer or Macintosh finder
  • When dragging over a table, the rows are properly selected
  • A new getDropColumn() method allows to determine the exact cell a user drops onto and allow or reject drops on a per cell basis; the corresponding getDragColumn() has also been implemented
    In the FoundsetGrid it is now possible to format single cells by providing calculations, just like Servoy’s own table view allows to set the background color:
  • a rowFGColorCalculation property let’s developers control the font color
  • a rowFontCalculation property can be set to control the font
  • these two calculations as well as the already present rowBGColorCalculation now also receive the dataprovider name (the column) as argument; that makes it possible to control background, foreground and font on a per cell basis depending on the content of a field, as shown in this example (a creation date older than two years is formatted in a different color and font):


Version 1.5 also adds these new methods and properties:

  • columnOrder property to get and set the column order. This makes it possible to save and restore the column order a user has arranged.
  • a moveColumn() method can be used to programatically move columns after the table has been created
  • using setOnActionForColumn() a method can be fired if the user clicks on a cell of that column
  • tables will auto scroll if the selected index is not currently visible
  • sortColumn() allows to sort a table by method
  • getSortColumns() and getSortOrder() can be called to retrieve the current sort
  • setAlignmentForColumn() now also works with combobox and number columns
  • convertDataIndexToView() and convertViewIndexToData() allow to convert between visible and data index in sorted tables
    For a full list of new methods, changes and bug fixes see the version history at the bottom of the Table-Bean page. The update is free to registered users and can be obtained from the our website.
2

patrick:
In the FoundsetGrid it is now possible to format single cells by providing calculations, just like Servoy’s own table view allows to set the background color:

  • a rowFGColorCalculation property let’s developers control the font color
  • a rowFontCalculation property can be set to control the font
  • these two calculations as well as the already present rowBGColorCalculation now also receive the dataprovider name (the column) as argument; that makes it possible to control background, foreground and font on a per cell basis depending on the content of a field, as shown in this example (a creation date older than two years is formatted in a different color and font):

Excellent features, Patrick! Thank you!