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()

    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()

        StringBuffer sb = new StringBuffer();
        sb.append(getClass().getName());
        sb.append(" [");
        sb.append("sheetIx=").append(getExternSheetIndex());
        sb.append(" ! ");
        sb.append(cr.formatAsString());
        sb.append("]");
        return sb.toString();
    }


    public void writeBytes(byte [] array, int offset) {

View Full Code Here

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

    public final String toString() {
        CellReference cr = new CellReference(getRow(), getColumn(), !isRowRelative(),!isColRelative());
        StringBuffer sb = new StringBuffer();
        sb.append(getClass().getName());
        sb.append(" [");
        sb.append(cr.formatAsString());
        sb.append("]");
        return sb.toString();
    }


    public final void writeBytes(byte [] array, int offset) {

View Full Code Here

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

        for (DataExpectation dataExpectation : dataExpectations) {
            try {
                if (dataExpectation != null && dataExpectation.object != null) {
                    if ( cellValue == null || StringUtils.isEmpty(cellValue.toString())){
                        if ( dataExpectation.errorMessage != null && !StringUtils.isEmpty(dataExpectation.errorMessage)) {
                            parseErrors.add(new ScorecardError(cellRef.formatAsString(), dataExpectation.errorMessage));
                            return;
                        }
                    }
                    String setter = "set" + Character.toUpperCase(dataExpectation.property.charAt(0)) + dataExpectation.property.substring(1);
                    method = getSuitableMethod(cellValue, expectedClass, dataExpectation, setter);

View Full Code Here

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

                    }
                    String setter = "set" + Character.toUpperCase(dataExpectation.property.charAt(0)) + dataExpectation.property.substring(1);
                    method = getSuitableMethod(cellValue, expectedClass, dataExpectation, setter);
                    if ( method == null ) {
                        if (cellValue != null && !StringUtils.isEmpty(cellValue.toString())) {
                            parseErrors.add(new ScorecardError(cellRef.formatAsString(), "Unexpected Value! Wrong Datatype?"));
                        }
                        return;
                    }
                    if (method.getParameterTypes()[0] == Double.class) {
                        cellValue = Double.parseDouble(cellValue.toString());

View Full Code Here

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

                    if (method.getParameterTypes()[0] == String.class && !(cellValue instanceof String) && cellValue != null) {
                        cellValue = cellValue.toString();
                    }
                    method.invoke(dataExpectation.object, cellValue);
                    if (dataExpectation.object instanceof Extension && ("cellRef".equals(((Extension) dataExpectation.object).getName()))) {
                        ((Extension) dataExpectation.object).setValue(cellRef.formatAsString());
                    }
                    //dataExpectations.remove(dataExpectation);
                }
            } catch (Exception e) {
                throw new ScorecardParseException(e);

View Full Code Here

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

        for (DataExpectation dataExpectation : dataExpectations) {
            try {
                if (dataExpectation != null && dataExpectation.object != null) {
                    if ( cellValue == null || StringUtils.isEmpty(cellValue.toString())){
                        if ( dataExpectation.errorMessage != null && !StringUtils.isEmpty(dataExpectation.errorMessage)) {
                            parseErrors.add(new ScorecardError(cellRef.formatAsString(), dataExpectation.errorMessage));
                            return;
                        }
                    }
                    String setter = "set" + Character.toUpperCase(dataExpectation.property.charAt(0)) + dataExpectation.property.substring(1);
                    Method method = getSuitableMethod(cellValue, expectedClass, dataExpectation, setter);

View Full Code Here

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

                    }
                    String setter = "set" + Character.toUpperCase(dataExpectation.property.charAt(0)) + dataExpectation.property.substring(1);
                    Method method = getSuitableMethod(cellValue, expectedClass, dataExpectation, setter);
                    if ( method == null ) {
                        if (cellValue != null && !StringUtils.isEmpty(cellValue.toString())) {
                            parseErrors.add(new ScorecardError(cellRef.formatAsString(), "Unexpected Value! Wrong Datatype?"));
                        }
                        return;
                    }
                    if (method.getParameterTypes()[0] == Double.class) {
                        cellValue = new Double(Double.parseDouble(cellValue.toString()));

View Full Code Here

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

                    if (method.getParameterTypes()[0] == Boolean.class) {
                        cellValue = Boolean.valueOf(cellValue.toString());
                    }
                    method.invoke(dataExpectation.object, cellValue);
                    if (dataExpectation.object instanceof Extension && ("cellRef".equals(((Extension) dataExpectation.object).getName()))) {
                        ((Extension) dataExpectation.object).setValue(cellRef.formatAsString());
                    }
                    //dataExpectations.remove(dataExpectation);
                }
            } catch (Exception e) {
                throw new ScorecardParseException(e);

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.