nl.fountain.xelem.excel
Interface WorksheetOptions

All Superinterfaces:

XLElement

All Known Implementing Classes:

XWorksheetOptions

public interface WorksheetOptions
extends XLElement

Represents the WorksheetOptions element.

Field Summary

static String	SHEET_HIDDEN
static String	SHEET_VERY_HIDDEN
static String	SHEET_VISIBLE

Fields inherited from interface nl.fountain.xelem.excel.XLElement

PREFIX_HTML, PREFIX_O, PREFIX_SS, PREFIX_X, XMLNS, XMLNS_HTML, XMLNS_O, XMLNS_SS, XMLNS_X

Method Summary

boolean	displaysFormulas()
boolean	displaysNoGridlines()
boolean	displaysNoHeadings()
void	doDisplayFormulas(boolean f)
void	doNotDisplayGridlines(boolean b)
void	doNotDisplayHeadings(boolean b)
void	freezePanesAt(int r, int c)
String	getGridlineColor()
int	getLeftColumnVisible()
int	getTabColorIndex()
int	getTopRowVisible()
String	getVisible()
int	getZoom()
boolean	hasFrozenPanes()
boolean	hasHorizontalSplit()
boolean	hasSplit()
boolean	hasVerticalSplit()
boolean	isSelected()
void	setActiveCell(int r, int c)
void	setActiveCell(int paneNumber, int r, int c)
void	setGridlineColor(int r, int g, int b)
void	setLeftColumnVisible(int lc)
void	setRangeSelection(Area area)
void	setRangeSelection(int paneNumber, String rcRange)
void	setRangeSelection(String rcRange) Sets a range selection.
void	setSelected(boolean s)
void	setTabColorIndex(int ci)
void	setTopRowVisible(int tr)
void	setVisible(String wsoValue)
void	setZoom(int z)
void	splitHorizontal(int points, int topRow)
void	splitVertical(int points, int leftColumn)

Methods inherited from interface nl.fountain.xelem.excel.XLElement

addElementComment, assemble, getElementComments, getNameSpace, getPrefix, getTagName, setAttributes, setChildElement

Field Detail

SHEET_VISIBLE

static final String SHEET_VISIBLE

See Also:

Constant Field Values

SHEET_HIDDEN

static final String SHEET_HIDDEN

See Also:

Constant Field Values

SHEET_VERY_HIDDEN

static final String SHEET_VERY_HIDDEN

See Also:

Constant Field Values

Method Detail

setTopRowVisible

void setTopRowVisible(int tr)

getTopRowVisible

int getTopRowVisible()

setLeftColumnVisible

void setLeftColumnVisible(int lc)

getLeftColumnVisible

int getLeftColumnVisible()

setZoom

void setZoom(int z)

getZoom

int getZoom()

setGridlineColor

void setGridlineColor(int r,
                      int g,
                      int b)

getGridlineColor

String getGridlineColor()

setTabColorIndex

void setTabColorIndex(int ci)

getTabColorIndex

int getTabColorIndex()

setSelected

void setSelected(boolean s)

isSelected

boolean isSelected()

doNotDisplayHeadings

void doNotDisplayHeadings(boolean b)

displaysNoHeadings

boolean displaysNoHeadings()

doNotDisplayGridlines

void doNotDisplayGridlines(boolean b)

displaysNoGridlines

boolean displaysNoGridlines()

doDisplayFormulas

void doDisplayFormulas(boolean f)

displaysFormulas

boolean displaysFormulas()

setVisible

void setVisible(String wsoValue)

getVisible

String getVisible()

setActiveCell

void setActiveCell(int r,
                   int c)

setActiveCell

void setActiveCell(int paneNumber,
                   int r,
                   int c)

setRangeSelection

void setRangeSelection(String rcRange)

Sets a range selection. The active cell must also be set within the range in order for this method to have effect.

Parameters:

rcRange - A String in R1C1 reference style.

See Also:

setActiveCell(int, int)

setRangeSelection

void setRangeSelection(Area area)

setRangeSelection

void setRangeSelection(int paneNumber,
                       String rcRange)

splitHorizontal

void splitHorizontal(int points,
                     int topRow)

splitVertical

void splitVertical(int points,
                   int leftColumn)

hasHorizontalSplit

boolean hasHorizontalSplit()

hasVerticalSplit

boolean hasVerticalSplit()

hasSplit

boolean hasSplit()

freezePanesAt

void freezePanesAt(int r,
                   int c)

hasFrozenPanes

boolean hasFrozenPanes()