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

                    refy2=(short)(y-3);
                }


                c = r.getCell(y);
                CellReference cr= new CellReference(refx1,refy1, false, false);
                ref=cr.formatAsString();
                cr=new CellReference(refx2,refy2, false, false);
                ref2=cr.formatAsString();


                c = r.createCell(y);
                c.setCellFormula("" + ref + operator + ref2);

View Full Code Here

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


                c = r.getCell(y);
                CellReference cr= new CellReference(refx1,refy1, false, false);
                ref=cr.formatAsString();
                cr=new CellReference(refx2,refy2, false, false);
                ref2=cr.formatAsString();


                c = r.createCell(y);
                c.setCellFormula("" + ref + operator + ref2);

View Full Code Here

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

                    refy2=y-3;
                }


                c = r.getCell(y);
                CellReference cr= new CellReference(refx1, refy1, false, false);
                String ref=cr.formatAsString();
                ref=cr.formatAsString();
                cr=new CellReference(refx2,refy2, false, false);
                String ref2=cr.formatAsString();

View Full Code Here

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

                }


                c = r.getCell(y);
                CellReference cr= new CellReference(refx1, refy1, false, false);
                String ref=cr.formatAsString();
                ref=cr.formatAsString();
                cr=new CellReference(refx2,refy2, false, false);
                String ref2=cr.formatAsString();




                assertTrue("loop Formula is as expected "+ref+operator+ref2+"!="+c.getCellFormula(),(

View Full Code Here

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

                c = r.getCell(y);
                CellReference cr= new CellReference(refx1, refy1, false, false);
                String ref=cr.formatAsString();
                ref=cr.formatAsString();
                cr=new CellReference(refx2,refy2, false, false);
                String ref2=cr.formatAsString();




                assertTrue("loop Formula is as expected "+ref+operator+ref2+"!="+c.getCellFormula(),(
                (""+ref+operator+ref2).equals(c.getCellFormula())
                                                         )

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.ss.usermodel.CellValue.formatAsString()

        evaluator.evaluateAll();
        
        XSSFCell cell = excel.getSheetAt(0).getRow(1).getCell(1);
        CellValue value = evaluator.evaluate(cell);
        
        assertEquals(expect, value.formatAsString());
    }
}

View Full Code Here

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

            location.setFirstDataRow(1);
            location.setFirstHeaderRow(1);
        } else {
            location = pivotTableDefinition.getLocation();
        }
        location.setRef(destination.formatAsString());
        pivotTableDefinition.setLocation(location);


        //Set source for the pivot table
        CTPivotCacheDefinition cacheDef = getPivotCacheDefinition().getCTPivotCacheDefinition();
        CTCacheSource cacheSource = cacheDef.addNewCacheSource();

View Full Code Here

Examples of org.apache.poi.ss.util.CellRangeAddress.formatAsString()

        CTAutoFilter af = worksheet.getAutoFilter();
        if(af == null) af = worksheet.addNewAutoFilter();


        CellRangeAddress norm = new CellRangeAddress(range.getFirstRow(), range.getLastRow(),
                range.getFirstColumn(), range.getLastColumn());
        String ref = norm.formatAsString();
        af.setRef(ref);


        XSSFWorkbook wb = getWorkbook();
        int sheetIndex = getWorkbook().getSheetIndex(this);
        XSSFName name = wb.getBuiltInName(XSSFName.BUILTIN_FILTER_DB, sheetIndex);

View Full Code Here

Examples of org.apache.poi.ss.util.CellRangeAddress.formatAsString()


        assertTrue(lbs.getFormula() instanceof AreaPtg);
        AreaPtg ptg = (AreaPtg)lbs.getFormula();
        CellRangeAddress range = new CellRangeAddress(
                ptg.getFirstRow(), ptg.getLastRow(), ptg.getFirstColumn(), ptg.getLastColumn());
        assertEquals("H10:H13", range.formatAsString());


        // check that it re-serializes to the same data
        byte[] ser = record.serialize();
        TestcaseRecordInputStream.confirmRecordEncoding(ObjRecord.sid, data, ser);
    }

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.