4.1-048 07/14/2010 [fix] implemented (forgotten) update method for updating sheets starting at a different position 4.1-046 06/11/2010 [chg] changed libraries to support (backward) compatibility between (beta) releases 4.1-044 05/05/2010 [chg] made several changes to fix security issue with latest Java release [fix] corrected issue with reading date object from excel sheet 4.1-040 01/29/2010 [new] introduced setSheetName(workbook, index/name, new name) [new] introduced addSheet(workbook, sheetIndex/sheetName) [new] introduced removeSheet(workbook, sheetIndex/sheetName) [new] introduced moveSheet(workbook, oldIndex, newIndex) [new] introduced cloneSheet(workbook, sheetIndex/sheetName) [new] getSheetNames now works with fileName (already available) as well as with a workbook (new) [chg] improved Framework to work with external (gui and command-line) installer [chg] when writing a datetime cell the format is now automatically set [fix] corrected issue with writing an array with unknown data types [fix] corrected issue with writing null cells in xlsx format [fix] corrected issue with text encoding format [fix] corrected issue with column width (last colum width was not set) [fix] corrected issue with sheetNames not used with setting data [fix] corrected issue with readWorkbook(...) delivering an empty workbook [fix] corrected issue with writeWorkbook(...) throwing an error 4.0-032 08/17/2009 [chg] deprecated flushClientsCache, use DatabaseManager instead 4.0-031 07/28/2009 [chg] removed signature from core-common.jar to avoid security issues 4.0-030 03/16/2009 [chg] it is not longer necessary to register a developer license 4.0-029 01/19/2009 [chg] made some adjustments to core activation wizard 4.0-027 12/05/2008 [fix] it is now possible to write a correct .xlsx file 4.0-027 12/05/2008 [fix] corrected license issue 4.0-026 10/30/2008 [chg] improved license feedback in log file [fix] corrected issue with formatted cell background not used correct [fix] corrected issue with writing xlxs file [fix] changed a couple of core functions 4.0-025 10/30/2008 [fix] corrected issue with client not finding libraries. 4.0-024 10/22/2008 [fix] preference panel 'Components' is now available again 4.0-023 10/21/2008 [new] output is now also possible in xlxs format [new] added createUserColor method to change a user color to be used for setting colors [bug] output to xlxs format could cause an issue [fix] corrected issue with Eclipse update manager 3.4-020 08/16/2008 [fix] corrected startup file for client loaded from application server 3.4-019 06/30/2008 [chg] redesigned for Servoy 4.0 3.3-018 04/22/2008 [chg] made some important improvements to the core to prepare for Servoy 4.0 3.3-016 02/25/2008 [new] added method 'getVersionLicensed' to find out what version is licensed [chg] reading a date formatted cell now returns Date Object instead of double [chg] reduced client download size for resources with overall savings up to 45% [fix] writing a new file with overwrite = false (default) now does not write 2 files anymore 3.3-015 12/19/2007 [chg] improved sample code to adopt some changes 3.3-014 09/19/2007 [new] added createFont() method to FormattedDataSet [fix] removed debugging output from dataset [chg] added more font samples to sample solution 3.3-013 [fix] solved an issue with reading and typecasting excel sheet cells 3.3-012 [fix] excel().writeArray(...) writes header again 3.3-011 [chg] went back to older version of apache-poi [chg] corrected FormattedDataSet.addRow(index, array) to accept an index beyond rowCount 3.3-010 [new] introduced ExcelColor class with 48 predefined color codes [chg] added latest version of apache-poi [bug] when you use custom colors only the first defined color will be used 3.3-009 [fix] corrected bug in 'setValue(..)' method of FormattedDataSet 3.3-008 [new] added 'addRow(..)' method to FormattedDataSet [new] added 'removeRow(..)' method to FormattedDataSet [new] added 'setRow(..)' method to FormattedDataSet [new] added 'getColumnName(...)' method to FormattedDataSet [new] added 'setValue(..)' method to FormattedDataSet [new] added 'getValue(...)' method to FormattedDataSet [new] added 'setCellFormula(..)' method to FormattedDataSet [chg] added setCellFormula to sample solution [chg] the write method for an excel sheet does not accept a JSFile anymore (should be an absolutePath) 3.3-007 [new] added 'quote' property to write TXT files [new] added FormattedDataSet to write Excel files [chg] added FormattedDataSet sample to sample solution [fix] tooltips in classes are available again 3.1-007 [chg] improved feedback about missing data libraries [chg] it is now possible to create a really empty row [''] 3.1-006 [new] case 0000099: added setSheetName(String sheetname) to add a sheetName to a sheet [new] added getVersion() and getLicense() methods to retrieve component information [chg] the Plug-in is now lazy loading (again) [chg] updated sample solution to show writeArray intstead of write method for writing an Array 3.0-004 [new] case 0000023: added new WorkBook write/read options to Excel class to update an existing sheet without losing formatting, functions etc. 3.0-003 [chg] added the plug-in to the new Update manager [fix] fixed issue with using sheets [fix] fixed issue that did not return the correct column count after reading an xml [fix] fixed issue where empty values were not returned after reading an xml [fix] modified latest excel libraries so that they now also work with Servoy 2.x.x [new] added writeHeader property to CSV class to enable or disable writing of the header 3.0 [new] added option to update an existing excel sheet 2.0.1 [fix] corrected a bug that prevented the plug-in from registering a second time [enh] dialog feedback when license data is wrong [fix] fixed issue with update checker on windows platform 2.0 [new] added QuickBooks contact import and export [new] added functions to filter a DataSet [new] added encoding to read .csv and .txt files [enh] added new sample code to sample solution 1.2 [opt] optimized some of the code [bug] fixed a bug where the excel import stopped importing when a cell was empty [fix] corrected sample code 1.1 [new] added TXT (tab delimited) file support. [enh] added separator property to csv file support. [new] added sample solution [enh] improved sample code in plug-in 1.0 [new] initial