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());if(!cellRefFrom.equals(cellRefTo)|| isFullColumnRange() || isFullRowRange()){sb.append(':');sb.append(cellRefTo.formatAsString());}return sb.toString();}

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 ( ) ) ; if ( ! cellRefFrom . equals ( cellRefTo ) || isFullColumnRange ( ) || isFullRowRange ( ) ) { sb . append ( ':' ) ; sb . append ( cellRefTo . formatAsString ( ) ) ; } return sb . toString ( ) ; }
public String FormatAsString(String sheetName, bool useAbsoluteAddress){StringBuilder sb = new StringBuilder();if (sheetName != null){sb.Append(SheetNameFormatter.Format(sheetName));sb.Append("!");}CellReference cellRefFrom = new CellReference(FirstRow, FirstColumn,useAbsoluteAddress, useAbsoluteAddress);CellReference cellRefTo = new CellReference(LastRow, LastColumn,useAbsoluteAddress, useAbsoluteAddress);sb.Append(cellRefFrom.FormatAsString());if (!cellRefFrom.Equals(cellRefTo)|| IsFullColumnRange || IsFullRowRange){sb.Append(':');sb.Append(cellRefTo.FormatAsString());}return sb.ToString();}
