org.simpleods

Class OdsFile

java.lang.Object

org.simpleods.OdsFile

public class OdsFile
extends java.lang.Object

Author:

Martin Schulz
Copyright 2008-2013 Martin Schulz
This file OdsFile.java is part of SimpleODS.
0.5.1 Changed all 'throw Exception' to 'throw SimpleOdsException'.
0.5.3 Added getMeta(). Added getCell(final int nTab, final String sPos). Added getCell(final int nTab, final int nRow, final int nCol)

Constructor Summary

Constructors

Constructor and Description
OdsFile(java.lang.String sName) Create a new ODS file.

Method Summary

Methods

Modifier and Type	Method and Description
boolean	addTable(java.lang.String sName) Add a new table to the file, the new table is set to the active table.
TableCell	getCell(int nTab, int nRow, int nCol) Get the TableCell object.
TableCell	getCell(int nTab, java.lang.String sPos) Get the TableCell object.
Content	getContent()
PageStyle	getDefaultPageStyle()
Footer	getFooter() Returns the current footer.
Header	getHeader() Returns the current header.
Meta	getMeta() Get the Meta data for this OdsFile.
java.lang.String	getName() The filename of the spreadsheet file.
Styles	getStyles()
java.lang.String	getTableName(int n) Returns the name of the table.
int	getTableNumber(java.lang.String sName) Search a table by name and return its number.
int	lastTableNumber() Gets the number of the last table.
boolean	newFile(java.lang.String sName) Create a new,empty file, use addTable to add tables.
boolean	save() Save the new file.
boolean	save(java.io.OutputStream output) Save the new file.
boolean	setActiveTable(int nTab) Set the active table, this is the table that is shown if you open the file.
void	setActiveTable(java.lang.String sName) Set the active table , this is the table that is shown if you open the file.
void	setCell(int nTab, int nRow, int nCol, java.util.Calendar cal) Sets the cell value in table nTab to the date from the Calendar object.
void	setCell(int nTab, int nRow, int nCol, java.util.Calendar cal, TableStyle ts) Sets the cell value in table nTab to the date from the Calendar object.
void	setCell(int nTab, int nRow, int nCol, double dValue) Sets the cell value in Table nTab to the given value, the value type is TableCell.STYLE_FLOAT.
void	setCell(int nTab, int nRow, int nCol, double dValue, TableStyle ts) Sets the cell value in table nTab to the given value, the value type is TableCell.STYLE_FLOAT.
void	setCell(int nTab, int nRow, int nCol, int nValue) Sets the cell value in Table nTab to the given value, the value type is TableCell.STYLE_FLOAT.
void	setCell(int nTab, int nRow, int nCol, int nValuetype, java.lang.String sValue) Sets the cell value in Table nTab to the given values.
void	setCell(int nTab, int nRow, int nCol, int nValuetype, java.lang.String sValue, TableStyle ts) Sets the cell value in Table nTab to the given values.
void	setCell(int nTab, int nRow, int nCol, int nValue, TableStyle ts) Sets the cell value in Table nTab to the given value, the value type is TableCell.STYLE_FLOAT.
void	setCell(int nTab, int nRow, int nCol, java.lang.String sValue) Sets the cell value in Table nTab to the given value, the value type is TableCell.STYLE_STRING.
void	setCell(int nTab, int nRow, int nCol, java.lang.String sValue, TableStyle ts) Sets the cell value in Table nTab to the given value, the value type is TableCell.STYLE_STRING.
void	setCell(int nTab, java.lang.String sPos, java.util.Calendar cal) Sets the cell value in table nTab to the date from the Calendar object.
void	setCell(int nTab, java.lang.String sPos, java.util.Calendar cal, TableStyle ts) Sets the cell value in table nTab to the date from the Calendar object.
void	setCell(int nTab, java.lang.String sPos, double dValue) Sets the cell value in Table nTab to the given value, the value type is TableCell.STYLE_FLOAT.
void	setCell(int nTab, java.lang.String sPos, double dValue, TableStyle ts) Sets the cell value in table nTab to the given value, the value type is TableCell.STYLE_FLOAT.
void	setCell(int nTab, java.lang.String sPos, int nValue) Sets the cell value in Table nTab to the given value, the value type is TableCell.STYLE_FLOAT.
void	setCell(int nTab, java.lang.String sPos, int nValuetype, java.lang.String sValue) Sets the cell value in Table nTab to the given values.
void	setCell(int nTab, java.lang.String sPos, int nValuetype, java.lang.String sValue, TableStyle ts) Sets the cell value in Table nTab to the given values.
void	setCell(int nTab, java.lang.String sPos, int nValue, TableStyle ts) Sets the cell value in Table nTab to the given value, the value type is TableCell.STYLE_FLOAT.
void	setCell(int nTab, java.lang.String sPos, java.lang.String sValue) Sets the cell value in Table nTab to the given value, the value type is TableCell.STYLE_STRING.
void	setCell(int nTab, java.lang.String sPos, java.lang.String sValue, TableStyle ts) Sets the cell value in Table nTab to the given value, the value type is TableCell.STYLE_STRING.
void	setCell(java.lang.String sTab, int nRow, int nCol, int nValuetype, java.lang.String sValue) Deprecated. As of release 0.2.1, use getTableNumber(String) instead setCell("Tab2",1,1,"stringvalue") use setCell(getTableNumber("Tab2"),1,1,"stringvalue")
void	setCell(java.lang.String sTab, int nRow, int nCol, int nValuetype, java.lang.String sValue, TableStyle ts) Deprecated. As of release 0.2.1, use getTableNumber(String) instead e.g.setCell("Tab2",1,1,"stringvalue") use setCell(getTableNumber("Tab2"),1,1,"stringvalue")
void	setCellInAllTables(int nRow, int nCol, java.util.Calendar cal, TableStyle ts) Sets the cell value in all tables to the date from the Calendar object.
void	setCellInAllTables(int nRow, int nCol, int nValuetype, java.lang.String sValue, TableStyle ts) Sets the cell value in all tables to the given values.
void	setCellInAllTables(java.lang.String sPos, java.util.Calendar cal, TableStyle ts) Sets the cell value in all tables to the date from the Calendar object.
void	setCellInAllTables(java.lang.String sPos, int nValuetype, java.lang.String sValue, TableStyle ts) Sets the cell value in all tables to the given values.
void	setCellMerge(int nTab, int nRow, int nCol, int nRowMerge, int nColumnMerge) Set the merging of multiple cells to one cell.
void	setCellMerge(int nTab, java.lang.String sPos, int nRowMerge, int nColumnMerge) Set the merging of multiple cells to one cell.
void	setCellMergeInAllTables(int nRow, int nCol, int nRowMerge, int nColumnMerge) Set the merging of multiple cells to one cell.
void	setCellMergeInAllTables(java.lang.String sPos, int nRowMerge, int nColumnMerge) Set the merging of multiple cells to one cell in all existing tables.
void	setCellStyle(int nTab, int nRow, int nCol, TableStyle ts) Sets the style of this table cell.
void	setCellStyle(int nTab, java.lang.String sPos, TableStyle ts) Sets the style of this table cell.
void	setCellStyle(java.lang.String sTab, int nRow, int nCol, TableStyle ts) Deprecated. As of release 0.2.1, use getTableNumber(String) instead setCellStyle("Tab2",1,1,"stringvalue") use setCellStyle(getTableNumber("Tab2"),1,1,"stringvalue")
void	setColumnStyle(int nTab, int nCol, TableStyle ts) Sets the style of this table column.
void	setContent(Content cont) Set a new content to this OdsFile.
void	setFooter(Footer f) Sets a new footer object, any earlier footer that was set will be reset and the new footer is used.
void	setHeader(Header h) Sets a new header object, any earlier header that was set will be reset and the.
void	setStyles(Styles s) Set the styles for this ODsFile to styles.

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

