HISTORY: 20130806: Version 0.5.3 OdsFile: Added getMeta(). Added save(OutputStream output). Added getCell(final int nTab, final String sPos). Added getCell(final int nTab, final int nRow, final int nCol) 20120722: Version 0.5.2 Fixed a bug in OdsFile.setCellMerge() that prevented a correct number of cells to be merged. DateStlye: Added more date styles. OdsFile: Added setCellMergeInAllTables(int nRow, int nCol, int nRowMerge, int nColumnMerge). Added setCellMergeInAllTables(final String sPos, final int nRowMerge, final int nColumnMerge). TextStyle: Replaced setFontUnderlineStyle(final String nFontUnderline) with setFontUnderlineStyle(final int nFontUnderline). Replaced public String getFontUnderlineStyle() with public int getFontUnderlineStyle(). Added setFontSize(final int fontSize). Util: Renamed PositionToColumn to positionToColumn. Renamed PositionToRow to positionToRow Code cleanup. 20120713: Version 0.5.1 Added support for date cells. OdsFile(): Added support for merging cells. Added method setCellMerge(int nTab, String sPos, int nRowMerge, int nColumnMerge). Added method setCellMerge(int nTab, int nRow, int nCol, int nRowMerge, int nColumnMerge). Added method public void setCell(final int nTab, final String sPos, final Calendar cal, final TableStyle ts). Added method public void setCell(final int nTab, final int nRow, final int nCol, final Calendar cal, final TableStyle ts). Added method setCellInAllTables(final String sPos, final Calendar cal, final TableStyle ts). Added method setCellInAllTables(final int nRow, final int nCol, final Calendar cal, final TableStyle ts). Changed thrown Exceptions to SimpleOdsExceptions. 20120705: Version 0.5.0 Changed code to support the creation of multiple OdsFiles within one program. Due to a programming flaw, it was only possible to create one content for all files. This is fixed now but requires program changes. For every style you use, there is now a new parameter 'OdsFile o' which contains the file to which the style belongs. Example: OLD: NumberStyle nsPercantage = new NumberStyle("ns3"); NEW: NumberStyle nsPercantage = new NumberStyle("ns3", odsFile3a); Added OdsFile.getStyles(). Added OdsFile.setStyles(). Added TableStyle.setFontWrap(final boolean fSetWrap). Added TextStyle.setFontUnderline() and TextStyle.getFontUnderline(). Added TableSytle.setFontUnderline() and TextStyle.getFontUnderline(). Fixed a bug in TableStyle: Changed default 'column-width' for STYLE_TABLECOLUMN from 2,500cm to 2.5cm. 20110222: Small fixes to OdsFile.java: Moved ZipOutputStream out the save() method. 20100731: Version 0.4.4 Footer(): Added 'Paragraphs' Footer(): Added functions to add page number and page count field Some documentation fixes 20100725: Version 0.4.3 Added 'Footer' support, see example file Test3.java Added TextStyle() TableStyle(): Added setFontWeightItalic() OdsFile(): Removed setColumnStyle(String sTab,int nCol,TableStyle ts) Use method setColumnStyle(getTableNumber(sTab),int nCol,TableStyle ts) instead 20100117: Version 0.4.2 OdsFile(): Fixed getName() to return the filename of the ODS file 20091201: Version 0.4.1 PageStyle(): Changed some functions to return String instead of StringBuffer Added setBackgroundColor() 20091130: Version 0.4 Added a PageStyle that can be changed. 20080810: Version 0.3 Added methods to add a cell by the cell coordinate like 'A1'. 20080622: Version 0.2.1 TableCell(): Fixed a typo STYLE_PERCENATGE to STYLE_PERCENTAGE CurrencyStyle(): added method setCurrencySymbolPosition() and getCurrencySymbolPosition(), as well as constants CurrencyStyle.SYMBOLPOSITION_BEGIN and CurrencyStyle.SYMBOLPOSITION_END NumberStyle(): added methods set/getLanguage() and set/getCountry() OdsFile(): added method setCell(int nRow,int nCol,String value), the cell value type is TableCell.STYLE_STRING added method setCell(int nRow,int nCol,String value,TableStyle ts) , the cell value type is TableCell.STYLE_STRING added method setCell(int nRow,int nCol,int value), the cell value type is TableCell.STYLE_FLOAT added method setCell(int nRow,int nCol,int value,TableStyle ts) , the cell value type is TableCell.STYLE_FLOAT added method setCell(int nRow,int nCol,double value), the cell value type is TableCell.STYLE_FLOAT added method setCell(int nRow,int nCol,double value,TableStyle ts) , the cell value type is TableCell.STYLE_FLOAT deprecated method setCell(String sTab,int nRow,int nCol,int nValuetype,String sValue) deprecated method setCell(String sTab,int nRow,int nCol,int nValuetype,String sValue,TableStyle ts) deprecated method setCellStyle(String sTab,int nRow,int nCol,TableStyle ts) deprecated method setColumnStyle(String sTab,int nCol,TableStyle ts) instead of String sTab use the following now: nTab=getTableNumber(sTableName); setCell(nTab,nRow,nCol,nValueType,sValue); 20080525: Version 0.2 Some comment corrections. Added the NumberStyle class. Added the CurrencyStyle class. TableStyle(): added method getStyleType(). changed sWrap to bWrap. fixed a bug, that generated an illegal document after adding more then one time the same BorderStyle.POSITION. Content(): changed the cell default name from ce1 to Default. renamed method setCellInTable() to setCell(). OdsFile(): added ConfigItem ViewIdHasSheetTabs. added ConfigItem ViewIdIsOutlineSymbolsSet. added function setCellInAllTables(). removed addTableStyle(), this is done automatic by TableStyle() now. changed setCell(), parameter String sValueType changed to int nValueType, use TableStyle.STYLE_STRING, TableStyle.STYLE_FLOAT,TableStyle.STYLE_PERCENATGE or TableStyle.STYLE_CURRENCY instead. e.g. odsFile.setCell(nTable, 1, 6, "string","XXX",ceColor1); is now odsFile.setCell(nTable, 1, 6, TableCell.STYLE_STRING,"XXX",ceColor1); renamed all methods setCellInTable() to setCell(). Util(): added and changed some COLOR static names. added helper function toXML() which converts non-ASCII character to a XML coding,e.g. '�' becomes €. added helper function dateToday(). added helper function createHexColor().