Top Description Fields Constructors Methods
org.apache.poi.hssf.record.chart

public final Class TextRecord

extends StandardRecord
Class Inheritance
Static Imports
org.apache.poi.util.GenericRecordUtil.getBitsAsString, .GenericRecordUtil.getEnumBitsAsString

The text record is used to define text stored on a chart.

Field Summary

Modifier and TypeField and Description
private static final BitField
private static final BitField
private static final BitField
private static final BitField
public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
private static final BitField
public static final short
public static final short
private short
private short
private short
private byte
private byte
private short
private int
private int
private int
private int
private int
private short
private static final BitField
public static final byte
public static final byte
public static final byte
public static final byte
private static final BitField
public static final short
public static final short
public static final short
public static final short
private static final BitField
private static final BitField
private static final BitField
private static final BitField
private static final BitField
private static final BitField
public static final short
private static final BitField
public static final byte
public static final byte
public static final byte
public static final byte

Constructor Summary

AccessConstructor and Description
public
public
public

Method Summary

Modifier and TypeMethod and Description
public TextRecord
public short

Returns:

the data label placement field value.
getDataLabelPlacement
()

protected int
public short

Returns:

One of DISPLAY_MODE_TRANSPARENT DISPLAY_MODE_OPAQUE
getDisplayMode
()

Get the display mode field for the Text record.

public Map<String, Supplier<?>>
public HSSFRecordTypes
public int
getHeight()

Get the height field for the Text record.

public byte

Returns:

One of HORIZONTAL_ALIGNMENT_LEFT HORIZONTAL_ALIGNMENT_CENTER HORIZONTAL_ALIGNMENT_BOTTOM HORIZONTAL_ALIGNMENT_JUSTIFY
getHorizontalAlignment
()

Get the horizontal alignment field for the Text record.

public short
getIndexOfColorValue()

Get the index of color value field for the Text record.

public short
getOptions1()

Get the options1 field for the Text record.

public short
getOptions2()

Get the options2 field for the Text record.

public int
getRgbColor()

Get the rgbColor field for the Text record.

public short

Returns:

the rotation field value.
getRotation
()

public short
getSid()

Implements abstract org.apache.poi.hssf.record.Record.getSid.

return the non static version of the id for this record.

public short
getTextRotation()

Get the text rotation field for the Text record.

public byte

Returns:

One of VERTICAL_ALIGNMENT_TOP VERTICAL_ALIGNMENT_CENTER VERTICAL_ALIGNMENT_BOTTOM VERTICAL_ALIGNMENT_JUSTIFY
getVerticalAlignment
()

Get the vertical alignment field for the Text record.

public int
getWidth()

Get the width field for the Text record.

public int
getX()

Get the x field for the Text record.

public int
getY()

Get the y field for the Text record.

public boolean

Returns:

the auto background field value.
isAutoBackground
()

public boolean

Returns:

the auto color field value.
isAutoColor
()

true = automaticly selected colour, false = user-selected

public boolean

Returns:

the auto generated text field value.
isAutoGeneratedText
()

public boolean

Returns:

the auto label deleted field value.
isAutoLabelDeleted
()

public boolean

Returns:

the generated field value.
isGenerated
()

public boolean

Returns:

the show bubble sizes field value.
isShowBubbleSizes
()

public boolean

Returns:

the show category label as percentage field value.
isShowCategoryLabelAsPercentage
()

public boolean

Returns:

the show key field value.
isShowKey
()

true = draw legend

public boolean

Returns:

the show label field value.
isShowLabel
()

public boolean

Returns:

the show value field value.
isShowValue
()

false = text is category label

public boolean

Returns:

the show value as percentage field value.
isShowValueAsPercentage
()

public boolean

Returns:

the vertical field value.
isVertical
()

true = text is vertical

public void
serialize(LittleEndianOutput
the output object
out
)

Implements abstract org.apache.poi.hssf.record.StandardRecord.serialize.

Write the data content of this BIFF record.

public void
setAutoBackground(boolean value)

Sets the auto background field value.

public void
setAutoColor(boolean value)

Sets the auto color field value.

public void
setAutoGeneratedText(boolean value)