OdsFile

public OdsFile(java.lang.String sName)

Create a new ODS file.

Parameters:

sName - - The filename for this file, if this file exists it is overwritten

Method Detail

newFile

public boolean newFile(java.lang.String sName)

Create a new,empty file, use addTable to add tables.

Parameters:

sName - - The filename of the new spreadsheet file, if this file exists it is overwritten

Returns:

False, if filename is a directory

getName

public java.lang.String getName()

The filename of the spreadsheet file.

Returns:

The filename of the spreadsheet file

save

public boolean save()

Save the new file.

Returns:

true - the file was saved
false - an exception happened

save

public boolean save(java.io.OutputStream output)

Save the new file.

Parameters:

output - The OutputStream that should be used.

Returns:

true - the file was saved
false - an exception happened

getMeta

public Meta getMeta()

Get the Meta data for this OdsFile.

Returns:

The meta data

setActiveTable

public void setActiveTable(java.lang.String sName)

Set the active table , this is the table that is shown if you open the file.

Parameters:

sName - The table name, this table should already exist, otherwise the first table is shown

setActiveTable

public boolean setActiveTable(int nTab)

Set the active table, this is the table that is shown if you open the file.

Parameters:

nTab - The table number, this table should already exist, otherwise the first table is shown

Returns:

