| Methods Summary |
|---|
| public java.lang.Object | clone()
Ref3DPtg ptg = new Ref3DPtg();
ptg.field_1_index_extern_sheet = field_1_index_extern_sheet;
ptg.field_2_row = field_2_row;
ptg.field_3_column = field_3_column;
ptg.setClass(ptgClass);
return ptg;
|
| public short | getColumn()
return ( short ) (field_3_column & 0xFF);
|
| public short | getColumnRaw()
return field_3_column;
|
| public byte | getDefaultOperandClass()return Ptg.CLASS_REF;
|
| public short | getExternSheetIndex()
return field_1_index_extern_sheet;
|
| public short | getRow()
return field_2_row;
|
| public int | getSize()
return SIZE;
|
| public boolean | isColRelative()
return colRelative.isSet(field_3_column);
|
| public boolean | isRowRelative()
return rowRelative.isSet(field_3_column);
|
| public void | setArea(java.lang.String ref)
RangeAddress ra = new RangeAddress(ref);
String from = ra.getFromCell();
setColumn((short) (ra.getXPosition(from) -1));
setRow((short) (ra.getYPosition(from) -1));
|
| public void | setColRelative(boolean rel)
field_3_column=colRelative.setShortBoolean(field_3_column,rel);
|
| public void | setColumn(short column)
field_3_column &= 0xFF00;
field_3_column |= column & 0xFF;
|
| public void | setColumnRaw(short column)
field_3_column = column;
|
| public void | setExternSheetIndex(short index)
field_1_index_extern_sheet = index;
|
| public void | setRow(short row)
field_2_row = row;
|
| public void | setRowRelative(boolean rel)
field_3_column=rowRelative.setShortBoolean(field_3_column,rel);
|
| public java.lang.String | toFormulaString(org.apache.poi.hssf.model.Workbook book)
StringBuffer retval = new StringBuffer();
SheetReferences refs = book == null ? null : book.getSheetReferences();
if (refs != null) {
String sheetName =refs.getSheetName((int)this.field_1_index_extern_sheet);
boolean appendQuotes = sheetName.indexOf(" ") >= 0;
if (appendQuotes)
retval.append("'");
retval.append(sheetName);
if (appendQuotes)
retval.append("'");
retval.append('!");
}
retval.append((new CellReference(getRow(),getColumn(),!isRowRelative(),!isColRelative())).toString());
return retval.toString();
|
| public java.lang.String | toString()
StringBuffer buffer = new StringBuffer();
buffer.append("Ref3dPtg\n");
buffer.append("Index to Extern Sheet = " + getExternSheetIndex()).append("\n");
buffer.append("Row = " + getRow()).append("\n");
buffer.append("Col = " + getColumn()).append("\n");
buffer.append("ColRowRel= "
+ isRowRelative()).append("\n");
buffer.append("ColRel = " + isColRelative()).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 , getRow());
LittleEndian.putShort(array, 5 + offset , getColumnRaw());
|