Sets the auto generated text field value.

public void
setAutoLabelDeleted(boolean value)

Sets the auto label deleted field value.

public void
setDataLabelPlacement(short value)

Sets the data label placement field value.

public void
setDisplayMode(short
One of DISPLAY_MODE_TRANSPARENT DISPLAY_MODE_OPAQUE
field_3_displayMode
)

Set the display mode field for the Text record.

public void
setGenerated(boolean value)

Sets the generated field value.

public void
setHeight(int field_8_height)

Set the height field for the Text record.

public void
setHorizontalAlignment(byte
One of HORIZONTAL_ALIGNMENT_LEFT HORIZONTAL_ALIGNMENT_CENTER HORIZONTAL_ALIGNMENT_BOTTOM HORIZONTAL_ALIGNMENT_JUSTIFY
field_1_horizontalAlignment
)

Set the horizontal alignment field for the Text record.

public void
setIndexOfColorValue(short field_10_indexOfColorValue)

Set the index of color value field for the Text record.

public void
setOptions1(short field_9_options1)

Set the options1 field for the Text record.

public void
setOptions2(short field_11_options2)

Set the options2 field for the Text record.

public void
setRgbColor(int field_4_rgbColor)

Set the rgbColor field for the Text record.

public void
setRotation(short value)

Sets the rotation field value.

public void
setShowBubbleSizes(boolean value)

Sets the show bubble sizes field value.

public void
setShowCategoryLabelAsPercentage(boolean value)

Sets the show category label as percentage field value.

public void
setShowKey(boolean value)

Sets the show key field value.

public void
setShowLabel(boolean value)

Sets the show label field value.

public void
setShowValue(boolean value)

Sets the show value field value.

public void
setShowValueAsPercentage(boolean value)

Sets the show value as percentage field value.

public void
setTextRotation(short field_12_textRotation)

Set the text rotation field for the Text record.

public void
setVertical(boolean value)

Sets the vertical field value.

public void
setVerticalAlignment(byte
One of VERTICAL_ALIGNMENT_TOP VERTICAL_ALIGNMENT_CENTER VERTICAL_ALIGNMENT_BOTTOM VERTICAL_ALIGNMENT_JUSTIFY
field_2_verticalAlignment
)

Set the vertical alignment field for the Text record.

public void
setWidth(int field_7_width)

Set the width field for the Text record.

public void
setX(int field_5_x)

Set the x field for the Text record.

public void
setY(int field_6_y)

Set the y field for the Text record.

Inherited from org.apache.poi.hssf.record.StandardRecord:
getRecordSizeserialize

Field Detail

