List of formatAsString() Examples

Examples of formatAsString()

com.volantis.styling.impl.functions.counter.CounterFormatter.formatAsString()
Format the counter value as a {@link String}. @param formatStyle The style to use. @param counterValue The counter value. @return The style value as a string.
edu.umd.cs.findbugs.ba.Edge.formatAsString()
Return a string representation of the edge.
org.apache.poi.hssf.record.HyperlinkRecord.GUID.formatAsString()
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.CellValue.formatAsString()

org.apache.poi.hssf.util.AreaReference.formatAsString()

Example return values:

Result	Comment
A1:A1	Single cell area reference without sheet
A1:$C$1	Multi-cell area reference without sheet
Sheet1!A$1:B4	Standard sheet name
'O''Brien''s Sales'!B5:C6'	Sheet name with special characters

@return the text representation of this area reference as it would appear in a formula.

org.apache.poi.hssf.util.CellReference.formatAsString()
Example return values:

Result Comment

A1 Cell reference without sheet

Sheet1!A1 Standard sheet name

'O''Brien''s Sales'!A1' Sheet name with special characters

@return the text representation of this cell reference as it would appear in a formula.
org.apache.poi.ss.usermodel.CellValue.formatAsString()

Result	Comment
A1	Cell reference without sheet
Sheet1!A1	Standard sheet name
'O''Brien''s Sales'!A1'	Sheet name with special characters

org.apache.poi.ss.util.AreaReference.formatAsString()

Returns a text representation of this area reference.

Example return values:

Result	Comment
A1:A1	Single cell area reference without sheet
A1:$C$1	Multi-cell area reference without sheet
Sheet1!A$1:B4	Standard sheet name
'O''Brien''s Sales'!B5:C6'	Sheet name with special characters

@return the text representation of this area reference as it would appear in a formula.

org.apache.poi.ss.util.CellRangeAddress.formatAsString()
@return the text format of this range. Single cell ranges are formattedlike single cell references (e.g. 'A1' instead of 'A1:A1').
org.apache.poi.ss.util.CellReference.formatAsString()
Example return values:

Result Comment

A1 Cell reference without sheet

Sheet1!A1 Standard sheet name

'O''Brien''s Sales'!A1' Sheet name with special characters

@return the text representation of this cell reference as it would appear in a formula.
org.zkoss.poi.ss.util.CellRangeAddress.formatAsString()
org.zkoss.poi.ss.util.CellReference.formatAsString()

Result	Comment
A1	Cell reference without sheet
Sheet1!A1	Standard sheet name
'O''Brien''s Sales'!A1'	Sheet name with special characters

Examples of org.apache.poi.hssf.util.CellReference.formatAsString()

      return cce.getValue();
    }
    if (isDebugLogEnabled()) {
      String sheetName = getSheetName(sheetIndex);
      CellReference cr = new CellReference(rowIndex, columnIndex);
      logDebug("Evaluated " + sheetName + "!" + cr.formatAsString() + " to " + result.toString());
    }
    // Usually (result === cce.getValue())
    // But sometimes: (result==ErrorEval.CIRCULAR_REF_ERROR, cce.getValue()==null)
    // When circular references are detected, the cache entry is only updated for
    // the top evaluation frame

View Full Code Here

Examples of org.apache.poi.hssf.util.CellReference.formatAsString()

  private NotImplementedException addExceptionInfo(NotImplementedException inner, int sheetIndex, int rowIndex, int columnIndex) {


    try {
      String sheetName = _workbook.getSheetName(sheetIndex);
      CellReference cr = new CellReference(sheetName, rowIndex, columnIndex, false, false);
      String msg =  "Error evaluating cell " + cr.formatAsString();
      return new NotImplementedException(msg, inner);
    } catch (Exception e) {
      // avoid bombing out during exception handling
      e.printStackTrace();
      return inner; // preserve original exception

View Full Code Here

Examples of org.apache.poi.hssf.util.CellReference.formatAsString()

    sb.append(getClass().getName()).append("[");
    sb.append(_evaluator.getSheetName());
    sb.append('!');
    sb.append(crA.formatAsString());
    sb.append(':');
    sb.append(crB.formatAsString());
    sb.append("]");
    return sb.toString();
  }
}