true - The active table was set, false - nTab has an illegal value

addTable

public boolean addTable(java.lang.String sName)
                 throws SimpleOdsException

Add a new table to the file, the new table is set to the active table.
A maximum of 256 table per file is supported.
Use setActiveTable to override the current active table, this has no influence to
the program, the active table is the first table that is shown in OpenOffice.

Parameters:

sName - - The name of the table to add

Returns:

true - The table was added,
false - The table already exist, it was added again

Throws:

SimpleOdsException

setCell

public void setCell(java.lang.String sTab,
           int nRow,
           int nCol,
           int nValuetype,
           java.lang.String sValue)
             throws SimpleOdsException

Deprecated. As of release 0.2.1, use getTableNumber(String)
instead setCell("Tab2",1,1,"stringvalue") use setCell(getTableNumber("Tab2"),1,1,"stringvalue")

Sets the cell value in Table sTab to the given values.

Parameters:

sTab - The table name, this table must already exist

nRow - The row, 0 is the first row

nCol - The column, 0 is the first column

nValuetype - The value type of sValue, TableCell.STYLE_STRING,TableCell.STYLE_FLOAT or TableCell.STYLE_PERCENTAGE

sValue - The value to set the cell to

Throws:

SimpleOdsException

setCell

public void setCell(int nTab,
           int nRow,
           int nCol,
           int nValuetype,
           java.lang.String sValue)
             throws SimpleOdsException

Sets the cell value in Table nTab to the given values.

Parameters:

nTab - The table number, this table must already exist, 0 is the first table

nRow - The row, 0 is the first row

nCol - The column, 0 is the first column

nValuetype - The value type of sValue, TableCell.STYLE_STRING,TableCell.STYLE_FLOAT or TableCell.STYLE_PERCENTAGE

sValue - The value to set the cell to

Throws:

SimpleOdsException

setCell

public void setCell(int nTab,
           java.lang.String sPos,
           int nValuetype,
           java.lang.String sValue)
             throws SimpleOdsException

Sets the cell value in Table nTab to the given values.

Parameters:

nTab - The table number, this table must already exist, 0 is the first table

sPos - The cell position e.g. 'A1'

nValuetype - The value type of sValue, TableCell.STYLE_STRING,TableCell.STYLE_FLOAT or TableCell.STYLE_PERCENTAGE

sValue - The value to set the cell to

Throws:

SimpleOdsException

setCell

public void setCell(java.lang.String sTab,
           int nRow,
           int nCol,
           int nValuetype,
           java.lang.String sValue,
           TableStyle ts)
             throws SimpleOdsException

Deprecated. As of release 0.2.1, use getTableNumber(String)
instead e.g.setCell("Tab2",1,1,"stringvalue") use setCell(getTableNumber("Tab2"),1,1,"stringvalue")

Sets the cell value in Table sTab to the given values.

Parameters:

sTab - The table name, this table must already exist

nRow - The row, 0 is the first row

nCol - The column, 0 is the first column

nValuetype - The value type of sValue, TableCell.STYLE_STRING,TableCell.STYLE_FLOAT or TableCell.STYLE_PERCENTAGE.

sValue - The value to set the cell to

ts - The table style for this cell, must be of type TableStyle.STYLEFAMILY_TABLECELL

Throws:

SimpleOdsException

setCell

