public static String replaceExpressionWithCellValue ( final String attrValue , final int rowIndex , final Sheet sheet ) { int ibegin = 0 ; int ifind ; int inameEnd ; String tempStr ; String findStr ; String replaceStr ; String returnStr = attrValue ; while ( ( ifind = attrValue . indexOf ( TieConstants . CELL_ADDR_PRE_FIX , ibegin ) ) > 0 ) { inameEnd = ParserUtility . findFirstNonCellNamePosition ( attrValue , ifind ) ; if ( inameEnd > 0 ) { findStr = attrValue . substring ( ifind , inameEnd ) ; } else { findStr = attrValue . substring ( ifind ) ; } if ( findStr . indexOf ( TieConstants . CELL_ADDR_PRE_FIX , 1 ) < 0 ) { // only $A tempStr = findStr + TieConstants . CELL_ADDR_PRE_FIX + ( rowIndex + 1 ) ; } else { tempStr = findStr ; } replaceStr = CellUtility . getCellValueWithoutFormat ( WebSheetUtility . getCellByReference ( tempStr , sheet ) ) ; if ( replaceStr == null ) { replaceStr = "" ; } returnStr = attrValue . replace ( findStr , replaceStr ) ; ibegin = ifind + 1 ; } return returnStr ; }
100 > = 80