# \[Announcement\] Table bean 3.0 released

**URL:** <https://forum.servoy.com/t/announcement-table-bean-3-0-released/11525>\
**Category:** Classic Servoy\
**Created:** [December 18, 2009, 8:41am UTC](https://forum.servoy.com/t/announcement-table-bean-3-0-released/11525 "2009-12-18T08:41:18Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![patrick](https://avatars.discourse-cdn.com/v4/letter/p/b2d939/32.png) [@patrick](https://forum.servoy.com/u/patrick)\
**Post date:** [December 18, 2009, 8:41am UTC](https://forum.servoy.com/t/announcement-table-bean-3-0-released/11525/1 "2009-12-18T08:41:18Z")

</div>

We are proud to release version 3.0 of our Table bean. Version 3 is a major rewrite of the rendering and editing possibilities of the bean.

As shown in the screenshot below, a single cell can contain almost anything that was only possible on a per column base before:

 ![](https://canada1.discourse-cdn.com/flex010/uploads/servoy/original/2X/0/0bd666bf30725aad7eca57d9b53755ec17cf2178.png)

To enable this new functionality, we have introduced a CellFormat object. A CellFormat offers many formatting properties such as

- text alignment, color and font
- background color
- cell border
- editable property

CellFormats also allow to control the renderer and editor of a cell:

- normal text
- text areas
- dates
- numbers
- checkbox
- combobox
- value list

CellFormats can be applied to rows, columns or single cells. To ease handling, CellFormats can be named and reused. Here is a small code example on how to use a CellFormat (a more complex example can be found in the sample solution):

var vMyFormat = elements.tablebean.createCellFormat(‘myFormat’;  
vMyFormat.alignment = 2;  
vMyFormat.font = ‘Tahoma,1,11’;  
vMyFormat.border = ‘LineBorder,1,#efefef’;  
elements.tablebean.setFormatForCell(1,1,vMyFormat);

Among the many other new features of the Table bean are the following:

- lazy loading foundsets: instead of loading all records from a foundset into memory, a foundsetGrid can be made “lazy loading”. That means, that only 200 records at a time are loaded. Whenever the user scrolls down, another 200 are loaded etc. One important implication of that is that sorting has to be done by the database, so a lazy loading foundset cannot be sorted on unstored calculations. Please not that lazy loading foundsets do not work in Servoy 5.0.0, but any other version.
- support for display and editing formats for date and number cells: just like a Servoy field, the table bean now accepts formats in a displayFormat|editingFormat syntax.
- incorrect entries in number and date fields are displayed in red
- value list fields are no longer read only: if you set a value list on a field, not combobox will be shown. If the user starts editing such a field, then a combobox editor will be presented.
- support for methods instead of calculations for background color, foreground color and font in a foundsetGrid (please note that in Servoy 5 only methods are supported and calculations will no longer work)
- support for Servoy border style strings: border styles can be copied from a form property and assigned to the bean (e.g. ‘LineBorder,1,#000000’)

Please note that Table bean 3.0 is (our first ever) paid update, so it requires a new license key. Update licenses can be obtained from our [shop](http://www.servoy-plugins.de/shop.html).

---

<div class="post-metadata">

**Author:** ![ptalbot](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/ptalbot/32/4952_2.png) [@ptalbot](https://forum.servoy.com/u/ptalbot)\
**Post date:** [December 18, 2009, 1:51pm UTC](https://forum.servoy.com/t/announcement-table-bean-3-0-released/11525/2 "2009-12-18T13:51:00Z")

</div>

Looks nice. Great work!

Is there a trial available for that bean?

---

<div class="post-metadata">

**Author:** ![Karel\_Broer](https://avatars.discourse-cdn.com/v4/letter/k/bcef8e/32.png) [@Karel\_Broer](https://forum.servoy.com/u/Karel_Broer)\
**Post date:** [December 18, 2009, 2:21pm UTC](https://forum.servoy.com/t/announcement-table-bean-3-0-released/11525/3 "2009-12-18T14:21:17Z")

</div>

Next to the DialogPro plugin is this Table bean definetly one of my most favorite -external- tool I use in Servoy. ![:)]( "Smile")  
Thanks for the update, Patrick!

---

<div class="post-metadata">

**Author:** ![ROCLASI](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/roclasi/32/4371_2.png) [@ROCLASI](https://forum.servoy.com/u/ROCLASI)\
**Post date:** [December 18, 2009, 2:23pm UTC](https://forum.servoy.com/t/announcement-table-bean-3-0-released/11525/4 "2009-12-18T14:23:56Z")

</div>

Hi Patrick (T),

> ptalbot:  
> Looks nice. Great work!
> 
> Is there a trial available for that bean?

You can get a trial license via their shop.

---

<div class="post-metadata">

**Author:** ![Karel\_Broer](https://avatars.discourse-cdn.com/v4/letter/k/bcef8e/32.png) [@Karel\_Broer](https://forum.servoy.com/u/Karel_Broer)\
**Post date:** [January 5, 2010, 11:34am UTC](https://forum.servoy.com/t/announcement-table-bean-3-0-released/11525/5 "2010-01-05T11:34:29Z")

</div>

The CellFormat option in the new Table bean 3 is really great.  
Something I often run into and could not do (without using advanced HTML), was showing different field types at each row.  
This is possible now! Yeah! ![:D]( "Very Happy")

Together with the DialogPro plugin you can even create an on-the-fly dialog with a table where you can use these features too.  
Perfect! I am a very satisfied customer. ![:)]( "Smile")