public void setCell(int nTab,
           int nRow,
           int nCol,
           int nValuetype,
           java.lang.String sValue,
           TableStyle ts)
             throws SimpleOdsException

Sets the cell value in Table nTab to the given values.

Parameters:

nTab - The table number, this table must already exist, 0 is the first table.

nRow - The row, 0 is the first row

nCol - The column, 0 is the first column

nValuetype - The value type of sValue, TableCell.STYLE_STRING,TableCell.STYLE_FLOAT or TableCell.STYLE_PERCENTAGE.

sValue - The value to set the cell to

ts - The table style for this cell, must be of type TableStyle.STYLEFAMILY_TABLECELL

Throws:

SimpleOdsException

setCell

public void setCell(int nTab,
           java.lang.String sPos,
           int nValuetype,
           java.lang.String sValue,
           TableStyle ts)
             throws SimpleOdsException

Sets the cell value in Table nTab to the given values.

Parameters:

nTab - The table number, this table must already exist, 0 is the first table

sPos - The cell position e.g. 'A1'

nValuetype - The value type of sValue, TableCell.STYLE_STRING,TableCell.STYLE_FLOAT or TableCell.STYLE_PERCENTAGE.

sValue - The value to set the cell to

ts - The table style for this cell, must be of type TableStyle.STYLEFAMILY_TABLECELL

Throws:

SimpleOdsException

setCell

public void setCell(int nTab,
           int nRow,
           int nCol,
           java.lang.String sValue)
             throws SimpleOdsException

Sets the cell value in Table nTab to the given value, the value type is TableCell.STYLE_STRING.

Parameters:

nTab - The table number, this table must already exist, 0 is the first table

nRow - The row, 0 is the first row

nCol - The column, 0 is the first column

sValue - The value to set the cell to

Throws:

SimpleOdsException

setCell

public void setCell(int nTab,
           java.lang.String sPos,
           java.lang.String sValue)
             throws SimpleOdsException

Sets the cell value in Table nTab to the given value, the value type is TableCell.STYLE_STRING.

Parameters:

nTab - The table number, this table must already exist, 0 is the first table

sPos - The cell position e.g. 'A1'

sValue - The value to set the cell to

Throws:

SimpleOdsException

setCell

public void setCell(int nTab,
           int nRow,
           int nCol,
           java.lang.String sValue,
           TableStyle ts)
             throws SimpleOdsException

Sets the cell value in Table nTab to the given value, the value type is TableCell.STYLE_STRING.

Parameters:

nTab - The table number, this table must already exist, 0 is the first table

nRow - The row, 0 is the first row

nCol - The column, 0 is the first column

sValue - The value to set the cell to

ts - The table style for this cell, must be of type TableStyle.STYLEFAMILY_TABLECELL

Throws:

SimpleOdsException

setCell

public void setCell(int nTab,
           java.lang.String sPos,
           java.lang.String sValue,
           TableStyle ts)
             throws SimpleOdsException

Sets the cell value in Table nTab to the given value, the value type is TableCell.STYLE_STRING.

Parameters:

nTab - The table number, this table must already exist, 0 is the first table

sPos - The cell position e.g. 'A1'

sValue - The value to set the cell to

ts - The table style for this cell, must be of type TableStyle.STYLEFAMILY_TABLECELL

Throws:

SimpleOdsException

setCell

public void setCell(int nTab,
           int nRow,
           int nCol,
           int nValue)
             throws SimpleOdsException

Sets the cell value in Table nTab to the given value, the value type is TableCell.STYLE_FLOAT.

Parameters:

nTab - The table number, this table must already exist, 0 is the first table

nRow - The row, 0 is the first row

nCol - The column, 0 is the first column

nValue - The value to set the cell to

Throws:

SimpleOdsException

setCell

public void setCell(int nTab,
           java.lang.String sPos,
           int nValue)
             throws SimpleOdsException

Sets the cell value in Table nTab to the given value, the value type is TableCell.STYLE_FLOAT.

Parameters:

nTab - The table number, this table must already exist, 0 is the first table

sPos - The cell position e.g. 'A1'

nValue - The value to set the cell to

Throws:

SimpleOdsException

setCell

public void setCell(int nTab,
           int nRow,
           int nCol,
           int nValue,
           TableStyle ts)
             throws SimpleOdsException

