| Methods Summary |
|---|
| public java.lang.Object | clone()
Area3DPtg ptg = new Area3DPtg();
ptg.field_1_index_extern_sheet = field_1_index_extern_sheet;
ptg.field_2_first_row = field_2_first_row;
ptg.field_3_last_row = field_3_last_row;
ptg.field_4_first_column = field_4_first_column;
ptg.field_5_last_column = field_5_last_column;
ptg.setClass(ptgClass);
return ptg;
|
| public boolean | equals(java.lang.Object o)
if ( this == o ) return true;
if ( !( o instanceof Area3DPtg ) ) return false;
final Area3DPtg area3DPtg = (Area3DPtg) o;
if ( field_1_index_extern_sheet != area3DPtg.field_1_index_extern_sheet ) return false;
if ( field_2_first_row != area3DPtg.field_2_first_row ) return false;
if ( field_3_last_row != area3DPtg.field_3_last_row ) return false;
if ( field_4_first_column != area3DPtg.field_4_first_column ) return false;
if ( field_5_last_column != area3DPtg.field_5_last_column ) return false;
return true;
|
| public byte | getDefaultOperandClass()
return Ptg.CLASS_REF;
|
| public short | getExternSheetIndex()
return field_1_index_extern_sheet;
|
| public short | getFirstColumn()
return (short) ( field_4_first_column & 0xFF );
|
| public short | getFirstColumnRaw()
return field_4_first_column;
|
| public short | getFirstRow()
return field_2_first_row;
|
| public short | getLastColumn()
return (short) ( field_5_last_column & 0xFF );
|
| public short | getLastColumnRaw()
return field_5_last_column;
|
| public short | getLastRow()
return field_3_last_row;
|
| public int | getSize()
return SIZE;
|
| public int | hashCode()
int result;
result = (int) field_1_index_extern_sheet;
result = 29 * result + (int) field_2_first_row;
result = 29 * result + (int) field_3_last_row;
result = 29 * result + (int) field_4_first_column;
result = 29 * result + (int) field_5_last_column;
return result;
|
| public boolean | isFirstColRelative()
return colRelative.isSet( field_4_first_column );
|
| public boolean | isFirstRowRelative()
return rowRelative.isSet( field_4_first_column );
|
| public boolean | isLastColRelative()
return colRelative.isSet( field_5_last_column );
|
| public boolean | isLastRowRelative()
return rowRelative.isSet( field_5_last_column );
|
| public void | setArea(java.lang.String ref)
AreaReference ar = new AreaReference( ref );
setFirstRow( (short) ar.getCells()[0].getRow() );
setFirstColumn( (short) ar.getCells()[0].getCol() );
setLastRow( (short) ar.getCells()[1].getRow() );
setLastColumn( (short) ar.getCells()[1].getCol() );
setFirstColRelative( !ar.getCells()[0].isColAbsolute() );
setLastColRelative( !ar.getCells()[1].isColAbsolute() );
setFirstRowRelative( !ar.getCells()[0].isRowAbsolute() );
setLastRowRelative( !ar.getCells()[1].isRowAbsolute() );
|
| public void | setExternSheetIndex(short index)
field_1_index_extern_sheet = index;
|
| public void | setFirstColRelative(boolean rel)set whether the first column is relative
field_4_first_column = colRelative.setShortBoolean( field_4_first_column, rel );
|
| public void | setFirstColumn(short column)
field_4_first_column &= 0xFF00;
field_4_first_column |= column & 0xFF;
|
| public void | setFirstColumnRaw(short column)
field_4_first_column = column;
|
| public void | setFirstRow(short row)
field_2_first_row = row;
|
| public void | setFirstRowRelative(boolean rel)sets the first row to relative or not
field_4_first_column = rowRelative.setShortBoolean( field_4_first_column, rel );
|
| public void | setLastColRelative(boolean rel)set whether the last column should be relative or not
field_5_last_column = colRelative.setShortBoolean( field_5_last_column, rel );
|
| public void | setLastColumn(short column)
field_5_last_column &= 0xFF00;
field_5_last_column |= column & 0xFF;
|
| public void | setLastColumnRaw(short column)
field_5_last_column = column;
|
| public void | setLastRow(short row)
field_3_last_row = row;
|
| public void | setLastRowRelative(boolean rel)set whether the last row is relative or not
field_5_last_column = rowRelative.setShortBoolean( field_5_last_column, rel );
|
| public java.lang.String | toFormulaString(org.apache.poi.hssf.model.Workbook book)
SheetReferences refs = book == null ? null : book.getSheetReferences();
StringBuffer retval = new StringBuffer();
if ( refs != null )
{
retval.append( refs.getSheetName( this.field_1_index_extern_sheet ) );
retval.append( '!" );
}
retval.append( ( new CellReference( getFirstRow(), getFirstColumn(), !isFirstRowRelative(), !isFirstColRelative() ) ).toString() );
retval.append( ':" );
retval.append( ( new CellReference( getLastRow(), getLastColumn(), !isLastRowRelative(), !isLastColRelative() ) ).toString() );
return retval.toString();
|
| public java.lang.String | toString()
StringBuffer buffer = new StringBuffer();
buffer.append( "AreaPtg\n" );
buffer.append( "Index to Extern Sheet = " + getExternSheetIndex() ).append( "\n" );
buffer.append( "firstRow = " + getFirstRow() ).append( "\n" );
buffer.append( "lastRow = " + getLastRow() ).append( "\n" );
buffer.append( "firstCol = " + getFirstColumn() ).append( "\n" );
buffer.append( "lastCol = " + getLastColumn() ).append( "\n" );
buffer.append( "firstColRel= "
+ isFirstRowRelative() ).append( "\n" );
buffer.append( "lastColRowRel = "
+ isLastRowRelative() ).append( "\n" );
buffer.append( "firstColRel = " + isFirstColRelative() ).append( "\n" );
buffer.append( "lastColRel = " + isLastColRelative() ).append( "\n" );
return buffer.toString();
|
| public void | writeBytes(byte[] array, int offset)
array[0 + offset] = (byte) ( sid + ptgClass );
LittleEndian.putShort( array, 1 + offset, getExternSheetIndex() );
LittleEndian.putShort( array, 3 + offset, getFirstRow() );
LittleEndian.putShort( array, 5 + offset, getLastRow() );
LittleEndian.putShort( array, 7 + offset, getFirstColumnRaw() );
LittleEndian.putShort( array, 9 + offset, getLastColumnRaw() );
|