autoBackgroundback to summary
private static final BitField autoBackground
autoColorback to summary
private static final BitField autoColor
autoGeneratedTextback to summary
private static final BitField autoGeneratedText
autoLabelDeletedback to summary
private static final BitField autoLabelDeleted
DATA_LABEL_PLACEMENT_ABOVEback to summary
public static final short DATA_LABEL_PLACEMENT_ABOVE
DATA_LABEL_PLACEMENT_AUTOback to summary
public static final short DATA_LABEL_PLACEMENT_AUTO
DATA_LABEL_PLACEMENT_AXISback to summary
public static final short DATA_LABEL_PLACEMENT_AXIS
DATA_LABEL_PLACEMENT_BELOWback to summary
public static final short DATA_LABEL_PLACEMENT_BELOW
DATA_LABEL_PLACEMENT_CENTERback to summary
public static final short DATA_LABEL_PLACEMENT_CENTER
DATA_LABEL_PLACEMENT_CHART_DEPENDENTback to summary
public static final short DATA_LABEL_PLACEMENT_CHART_DEPENDENT
DATA_LABEL_PLACEMENT_INSIDEback to summary
public static final short DATA_LABEL_PLACEMENT_INSIDE
DATA_LABEL_PLACEMENT_LEFTback to summary
public static final short DATA_LABEL_PLACEMENT_LEFT
DATA_LABEL_PLACEMENT_OUTSIDEback to summary
public static final short DATA_LABEL_PLACEMENT_OUTSIDE
DATA_LABEL_PLACEMENT_RIGHTback to summary
public static final short DATA_LABEL_PLACEMENT_RIGHT
DATA_LABEL_PLACEMENT_USER_MOVEDback to summary
public static final short DATA_LABEL_PLACEMENT_USER_MOVED
dataLabelPlacementback to summary
private static final BitField dataLabelPlacement
DISPLAY_MODE_OPAQUEback to summary
public static final short DISPLAY_MODE_OPAQUE
DISPLAY_MODE_TRANSPARENTback to summary
public static final short DISPLAY_MODE_TRANSPARENT
field_10_indexOfColorValueback to summary
private short field_10_indexOfColorValue
field_11_options2back to summary
private short field_11_options2
field_12_textRotationback to summary
private short field_12_textRotation
field_1_horizontalAlignmentback to summary
private byte field_1_horizontalAlignment
field_2_verticalAlignmentback to summary
private byte field_2_verticalAlignment
field_3_displayModeback to summary
private short field_3_displayMode
field_4_rgbColorback to summary
private int field_4_rgbColor
field_5_xback to summary
private int field_5_x
field_6_yback to summary
private int field_6_y
field_7_widthback to summary
private int field_7_width
field_8_heightback to summary
private int field_8_height
field_9_options1back to summary
private short field_9_options1
generatedback to summary
private static final BitField generated
HORIZONTAL_ALIGNMENT_BOTTOMback to summary
public static final byte HORIZONTAL_ALIGNMENT_BOTTOM
HORIZONTAL_ALIGNMENT_CENTERback to summary
public static final byte HORIZONTAL_ALIGNMENT_CENTER
HORIZONTAL_ALIGNMENT_JUSTIFYback to summary
public static final byte HORIZONTAL_ALIGNMENT_JUSTIFY
HORIZONTAL_ALIGNMENT_LEFTback to summary
public static final byte HORIZONTAL_ALIGNMENT_LEFT
rotationback to summary
private static final BitField rotation
ROTATION_NONEback to summary
public static final short ROTATION_NONE
ROTATION_ROTATED_90_DEGREESback to summary
public static final short ROTATION_ROTATED_90_DEGREES
ROTATION_ROTATED_90_DEGREES_CLOCKWISEback to summary
public static final short ROTATION_ROTATED_90_DEGREES_CLOCKWISE
ROTATION_TOP_TO_BOTTOMback to summary
public static final short ROTATION_TOP_TO_BOTTOM
showBubbleSizesback to summary
private static final BitField showBubbleSizes
showCategoryLabelAsPercentageback to summary
private static final BitField showCategoryLabelAsPercentage
showKeyback to summary
private static final BitField showKey
showLabelback to summary
private static final BitField showLabel
showValueback to summary
private static final BitField showValue
showValueAsPercentageback to summary
private static final BitField showValueAsPercentage
sidback to summary
public static final short sid
verticalback to summary
private static final BitField vertical
VERTICAL_ALIGNMENT_BOTTOMback to summary
public static final byte VERTICAL_ALIGNMENT_BOTTOM
VERTICAL_ALIGNMENT_CENTERback to summary
public static final byte VERTICAL_ALIGNMENT_CENTER
VERTICAL_ALIGNMENT_JUSTIFYback to summary
public static final byte VERTICAL_ALIGNMENT_JUSTIFY
VERTICAL_ALIGNMENT_TOPback to summary
public static final byte VERTICAL_ALIGNMENT_TOP

Constructor Detail

TextRecordback to summary
public TextRecord()
TextRecordback to summary
public TextRecord(TextRecord other)
TextRecordback to summary
public TextRecord(RecordInputStream in)

Method Detail

copyback to summary
public TextRecord copy()

Implements abstract org.apache.poi.hssf.record.StandardRecord.copy.

Implements org.apache.poi.common.Duplicatable.copy.

Returns:TextRecord

Doc from org.apache.poi.common.Duplicatable.copy.

a deep copy of the implementing class / instance

Annotations
@Override
getDataLabelPlacementback to summary
public short getDataLabelPlacement()
Returns:short

the data label placement field value.

getDataSizeback to summary
protected int getDataSize()