Sets the cell value in Table nTab to the given value, the value type is TableCell.STYLE_FLOAT.

Parameters:

nTab - The table number, this table must already exist, 0 is the first table

nRow - The row, 0 is the first row

nCol - The column, 0 is the first column

nValue - The value to set the cell to

ts - The table style for this cell, must be of type TableStyle.STYLEFAMILY_TABLECELL

Throws:

SimpleOdsException

setCell

public void setCell(int nTab,
           java.lang.String sPos,
           int nValue,
           TableStyle ts)
             throws SimpleOdsException

Sets the cell value in Table nTab to the given value, the value type is TableCell.STYLE_FLOAT.

Parameters:

nTab - The table number, this table must already exist, 0 is the first table

sPos - The cell position e.g. 'A1'

nValue - The value to set the cell to

Throws:

SimpleOdsException

setCell

public void setCell(int nTab,
           int nRow,
           int nCol,
           double dValue)
             throws SimpleOdsException

Sets the cell value in Table nTab to the given value, the value type is TableCell.STYLE_FLOAT.

Parameters:

nTab - The table number, this table must already exist, 0 is the first table

nRow - The row, 0 is the first row

nCol - The column, 0 is the first column

dValue - The value to set the cell to

Throws:

SimpleOdsException

setCell

public void setCell(int nTab,
           java.lang.String sPos,
           double dValue)
             throws SimpleOdsException

Sets the cell value in Table nTab to the given value, the value type is TableCell.STYLE_FLOAT.

Parameters:

nTab - The table number, this table must already exist, 0 is the first table

sPos - The cell position e.g. 'A1'

dValue - The value to set the cell to

Throws:

SimpleOdsException

setCell

public void setCell(int nTab,
           int nRow,
           int nCol,
           double dValue,
           TableStyle ts)
             throws SimpleOdsException

Sets the cell value in table nTab to the given value, the value type is TableCell.STYLE_FLOAT.

Parameters:

nTab - The table number, this table must already exist, 0 is the first table

nRow - The row, 0 is the first row

nCol - The column, 0 is the first column

dValue - The value to set the cell to

ts - The table style for this cell, must be of type TableStyle.STYLEFAMILY_TABLECELL

Throws:

SimpleOdsException

setCell

public void setCell(int nTab,
           java.lang.String sPos,
           double dValue,
           TableStyle ts)
             throws SimpleOdsException

Sets the cell value in table nTab to the given value, the value type is TableCell.STYLE_FLOAT.

Parameters:

nTab - The table number, this table must already exist, 0 is the first table

sPos - The cell position e.g. 'A1'

dValue - The value to set the cell to

ts - The table style for this cell, must be of type TableStyle.STYLEFAMILY_TABLECELL

Throws:

SimpleOdsException

setCell

public void setCell(int nTab,
           int nRow,
           int nCol,
           java.util.Calendar cal)
             throws SimpleOdsException

Sets the cell value in table nTab to the date from the Calendar object.

Parameters:

nTab - The table number, this table must already exist, 0 is the first table

nRow - The row, 0 is the first row

nCol - The column, 0 is the first column

cal - The calendar object with the date

Throws:

SimpleOdsException

setCell

public void setCell(int nTab,
           java.lang.String sPos,
           java.util.Calendar cal)
             throws SimpleOdsException

Sets the cell value in table nTab to the date from the Calendar object.

Parameters:

nTab - The table number, this table must already exist, 0 is the first table

sPos - The cell position e.g. 'A1'

cal - The calendar object with the date

Throws:

SimpleOdsException

setCell

public void setCell(int nTab,
           int nRow,
           int nCol,
           java.util.Calendar cal,
           TableStyle ts)
             throws SimpleOdsException

Sets the cell value in table nTab to the date from the Calendar object.

Parameters:

nTab - The table number, this table must already exist, 0 is the first table

nRow - The row, 0 is the first row

nCol - The column, 0 is the first column

cal - The calendar object with the date

ts - The table style for this cell, must be of type TableStyle.STYLEFAMILY_TABLECELL

Throws:

SimpleOdsException

setCell

