src/org/tiefaces/components/websheet/utility/ShiftFormulaUtility.java
public static int getFirstSupportedRowNumFromPtg(final Object ptg) {

		int rCode = -1;
		if (ptg instanceof RefPtgBase) {
			if (!(ptg instanceof Ref3DPxg) && !(ptg instanceof Ref3DPtg)) {
				rCode = ((RefPtgBase) ptg).getRow();
			}
		} else if (ptg instanceof AreaPtgBase && !(ptg instanceof Area3DPxg)
				&& !(ptg instanceof Area3DPtg)) {
			rCode = ((AreaPtgBase) ptg).getFirstRow();

		}

		return rCode;
	}
public static int getFirstSupportedRowNumFromPtg(final Object ptg) {

		int rCode = -1;
		if (ptg instanceof RefPtgBase) {
			if (!(ptg instanceof Ref3DPxg) && !(ptg instanceof Ref3DPtg)) {
				rCode = ((RefPtgBase) ptg).getRow();
			}
		} else if (ptg instanceof AreaPtgBase && !(ptg instanceof Area3DPxg)
				&& !(ptg instanceof Area3DPtg)) {
			rCode = ((AreaPtgBase) ptg).getFirstRow();

		}

		return rCode;
	}
public static int getFirstSupportedRowNumFromPtg ( final Object ptg ) { int rCode = - 1 ; if ( ptg instanceof RefPtgBase ) { if ( ! ( ptg instanceof Ref3DPxg ) && ! ( ptg instanceof Ref3DPtg ) ) { rCode = ( ( RefPtgBase ) ptg ) . getRow ( ) ; } } else if ( ptg instanceof AreaPtgBase && ! ( ptg instanceof Area3DPxg ) && ! ( ptg instanceof Area3DPtg ) ) { rCode = ( ( AreaPtgBase ) ptg ) . getFirstRow ( ) ; } return rCode ; }
3d (reference to other sheet) is not supported. only 2d (within the
sheet) is supported.

@param ptg
input ptg object.
@return -1 if not a supported ptg. Int row number.
3d ( reference to other sheet ) is not supported . only 2d ( within the sheet ) is supported .