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

Class org.apache.poi.hssf.util.AreaReference

Examples of org.apache.poi.hssf.util.AreaReference.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.

            AreaReference areaRef = parseArea(secondIden);
            if (areaRef == null) {
                return new Ref3DPtg(secondIden, externIdx);
            }
            // will happen if dots are used instead of colon
            return new Area3DPtg(areaRef.formatAsString(), externIdx);
        }


        String name = iden.getName();
        AreaReference areaRef = parseArea(name);
        if (areaRef != null) {

View Full Code Here


        String name = iden.getName();
        AreaReference areaRef = parseArea(name);
        if (areaRef != null) {
            // will happen if dots are used instead of colon
            return new AreaPtg(areaRef.formatAsString());
        }
        // This can be either a cell ref or a named range




        int nameType = CellReference.classifyCellReference(name);

View Full Code Here

    private Ptg parseNameOrReference(String name) {
        
        AreaReference areaRef = parseArea(name);
        if (areaRef != null) {
            // will happen if dots are used instead of colon
            return new AreaPtg(areaRef.formatAsString());
        }


        if (look == ':' || look == '.') { // this is a AreaReference
            GetChar();

View Full Code Here

            String first = parseIdentifier();
            short externIdx = (short)book.getExternalSheetIndex(book.getSheetIndex(sheetName));
            areaRef = parseArea(name);
            if (areaRef != null) {
                // will happen if dots are used instead of colon
                return new Area3DPtg(areaRef.formatAsString(), externIdx);
            }
            if (look == ':') {
                Match(':');
                String second=parseIdentifier();
                if (look == '!') {

View Full Code Here

            AreaReference areaRef = parseArea(secondIden);
            if (areaRef == null) {
                return new Ref3DPtg(secondIden, externIdx);
            }
            // will happen if dots are used instead of colon
            return new Area3DPtg(areaRef.formatAsString(), externIdx);
        }


        String name = iden.getName();
        AreaReference areaRef = parseArea(name);
        if (areaRef != null) {

View Full Code Here


        String name = iden.getName();
        AreaReference areaRef = parseArea(name);
        if (areaRef != null) {
            // will happen if dots are used instead of colon
            return new AreaPtg(areaRef.formatAsString());
        }
        // This can be either a cell ref or a named range




        int nameType = CellReference.classifyCellReference(name);

View Full Code Here

    private Ptg parseNameOrReference(String name) {


        AreaReference areaRef = parseArea(name);
        if (areaRef != null) {
            // will happen if dots are used instead of colon
            return new AreaPtg(areaRef.formatAsString());
        }


        if (look == ':' || look == '.') { // this is a AreaReference
            GetChar();

View Full Code Here

            String first = parseIdentifier();
            int externIdx = book.getExternalSheetIndex(sheetName);
            areaRef = parseArea(name);
            if (areaRef != null) {
                // will happen if dots are used instead of colon
                return new Area3DPtg(areaRef.formatAsString(), externIdx);
            }
            if (look == ':') {
                Match(':');
                String second=parseIdentifier();
                if (look == '!') {

View Full Code Here

            AreaReference areaRef = parseArea(secondIden);
            if (areaRef == null) {
                return new Ref3DPtg(secondIden, externIdx);
            }
            // will happen if dots are used instead of colon
            return new Area3DPtg(areaRef.formatAsString(), externIdx);
        }


        String name = iden.getName();
        AreaReference areaRef = parseArea(name);
        if (areaRef != null) {

View Full Code Here


        String name = iden.getName();
        AreaReference areaRef = parseArea(name);
        if (areaRef != null) {
            // will happen if dots are used instead of colon
            return new AreaPtg(areaRef.formatAsString());
        }
        // This can be either a cell ref or a named range




        int nameType = CellReference.classifyCellReference(name);

View Full Code Here

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.