com.hfg.xml.msofficexml.xlsx.spreadsheetml

Class SsmlCol

java.lang.Object

com.hfg.xml.XMLContainerImpl

com.hfg.xml.XMLTag

com.hfg.xml.msofficexml.OfficeOpenXMLTag

com.hfg.xml.msofficexml.xlsx.spreadsheetml.SsmlXMLTag

com.hfg.xml.msofficexml.xlsx.spreadsheetml.SsmlCol

All Implemented Interfaces:

XMLContainer, XMLizable, XMLNode, Cloneable, Comparable

public class SsmlCol
extends SsmlXMLTag

Represents an Office Open XML worksheet column (<ssml:col>) tag.

Nested Class Summary

Nested classes/interfaces inherited from class com.hfg.xml.XMLContainerImpl

XMLContainerImpl.sMode

Field Summary

Fields inherited from class com.hfg.xml.msofficexml.OfficeOpenXMLTag

sSQLLoggingLevel

Fields inherited from class com.hfg.xml.XMLContainerImpl

mContentAndSubtagList

Constructor Summary

Constructors

Constructor and Description
SsmlCol(SsmlWorksheet inParentWorksheet)

Method Summary

Modifier and Type	Method and Description
SsmlCol	setHidden(boolean inValue)
SsmlCol	setMax(int inValue) Sets the 1-based index of the last column that this spec applies to.
SsmlCol	setMin(int inValue) Sets the 1-based index of the first column that this spec applies to.
SsmlCol	setStyle(SsmlCellFormat inValue) Sets the style to apply to this column's cells.
SsmlCol	setWidth(float inValue) Column width measured as the number of characters of the maximum digit width of the numbers 0, 1, 2, …, 9 as rendered in the normal style's font.
SsmlCol	setWidth(GfxSize inValue) Column width measured as the number of characters of the maximum digit width of the numbers 0, 1, 2, …, 9 as rendered in the normal style's font.

Methods inherited from class com.hfg.xml.msofficexml.xlsx.spreadsheetml.SsmlXMLTag

getParentDoc, setAttribute

Methods inherited from class com.hfg.xml.msofficexml.OfficeOpenXMLTag

colorToCT_Color, generateUID, getLogger, orderSubtags, setParentDoc, toIndentedXML, toXML

Methods inherited from class com.hfg.xml.XMLTag

addSubtag, addSubtag, addXMLNamespaceDeclaration, clone, compareTo, equals, findNodesByAttributeValue, findNodesByAttributeValue, getAttribute, getAttribute, getAttributes, getAttributeValue, getAttributeValue, getEndTag, getNamespace, getQualifiedTagName, getStartTag, getTagName, hasAttribute, hasAttribute, hasAttributes, isEmptyTag, removeAttribute, removeAttribute, replaceCharacterEntities, setAttribute, setAttribute, setAttributes, setContent, setDefaultXMLNamespaceDeclaration, setNamespace, setSortAttributesBeforeWriting, setTagName, setTagName, sortAttributes, toIndentedXML, toIndentedXML, toIndentedXML, toString, toXML, toXML, toXML, useDoubleQuotes, verifyTagName, verifyTagName, verifyTagName, verifyTagName

Methods inherited from class com.hfg.xml.XMLContainerImpl

addContent, addContentWithoutEscaping, addSubtag, addSubtag, addSubtags, clearContent, clearSubtags, getContent, getContentPlusSubtagList, getNextSibling, getOptionalSubtagByName, getOptionalSubtagByName, getOptionalSubtagByName, getOptionalSubtagByName, getParentNode, getPreviousSibling, getRequiredSubtagById, getRequiredSubtagById, getRequiredSubtagByName, getRequiredSubtagByName, getSubtagByAttribute, getSubtagByAttribute, getSubtags, getSubtagsByAttribute, getSubtagsByAttribute, getSubtagsByAttribute, getSubtagsByAttribute, getSubtagsByAttribute, getSubtagsByClass, getSubtagsByClass, getSubtagsByName, getSubtagsByName, getSubtagsByName, getSubtagsByName, getSubtagsByName, getTotalTagCount, getUnescapedContent, getXMLNodeSubtags, hasContent, hasContentOrSubtags, indexOf, innerHTML, removeSubtag, removeSubtagsByAttribute, removeSubtagsByAttribute, removeSubtagsByAttribute, removeSubtagsByClass, removeSubtagsByClass, removeSubtagsByName, removeSubtagsByName, removeSubtagsByName, setContent, setParentNode, setSubtags

Methods inherited from class java.lang.Object

finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface com.hfg.xml.XMLContainer

addContent, addContentWithoutEscaping, addSubtag, addSubtags, clearContent, clearSubtags, getContent, getNextSibling, getOptionalSubtagByName, getOptionalSubtagByName, getParentNode, getPreviousSibling, getRequiredSubtagByName, getRequiredSubtagByName, getSubtags, getSubtagsByName, getSubtagsByName, getSubtagsByName, getSubtagsByName, getTotalTagCount, getUnescapedContent, getXMLNodeSubtags, hasContent, indexOf, removeSubtag, removeSubtagsByName, removeSubtagsByName, setParentNode, setSubtags

Constructor Detail

SsmlCol

public SsmlCol(SsmlWorksheet inParentWorksheet)

Method Detail

setStyle

public SsmlCol setStyle(SsmlCellFormat inValue)

Sets the style to apply to this column's cells.

Parameters:

inValue - cell format to apply

Returns:

this column instance

setMin

public SsmlCol setMin(int inValue)

Sets the 1-based index of the first column that this spec applies to.

Parameters:

inValue - 1-based index of the first column that this spec applies to

Returns:

this column instance

setMax

public SsmlCol setMax(int inValue)

Sets the 1-based index of the last column that this spec applies to.

Parameters:

inValue - 1-based index of the last column that this spec applies to

Returns:

this column instance

setHidden

public SsmlCol setHidden(boolean inValue)

setWidth

public SsmlCol setWidth(float inValue)

Column width measured as the number of characters of the maximum digit width of the numbers 0, 1, 2, …, 9 as rendered in the normal style's font. There are 4 pixels of margin padding (two on each side), plus 1 pixel padding for the gridlines.

Parameters:

inValue - width to use for the column display

Returns:

this column instance

setWidth

public SsmlCol setWidth(GfxSize inValue)

Column width measured as the number of characters of the maximum digit width of the numbers 0, 1, 2, …, 9 as rendered in the normal style's font. There are 4 pixels of margin padding (two on each side), plus 1 pixel padding for the gridlines.

Parameters:

inValue - width to use for the column display

Returns:

this column instance