public void setCell(int nTab,
           java.lang.String sPos,
           java.util.Calendar cal,
           TableStyle ts)
             throws SimpleOdsException

Sets the cell value in table nTab to the date from the Calendar object.

Parameters:

nTab - The table number, this table must already exist, 0 is the first table

sPos - The cell position e.g. 'A1'

cal - The calendar object with the date

ts - The table style for this cell, must be of type TableStyle.STYLEFAMILY_TABLECELL

Throws:

SimpleOdsException

getCell

public TableCell getCell(int nTab,
                int nRow,
                int nCol)
                  throws SimpleOdsException

Get the TableCell object.

Parameters:

nTab - The table number, this table must already exist, 0 is the first table

nRow - The row, 0 is the first row

nCol - The column, 0 is the first column

Returns:

The requested TableCell object.

Throws:

SimpleOdsException

getCell

public TableCell getCell(int nTab,
                java.lang.String sPos)
                  throws SimpleOdsException

Get the TableCell object.

Parameters:

nTab - The table number, this table must already exist, 0 is the first table

sPos - The cell position e.g. 'A1'

Returns:

The requested TableCell object.

Throws:

SimpleOdsException

setCellInAllTables

public void setCellInAllTables(int nRow,
                      int nCol,
                      int nValuetype,
                      java.lang.String sValue,
                      TableStyle ts)
                        throws SimpleOdsException

Sets the cell value in all tables to the given values.

Parameters:

nRow - The row, 0 is the first row

nCol - The column, 0 is the first column

nValuetype - The value type of sValue, TableCell.STYLE_STRING,TableCell.STYLE_FLOAT or TableCell.STYLE_PERCENTAGE.

sValue - The value to set the cell to

ts - The table style for this cell, must be of type TableStyle.STYLEFAMILY_TABLECELL

Throws:

SimpleOdsException

setCellInAllTables

public void setCellInAllTables(java.lang.String sPos,
                      int nValuetype,
                      java.lang.String sValue,
                      TableStyle ts)
                        throws SimpleOdsException

Sets the cell value in all tables to the given values.

Parameters:

sPos - The cell position e.g. 'A1'

nValuetype - The value type of sValue, TableCell.STYLE_STRING,TableCell.STYLE_FLOAT or TableCell.STYLE_PERCENTAGE.

sValue - The value to set the cell to

ts - The table style for this cell, must be of type TableStyle.STYLEFAMILY_TABLECELL

Throws:

SimpleOdsException

setCellInAllTables

public void setCellInAllTables(int nRow,
                      int nCol,
                      java.util.Calendar cal,
                      TableStyle ts)
                        throws SimpleOdsException

Sets the cell value in all tables to the date from the Calendar object.

Parameters:

nRow - The row, 0 is the first row

nCol - The column, 0 is the first column

cal - The calendar object with the date

ts - The table style for this cell, must be of type TableStyle.STYLEFAMILY_TABLECELL

Throws:

SimpleOdsException

setCellInAllTables

public void setCellInAllTables(java.lang.String sPos,
                      java.util.Calendar cal,
                      TableStyle ts)
                        throws SimpleOdsException

Sets the cell value in all tables to the date from the Calendar object.

Parameters:

sPos - The cell position e.g. 'A1'

cal - The calendar object with the date

ts - The table style for this cells, must be of type TableStyle.STYLEFAMILY_TABLECELL

Throws:

SimpleOdsException

setCellStyle

public void setCellStyle(java.lang.String sTab,
                int nRow,
                int nCol,
                TableStyle ts)
                  throws SimpleOdsException

Deprecated. As of release 0.2.1, use getTableNumber(String)
instead setCellStyle("Tab2",1,1,"stringvalue") use setCellStyle(getTableNumber("Tab2"),1,1,"stringvalue")

Sets the style of this table cell.

Parameters:

sTab - The table name, this table must already exist

nRow - The row, 0 is the first row

nCol - The column, 0 is the first column

ts - The table style to be used, must be of type TableStyle.STYLEFAMILY_TABLECELL

Throws:

SimpleOdsException

setCellStyle

public void setCellStyle(int nTab,
                int nRow,
                int nCol,
                TableStyle ts)
                  throws SimpleOdsException

Sets the style of this table cell.

Parameters:

