com.hfg.xml.msofficexml.xlsx.spreadsheetml

Class SsmlSheetFormatProperties

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.SsmlSheetFormatProperties

All Implemented Interfaces:

XMLContainer, XMLizable, XMLNode, Cloneable, Comparable

public class SsmlSheetFormatProperties
extends SsmlXMLTag

Represents an Office Open XML sheet format properties (<ssml:sheetFormatPr>) 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
SsmlSheetFormatProperties(Xlsx inXlsx)

Method Summary

Modifier and Type	Method and Description
SsmlSheetFormatProperties	setBaseColWidth(float inValue) Specifies the number of characters of the maximum digit width of the normal style's font.
SsmlSheetFormatProperties	setBaseColWidth(GfxSize inValue) Specifies the number of characters of the maximum digit width of the normal style's font.
SsmlSheetFormatProperties	setBaseColWidth(int inValue) Specifies the number of characters of the maximum digit width of the normal style's font.
SsmlSheetFormatProperties	setCustomHeight(boolean inValue)
SsmlSheetFormatProperties	setDefaultColWidth(float inValue) Sets the default column width measured as the number of characters of the maximum digit width of the normal style's font.
SsmlSheetFormatProperties	setDefaultColWidth(GfxSize inValue) Sets the default column width measured as the number of characters of the maximum digit width of the normal style's font.
SsmlSheetFormatProperties	setDefaultColWidth(int inValue) Sets the default column width measured as the number of characters of the maximum digit width of the normal style's font.
SsmlSheetFormatProperties	setDefaultRowHeight(float inValue) Sets the default row height (in points).
SsmlSheetFormatProperties	setDefaultRowHeight(GfxSize inValue) Sets the default row height.
SsmlSheetFormatProperties	setDefaultRowHeight(int inValue) Sets the default row height (in points).
SsmlSheetFormatProperties	setThickBottom(boolean inValue)
SsmlSheetFormatProperties	setThickTop(boolean inValue)
SsmlSheetFormatProperties	setZeroHeight(boolean inValue)

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

SsmlSheetFormatProperties

public SsmlSheetFormatProperties(Xlsx inXlsx)

Method Detail

setBaseColWidth

public SsmlSheetFormatProperties setBaseColWidth(int inValue)

Specifies the number of characters of the maximum digit width of the normal style's font. This value does not include margin padding or extra padding for gridlines. It is only the number of characters.

From 18.3.1.81 of the Ecma-376 Office Open XML specification

Parameters:

inValue - width in number of characters of maximum digit width.

Returns:

this properties object to allow method chaining.

setBaseColWidth

public SsmlSheetFormatProperties setBaseColWidth(float inValue)

Specifies the number of characters of the maximum digit width of the normal style's font. This value does not include margin padding or extra padding for gridlines. It is only the number of characters.

From 18.3.1.81 of the Ecma-376 Office Open XML specification

Parameters:

inValue - width in number of characters of maximum digit width.

Returns:

this properties object to allow method chaining.

setBaseColWidth

public SsmlSheetFormatProperties setBaseColWidth(GfxSize inValue)

Specifies the number of characters of the maximum digit width of the normal style's font. This value does not include margin padding or extra padding for gridlines. It is only the number of characters.

From 18.3.1.81 of the Ecma-376 Office Open XML specification

Parameters:

inValue - width in a user-specified system of measure.

Returns:

this properties object to allow method chaining.

setDefaultColWidth

public SsmlSheetFormatProperties setDefaultColWidth(int inValue)

Sets the default column width measured as the number of characters of the maximum digit width of the normal style's font.

From 18.3.1.81 of the Ecma-376 Office Open XML specification

Parameters:

inValue - width in number of characters of maximum digit width.

Returns:

this properties object to allow method chaining.

setDefaultColWidth

public SsmlSheetFormatProperties setDefaultColWidth(float inValue)

Sets the default column width measured as the number of characters of the maximum digit width of the normal style's font.

From 18.3.1.81 of the Ecma-376 Office Open XML specification

Parameters:

inValue - width in number of characters of maximum digit width.

Returns:

this properties object to allow method chaining.

setDefaultColWidth

public SsmlSheetFormatProperties setDefaultColWidth(GfxSize inValue)

Sets the default column width measured as the number of characters of the maximum digit width of the normal style's font.

From 18.3.1.81 of the Ecma-376 Office Open XML specification

Parameters:

inValue - width in a user-specified system of measure.

Returns:

this properties object to allow method chaining.

setDefaultRowHeight

public SsmlSheetFormatProperties setDefaultRowHeight(int inValue)

Sets the default row height (in points).

From 18.3.1.81 of the Ecma-376 Office Open XML specification

Parameters:

inValue - row height in points.

Returns:

this properties object to allow method chaining.

setDefaultRowHeight

public SsmlSheetFormatProperties setDefaultRowHeight(float inValue)

Sets the default row height (in points).

From 18.3.1.81 of the Ecma-376 Office Open XML specification

Parameters:

inValue - row height in points.

Returns:

this properties object to allow method chaining.

setDefaultRowHeight

public SsmlSheetFormatProperties setDefaultRowHeight(GfxSize inValue)

Sets the default row height.

From 18.3.1.81 of the Ecma-376 Office Open XML specification

Parameters:

inValue - height in a user-specified system of measure.

Returns:

this properties object to allow method chaining.

setCustomHeight

public SsmlSheetFormatProperties setCustomHeight(boolean inValue)

setZeroHeight

public SsmlSheetFormatProperties setZeroHeight(boolean inValue)

setThickTop

public SsmlSheetFormatProperties setThickTop(boolean inValue)

setThickBottom

public SsmlSheetFormatProperties setThickBottom(boolean inValue)