Implements abstract org.apache.poi.hssf.record.StandardRecord.getDataSize.

getDisplayModeback to summary
public short getDisplayMode()

Get the display mode field for the Text record.

Returns:short

One of DISPLAY_MODE_TRANSPARENT DISPLAY_MODE_OPAQUE

getGenericPropertiesback to summary
public Map<String, Supplier<?>> getGenericProperties()

Implements org.apache.poi.common.usermodel.GenericRecord.getGenericProperties.

Annotations
@Override
getGenericRecordTypeback to summary
public HSSFRecordTypes getGenericRecordType()

Overrides default org.apache.poi.common.usermodel.GenericRecord.getGenericRecordType.

Implements abstract org.apache.poi.hssf.record.Record.getGenericRecordType.

Annotations
@Override
getHeightback to summary
public int getHeight()

Get the height field for the Text record.

getHorizontalAlignmentback to summary
public byte getHorizontalAlignment()

Get the horizontal alignment field for the Text record.

Returns:byte

One of HORIZONTAL_ALIGNMENT_LEFT HORIZONTAL_ALIGNMENT_CENTER HORIZONTAL_ALIGNMENT_BOTTOM HORIZONTAL_ALIGNMENT_JUSTIFY

getIndexOfColorValueback to summary
public short getIndexOfColorValue()

Get the index of color value field for the Text record.

getOptions1back to summary
public short getOptions1()

Get the options1 field for the Text record.

getOptions2back to summary
public short getOptions2()

Get the options2 field for the Text record.

getRgbColorback to summary
public int getRgbColor()

Get the rgbColor field for the Text record.

getRotationback to summary
public short getRotation()
Returns:short

the rotation field value.

getSidback to summary
public short getSid()

Implements abstract org.apache.poi.hssf.record.Record.getSid.

Doc from org.apache.poi.hssf.record.Record.getSid.

return the non static version of the id for this record.

Returns:short

he id for this record

getTextRotationback to summary
public short getTextRotation()

Get the text rotation field for the Text record.

getVerticalAlignmentback to summary
public byte getVerticalAlignment()

Get the vertical alignment field for the Text record.

Returns:byte

One of VERTICAL_ALIGNMENT_TOP VERTICAL_ALIGNMENT_CENTER VERTICAL_ALIGNMENT_BOTTOM VERTICAL_ALIGNMENT_JUSTIFY

getWidthback to summary
public int getWidth()

Get the width field for the Text record.

getXback to summary
public int getX()

Get the x field for the Text record.

getYback to summary
public int getY()

Get the y field for the Text record.

isAutoBackgroundback to summary
public boolean isAutoBackground()
Returns:boolean

the auto background field value.

isAutoColorback to summary
public boolean isAutoColor()

true = automaticly selected colour, false = user-selected

Returns:boolean

the auto color field value.

isAutoGeneratedTextback to summary
public boolean isAutoGeneratedText()
Returns:boolean

the auto generated text field value.

isAutoLabelDeletedback to summary
public boolean isAutoLabelDeleted()
Returns:boolean

the auto label deleted field value.

isGeneratedback to summary
public boolean isGenerated()
Returns:boolean

the generated field value.

isShowBubbleSizesback to summary
public boolean isShowBubbleSizes()
Returns:boolean

the show bubble sizes field value.

isShowCategoryLabelAsPercentageback to summary
public boolean isShowCategoryLabelAsPercentage()
Returns:boolean

the show category label as percentage field value.

isShowKeyback to summary
public boolean isShowKey()

true = draw legend

Returns:boolean

the show key field value.

isShowLabelback to summary
public boolean isShowLabel()
Returns:boolean

the show label field value.

isShowValueback to summary
public boolean isShowValue()

false = text is category label

Returns:boolean

the show value field value.

isShowValueAsPercentageback to summary
public boolean isShowValueAsPercentage()
Returns:boolean

the show value as percentage field value.

isVerticalback to summary
public boolean isVertical()

true = text is vertical

Returns:boolean

the vertical field value.

serializeback to summary
public void serialize(LittleEndianOutput out)