nTab - The table number, this table must already exist

nRow - The row, 0 is the first row

nCol - The column, 0 is the first column

ts - The table style to be used, must be of type TableStyle.STYLEFAMILY_TABLECELL

Throws:

SimpleOdsException

setCellStyle

public void setCellStyle(int nTab,
                java.lang.String sPos,
                TableStyle ts)
                  throws SimpleOdsException

Sets the style of this table cell.

Parameters:

nTab - The table number, this table must already exist

sPos - The cell position e.g. 'A1'

ts - The table style to be used, must be of type TableStyle.STYLEFAMILY_TABLECELL

Throws:

SimpleOdsException

setCellMerge

public void setCellMerge(int nTab,
                int nRow,
                int nCol,
                int nRowMerge,
                int nColumnMerge)
                  throws SimpleOdsException

Set the merging of multiple cells to one cell.

Parameters:

nTab - The table number, this table must already exist, 0 is the first table

nRow - The row, 0 is the first row

nCol - The column, 0 is the first column

nRowMerge -

nColumnMerge -

Throws:

SimpleOdsException

setCellMerge

public void setCellMerge(int nTab,
                java.lang.String sPos,
                int nRowMerge,
                int nColumnMerge)
                  throws SimpleOdsException

Set the merging of multiple cells to one cell.

Parameters:

nTab - The table number, this table must already exist, 0 is the first table

sPos - The cell position e.g. 'A1'

nRowMerge -

nColumnMerge -

Throws:

SimpleOdsException

setCellMergeInAllTables

public void setCellMergeInAllTables(int nRow,
                           int nCol,
                           int nRowMerge,
                           int nColumnMerge)
                             throws SimpleOdsException

Set the merging of multiple cells to one cell.

Parameters:

nRow - The row, 0 is the first row

nCol - The column, 0 is the first column

nRowMerge -

nColumnMerge -

Throws:

SimpleOdsException

setCellMergeInAllTables

public void setCellMergeInAllTables(java.lang.String sPos,
                           int nRowMerge,
                           int nColumnMerge)
                             throws SimpleOdsException

Set the merging of multiple cells to one cell in all existing tables.

Parameters:

sPos - The cell position e.g. 'A1'

nRowMerge -

nColumnMerge -

Throws:

SimpleOdsException

setColumnStyle

public void setColumnStyle(int nTab,
                  int nCol,
                  TableStyle ts)
                    throws SimpleOdsException

Sets the style of this table column.

Parameters:

nTab - The table number, this table must already exist

nCol - The column, 0 is the first column

ts - The table style to be used, must be of type TableStyle.STYLEFAMILY_TABLECOLUMN

Throws:

SimpleOdsException

getDefaultPageStyle

public PageStyle getDefaultPageStyle()

lastTableNumber

public int lastTableNumber()

Gets the number of the last table.

Returns:

The number of the last table

getTableNumber

public int getTableNumber(java.lang.String sName)

Search a table by name and return its number.

Parameters:

sName - The name of the table

Returns:

The number of the table or -1 if sName was not found

getTableName

public java.lang.String getTableName(int n)
                              throws SimpleOdsException

Returns the name of the table.

Parameters:

n - The number of the table

Returns:

The name of the table

Throws:

SimpleOdsException

setFooter

public void setFooter(Footer f)

Sets a new footer object, any earlier footer that was set will be reset and the new footer is used.

Parameters:

f - - The new footer to be used.

getFooter

public Footer getFooter()

Returns the current footer.

Returns:

The footer that is currently set , maybe null if no footer was set

setHeader

public void setHeader(Header h)

Sets a new header object, any earlier header that was set will be reset and the. new header is used.

Parameters:

h - - The new header to be used.

getHeader

public Header getHeader()

Returns the current header.

Returns:

The header that is currently set , maybe null if no header was set

getContent

public Content getContent()

Returns:

The content object for this OdsFile

setContent

public void setContent(Content cont)

Set a new content to this OdsFile.

Parameters:

content - The new content to be used.

getStyles

public Styles getStyles()

Returns:

The styles object for this OdsFile

setStyles

public final void setStyles(Styles s)

Set the styles for this ODsFile to styles.

Parameters:

s - - The new styles object to be used.