/** * Returns a text representation of this cell reference. * <p> * Example return values: * <table border="0" cellpadding="1" cellspacing="0" summary="Example return values"> * <tr><th align='left'>Result</th><th align='left'>Comment</th></tr> * <tr><td>A1</td><td>Cell reference without sheet</td></tr> * <tr><td>Sheet1!A1</td><td>Standard sheet name</td></tr> * <tr><td>'O''Brien''s Sales'!A1' </td><td>Sheet name with special characters</td></tr> * </table> * @return the text representation of this cell reference as it would appear in a formula. */ public String formatAsString() { StringBuilder sb = new StringBuilder(32); if(_sheetName != null) { SheetNameFormatter.appendFormat(sb, _sheetName); sb.append(SHEET_NAME_DELIMITER); } appendCellReference(sb); return sb.toString(); }
} else { _lastCell.appendCellReference(sb);
/** * Example return values: * <table border="0" cellpadding="1" cellspacing="0" summary="Example return values"> * <tr><th align='left'>Result</th><th align='left'>Comment</th></tr> * <tr><td>A1</td><td>Cell reference without sheet</td></tr> * <tr><td>Sheet1!A1</td><td>Standard sheet name</td></tr> * <tr><td>'O''Brien''s Sales'!A1' </td><td>Sheet name with special characters</td></tr> * </table> * @return the text representation of this cell reference as it would appear in a formula. */ public String formatAsString() { StringBuffer sb = new StringBuffer(32); if(_sheetName != null) { SheetNameFormatter.appendFormat(sb, _sheetName); sb.append(SHEET_NAME_DELIMITER); } appendCellReference(sb); return sb.toString(); }
/** * Example return values: * <table border="0" cellpadding="1" cellspacing="0" summary="Example return values"> * <tr><th align='left'>Result</th><th align='left'>Comment</th></tr> * <tr><td>A1</td><td>Cell reference without sheet</td></tr> * <tr><td>Sheet1!A1</td><td>Standard sheet name</td></tr> * <tr><td>'O''Brien''s Sales'!A1' </td><td>Sheet name with special characters</td></tr> * </table> * @return the text representation of this cell reference as it would appear in a formula. */ public String formatAsString() { StringBuffer sb = new StringBuffer(32); if(_sheetName != null) { SheetNameFormatter.appendFormat(sb, _sheetName); sb.append(SHEET_NAME_DELIMITER); } appendCellReference(sb); return sb.toString(); }
/** * Returns a text representation of this cell reference. * <p> * Example return values: * <table border="0" cellpadding="1" cellspacing="0" summary="Example return values"> * <tr><th align='left'>Result</th><th align='left'>Comment</th></tr> * <tr><td>A1</td><td>Cell reference without sheet</td></tr> * <tr><td>Sheet1!A1</td><td>Standard sheet name</td></tr> * <tr><td>'O''Brien''s Sales'!A1' </td><td>Sheet name with special characters</td></tr> * </table> * @return the text representation of this cell reference as it would appear in a formula. */ public String formatAsString() { StringBuilder sb = new StringBuilder(32); if(_sheetName != null) { SheetNameFormatter.appendFormat(sb, _sheetName); sb.append(SHEET_NAME_DELIMITER); } appendCellReference(sb); return sb.toString(); }
} else { _lastCell.appendCellReference(sb);
} else { _lastCell.appendCellReference(sb);
} else { _lastCell.appendCellReference(sb);