public Ref3DPtg() 
{

}

Creates new AreaPtg

 public Ref3DPtg(RecordInputStream in) 
{
        field_1_index_extern_sheet = in.readShort();
        field_2_row          = in.readShort();
        field_3_column        = in.readShort();
}

 public Ref3DPtg(String cellref,
    short externIdx) 
{
        CellReference c= new CellReference(cellref);
        setRow(c.getRow());
        setColumn(c.getCol());
        setColRelative(!c.isColAbsolute());
        setRowRelative(!c.isRowAbsolute());   
        setExternSheetIndex(externIdx);
}

 public int getColumn() 
{
        return field_3_column & 0xFF;
}

 public int getColumnRaw() 
{
        return field_3_column;
}

 public byte getDefaultOperandClass() 
{
		return Ptg.CLASS_REF;
}

 public short getExternSheetIndex() 
{
        return field_1_index_extern_sheet;
}

 public int getRow() 
{
        return field_2_row;
}

 static String getSheetName(HSSFWorkbook book,
    int externSheetIndex) 
{
        // TODO - there are 3 ways this method can return null. Is each valid?
        if (book == null) {
            return null;
        }
        SheetReferences refs = book.getSheetReferences();
        if (refs == null) {
            return null;
        }
        return refs.getSheetName(externSheetIndex);
}

 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(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.setBoolean(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(int row) 
{
        field_2_row = row;
}

 public  void setRowRelative(boolean rel) 
{
        field_3_column=rowRelative.setBoolean(field_3_column,rel);
}

 public String toFormulaString(HSSFWorkbook book) 
{
        StringBuffer retval = new StringBuffer();
        String sheetName = getSheetName(book, field_1_index_extern_sheet);
        if(sheetName != null) {
            SheetNameFormatter.appendFormat(retval, sheetName);
            retval.append( '!" );
        }
        retval.append((new CellReference(getRow(),getColumn(),!isRowRelative(),!isColRelative())).formatAsString()); 
        return retval.toString();
}

 public String toString() 
{
        CellReference cr = new CellReference(getRow(), getColumn(), !isRowRelative(),!isColRelative());
        StringBuffer sb = new StringBuffer();
        sb.append(getClass().getName());
        sb.append(" [");
        sb.append("sheetIx=").append(getExternSheetIndex());
        sb.append(" ! ");
        sb.append(cr.formatAsString());
        sb.append("]");
        return sb.toString();
}

 public  void writeBytes(byte[] array,
    int offset) 
{
        array[ 0 + offset ] = (byte) (sid + getPtgClass());
        LittleEndian.putShort(array, 1 + offset , getExternSheetIndex());
        LittleEndian.putShort(array, 3 + offset , (short)getRow());
        LittleEndian.putShort(array, 5 + offset , (short)getColumnRaw());
}