View Full Code Here

Examples of org.apache.poi.hssf.util.CellReference.formatAsString()

    public void setPrintArea(int sheetIndex, int startColumn, int endColumn,
                              int startRow, int endRow) {


        //using absolute references because they don't get copied and pasted anyway
        CellReference cell = new CellReference(startRow, startColumn, true, true);
        String reference = cell.formatAsString();


        cell = new CellReference(endRow, endColumn, true, true);
        reference = reference+":"+cell.formatAsString();


        setPrintArea(sheetIndex, reference);

View Full Code Here

Examples of org.apache.poi.hssf.util.CellReference.formatAsString()

        //using absolute references because they don't get copied and pasted anyway
        CellReference cell = new CellReference(startRow, startColumn, true, true);
        String reference = cell.formatAsString();


        cell = new CellReference(endRow, endColumn, true, true);
        reference = reference+":"+cell.formatAsString();


        setPrintArea(sheetIndex, reference);
    }

View Full Code Here

Examples of org.apache.poi.hssf.util.CellReference.formatAsString()

      return cce.getValue();
    }
    if (isDebugLogEnabled()) {
      String sheetName = getSheetName(sheetIndex);
      CellReference cr = new CellReference(rowIndex, columnIndex);
      logDebug("Evaluated " + sheetName + "!" + cr.formatAsString() + " to " + result.toString());
    }
    // Usually (result === cce.getValue())  
    // But sometimes: (result==ErrorEval.CIRCULAR_REF_ERROR, cce.getValue()==null)
    // When circular references are detected, the cache entry is only updated for 
    // the top evaluation frame

View Full Code Here

Examples of org.apache.poi.hssf.util.CellReference.formatAsString()

  private NotImplementedException addExceptionInfo(NotImplementedException inner, int sheetIndex, int rowIndex, int columnIndex) {
    
    try {
      String sheetName = _workbook.getSheetName(sheetIndex);
      CellReference cr = new CellReference(sheetName, rowIndex, columnIndex, false, false);
      String msg =  "Error evaluating cell " + cr.formatAsString();
      return new NotImplementedException(msg, inner);
    } catch (Exception e) {
      // avoid bombing out during exception handling
      e.printStackTrace();
      return inner; // preserve original exception

View Full Code Here

Examples of org.apache.poi.hssf.util.CellReference.formatAsString()

    CellReference cr = new CellReference(getRow(), getColumn());
    StringBuffer sb = new StringBuffer();
    sb.append(getClass().getName()).append("[");
    sb.append(_evaluator.getSheetName());
    sb.append('!');
    sb.append(cr.formatAsString());
    sb.append("]");
    return sb.toString();
  }
}

View Full Code Here

Examples of org.apache.poi.hssf.util.CellReference.formatAsString()

    public void setPrintArea(int sheetIndex, int startColumn, int endColumn,
                              int startRow, int endRow) {


        //using absolute references because they don't get copied and pasted anyway
        CellReference cell = new CellReference(startRow, startColumn, true, true);
        String reference = cell.formatAsString();


        cell = new CellReference(endRow, endColumn, true, true);
        reference = reference+":"+cell.formatAsString();


        setPrintArea(sheetIndex, reference);

View Full Code Here

Examples of org.apache.poi.hssf.util.CellReference.formatAsString()

        //using absolute references because they don't get copied and pasted anyway
        CellReference cell = new CellReference(startRow, startColumn, true, true);
        String reference = cell.formatAsString();


        cell = new CellReference(endRow, endColumn, true, true);
        reference = reference+":"+cell.formatAsString();


        setPrintArea(sheetIndex, reference);
    }

View Full Code Here

0 1 2 3 4 5

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.