Implements abstract org.apache.poi.hssf.record.StandardRecord.serialize.

Doc from org.apache.poi.hssf.record.StandardRecord.serialize.

Write the data content of this BIFF record. The 'ushort sid' and 'ushort size' header fields have already been written by the superclass.

The number of bytes written must equal the record size reported by org.apache.poi.hssf.record.Record#getRecordSize()} minus four ( record header consisting of a 'ushort sid' and 'ushort reclength' has already been written by their superclass).

Parameters
out:LittleEndianOutput

the output object

setAutoBackgroundback to summary
public void setAutoBackground(boolean value)

Sets the auto background field value.

setAutoColorback to summary
public void setAutoColor(boolean value)

Sets the auto color field value. true = automaticly selected colour, false = user-selected

setAutoGeneratedTextback to summary
public void setAutoGeneratedText(boolean value)

Sets the auto generated text field value.

setAutoLabelDeletedback to summary
public void setAutoLabelDeleted(boolean value)

Sets the auto label deleted field value.

setDataLabelPlacementback to summary
public void setDataLabelPlacement(short value)

Sets the data label placement field value.

setDisplayModeback to summary
public void setDisplayMode(short field_3_displayMode)

Set the display mode field for the Text record.

Parameters
field_3_displayMode:short

One of DISPLAY_MODE_TRANSPARENT DISPLAY_MODE_OPAQUE

setGeneratedback to summary
public void setGenerated(boolean value)

Sets the generated field value.

setHeightback to summary
public void setHeight(int field_8_height)

Set the height field for the Text record.

setHorizontalAlignmentback to summary
public void setHorizontalAlignment(byte field_1_horizontalAlignment)

Set the horizontal alignment field for the Text record.

Parameters
field_1_horizontalAlignment:byte

One of HORIZONTAL_ALIGNMENT_LEFT HORIZONTAL_ALIGNMENT_CENTER HORIZONTAL_ALIGNMENT_BOTTOM HORIZONTAL_ALIGNMENT_JUSTIFY

setIndexOfColorValueback to summary
public void setIndexOfColorValue(short field_10_indexOfColorValue)

Set the index of color value field for the Text record.

setOptions1back to summary
public void setOptions1(short field_9_options1)

Set the options1 field for the Text record.

setOptions2back to summary
public void setOptions2(short field_11_options2)

Set the options2 field for the Text record.

setRgbColorback to summary
public void setRgbColor(int field_4_rgbColor)

Set the rgbColor field for the Text record.

setRotationback to summary
public void setRotation(short value)

Sets the rotation field value.

setShowBubbleSizesback to summary
public void setShowBubbleSizes(boolean value)

Sets the show bubble sizes field value.

setShowCategoryLabelAsPercentageback to summary
public void setShowCategoryLabelAsPercentage(boolean value)

Sets the show category label as percentage field value.

setShowKeyback to summary
public void setShowKey(boolean value)

Sets the show key field value. true = draw legend

setShowLabelback to summary
public void setShowLabel(boolean value)

Sets the show label field value.

setShowValueback to summary
public void setShowValue(boolean value)

Sets the show value field value. false = text is category label

setShowValueAsPercentageback to summary
public void setShowValueAsPercentage(boolean value)

Sets the show value as percentage field value.

setTextRotationback to summary
public void setTextRotation(short field_12_textRotation)

Set the text rotation field for the Text record.

setVerticalback to summary
public void setVertical(boolean value)

Sets the vertical field value. true = text is vertical

setVerticalAlignmentback to summary
public void setVerticalAlignment(byte field_2_verticalAlignment)

Set the vertical alignment field for the Text record.

Parameters
field_2_verticalAlignment:byte

One of VERTICAL_ALIGNMENT_TOP VERTICAL_ALIGNMENT_CENTER VERTICAL_ALIGNMENT_BOTTOM VERTICAL_ALIGNMENT_JUSTIFY

setWidthback to summary
public void setWidth(int field_7_width)

Set the width field for the Text record.

setXback to summary
public void setX(int field_5_x)

Set the x field for the Text record.

setYback to summary
public void setY(int field_6_y)

Set the y field for the Text record.