/** * @return the text format of this range using specified sheet name. */ public String formatAsString(String sheetName, boolean useAbsoluteAddress) { StringBuilder sb = new StringBuilder(); if (sheetName != null) { sb.append(SheetNameFormatter.format(sheetName)); sb.append("!"); } CellReference cellRefFrom = new CellReference(getFirstRow(), getFirstColumn(), useAbsoluteAddress, useAbsoluteAddress); CellReference cellRefTo = new CellReference(getLastRow(), getLastColumn(), useAbsoluteAddress, useAbsoluteAddress); sb.append(cellRefFrom.formatAsString()); //for a single-cell reference return A1 instead of A1:A1 //for full-column ranges or full-row ranges return A:A instead of A, //and 1:1 instead of 1 if(!cellRefFrom.equals(cellRefTo) || isFullColumnRange() || isFullRowRange()){ sb.append(':'); sb.append(cellRefTo.formatAsString()); } return sb.toString(); }
/** * @return the text format of this range using specified sheet name. */ public String formatAsString(String sheetName, boolean useAbsoluteAddress) { StringBuffer sb = new StringBuffer(); if (sheetName != null) { sb.append(SheetNameFormatter.format(sheetName)); sb.append("!"); } CellReference cellRefFrom = new CellReference(getFirstRow(), getFirstColumn(), useAbsoluteAddress, useAbsoluteAddress); CellReference cellRefTo = new CellReference(getLastRow(), getLastColumn(), useAbsoluteAddress, useAbsoluteAddress); sb.append(cellRefFrom.formatAsString()); //for a single-cell reference return A1 instead of A1:A1 if(!cellRefFrom.equals(cellRefTo)){ sb.append(':'); sb.append(cellRefTo.formatAsString()); } return sb.toString(); }
/** * @return the text format of this range using specified sheet name. */ public String formatAsString(String sheetName, boolean useAbsoluteAddress) { StringBuffer sb = new StringBuffer(); if (sheetName != null) { sb.append(SheetNameFormatter.format(sheetName)); sb.append("!"); } CellReference cellRefFrom = new CellReference(getFirstRow(), getFirstColumn(), useAbsoluteAddress, useAbsoluteAddress); CellReference cellRefTo = new CellReference(getLastRow(), getLastColumn(), useAbsoluteAddress, useAbsoluteAddress); sb.append(cellRefFrom.formatAsString()); //for a single-cell reference return A1 instead of A1:A1 //for full-column ranges or full-row ranges return A:A instead of A, //and 1:1 instead of 1 if(!cellRefFrom.equals(cellRefTo) || isFullColumnRange() || isFullRowRange()){ sb.append(':'); sb.append(cellRefTo.formatAsString()); } return sb.toString(); }
/** * @return the text format of this range using specified sheet name. */ public String formatAsString(String sheetName, boolean useAbsoluteAddress) { StringBuilder sb = new StringBuilder(); if (sheetName != null) { sb.append(SheetNameFormatter.format(sheetName)); sb.append("!"); } CellReference cellRefFrom = new CellReference(getFirstRow(), getFirstColumn(), useAbsoluteAddress, useAbsoluteAddress); CellReference cellRefTo = new CellReference(getLastRow(), getLastColumn(), useAbsoluteAddress, useAbsoluteAddress); sb.append(cellRefFrom.formatAsString()); //for a single-cell reference return A1 instead of A1:A1 //for full-column ranges or full-row ranges return A:A instead of A, //and 1:1 instead of 1 if(!cellRefFrom.equals(cellRefTo) || isFullColumnRange() || isFullRowRange()){ sb.append(':'); sb.append(cellRefTo.formatAsString()); } return sb.toString(); }