Examples of RangeAddress

org.apache.poi.hssf.util.RangeAddress
Title: Range Address
Description: provides connectivity utilities for ranges
REFERENCE:
@author IgOr KaTz && EuGeNe BuMaGiN (Tal Moshaiov) (VistaPortal LDT.) @version 1.0
org.formulacompiler.runtime.spreadsheet.RangeAddress
This interface provides information about location of a range in a spreadsheet. @author Vladimir Korenev

Examples of org.apache.poi.hssf.util.RangeAddress

        return result;
    }*/


    public void setArea( String ref )
    {
        RangeAddress ra = new RangeAddress( ref );


        String from = ra.getFromCell();
        String to = ra.getToCell();


        setFirstColumn( (short) ( ra.getXPosition( from ) - 1 ) );
        setFirstRow( (short) ( ra.getYPosition( from ) - 1 ) );
        setLastColumn( (short) ( ra.getXPosition( to ) - 1 ) );
        setLastRow( (short) ( ra.getYPosition( to ) - 1 ) );


    }

View Full Code Here

Examples of org.apache.poi.hssf.util.RangeAddress


        return result;
    }*/


    public void setArea(String ref){
        RangeAddress ra = new RangeAddress(ref);


        String from = ra.getFromCell();


        setColumn((short) (ra.getXPosition(from) -1));
        setRow((short) (ra.getYPosition(from) -1));


    }

View Full Code Here

Examples of org.apache.poi.hssf.util.RangeAddress

     * @param ref the reference to set
     */    


    public void setReference(String ref){


        RangeAddress ra = new RangeAddress(ref);


        String sheetName = ra.getSheetName();


        if (ra.hasSheetName()) {
            setSheetName(sheetName);
        }


        if (ra.getFromCell().equals(ra.getToCell()) == false) {
            name.setAreaReference(ra.getFromCell() + ":" + ra.getToCell());
        } else {
            name.setAreaReference(ra.getFromCell());            
        }


    }

View Full Code Here

Examples of org.apache.poi.hssf.util.RangeAddress

    /** sets the reference , the area only (range)
     * @param ref area reference
     */
    public void setAreaReference(String ref){
        //Trying to find if what ptg do we need
        RangeAddress ra = new RangeAddress(ref);
        Ptg oldPtg;
        Ptg ptg;


        if (field_13_name_definition==null ||field_13_name_definition.isEmpty()){
            field_13_name_definition = new Stack();
            oldPtg = createNewPtg();
        } else {
            //Trying to find extern sheet index
            oldPtg = (Ptg) field_13_name_definition.pop();
        }


        short externSheetIndex = 0;


        if (oldPtg.getClass() == Area3DPtg.class){
            externSheetIndex =  ((Area3DPtg) oldPtg).getExternSheetIndex();


        } else if (oldPtg.getClass() == Ref3DPtg.class){
            externSheetIndex =  ((Ref3DPtg) oldPtg).getExternSheetIndex();
        }


        if (ra.hasRange()) {
            ptg = new Area3DPtg();
            ((Area3DPtg) ptg).setExternSheetIndex(externSheetIndex);
            ((Area3DPtg) ptg).setArea(ref);
            this.setDefinitionTextLength((short)ptg.getSize());
        } else {

View Full Code Here

Examples of org.apache.poi.hssf.util.RangeAddress


    


    public void setArea(String ref){


        RangeAddress ra = new RangeAddress(ref);


        


        String from = ra.getFromCell();


        String to   = ra.getToCell();


        


        setFirstColumn((short) (ra.getXPosition(from) -1));


        setFirstRow((short) (ra.getYPosition(from) -1));


        setLastColumn((short) (ra.getXPosition(to) -1));


        setLastRow((short) (ra.getYPosition(to) -1));


                        


    }

View Full Code Here

Examples of org.apache.poi.hssf.util.RangeAddress


    


    public String getArea(){


        RangeAddress ra = new RangeAddress("");


        


        String result = (ra.numTo26Sys(getColumn()) + (getRow() + 1));


        


        return result;

View Full Code Here

Examples of org.apache.poi.hssf.util.RangeAddress






    public void setArea(String ref){


        RangeAddress ra = new RangeAddress(ref);


        


        String from = ra.getFromCell();


        


        setColumn((short) (ra.getXPosition(from) -1));


        setRow((short) (ra.getYPosition(from) -1));


                        


    }

View Full Code Here

Examples of org.apache.poi.hssf.util.RangeAddress


    public void setAreaReference(String ref){


        //Trying to find if what ptg do we need


        RangeAddress ra = new RangeAddress(ref);


        Ptg oldPtg;


        Ptg ptg;


        


        if (field_13_name_definition.isEmpty()){


            oldPtg = createNewPtg();


        } else {


            //Trying to find extern sheet index


            oldPtg = (Ptg) field_13_name_definition.pop();


        }


        


        short externSheetIndex = 0;


        


        if (oldPtg.getClass() == Area3DPtg.class){


            externSheetIndex =  ((Area3DPtg) oldPtg).getExternSheetIndex();


            


        } else if (oldPtg.getClass() == Ref3DPtg.class){


            externSheetIndex =  ((Ref3DPtg) oldPtg).getExternSheetIndex();


        }


        


        if (ra.hasRange()) {


            ptg = new Area3DPtg();


            ((Area3DPtg) ptg).setExternSheetIndex(externSheetIndex);

View Full Code Here

Examples of org.apache.poi.hssf.util.RangeAddress

    /** sets the reference , the area only (range)
     * @param ref area reference
     */
    public void setAreaReference(String ref){
        //Trying to find if what ptg do we need
        RangeAddress ra = new RangeAddress(ref);
        Ptg oldPtg;
        Ptg ptg;


        if (field_13_name_definition==null ||field_13_name_definition.isEmpty()){
            field_13_name_definition = new Stack();
            oldPtg = createNewPtg();
        } else {
            //Trying to find extern sheet index
            oldPtg = (Ptg) field_13_name_definition.pop();
        }


        short externSheetIndex = 0;


        if (oldPtg.getClass() == Area3DPtg.class){
            externSheetIndex =  ((Area3DPtg) oldPtg).getExternSheetIndex();


        } else if (oldPtg.getClass() == Ref3DPtg.class){
            externSheetIndex =  ((Ref3DPtg) oldPtg).getExternSheetIndex();
        }


        if (ra.hasRange()) {
            ptg = new Area3DPtg();
            ((Area3DPtg) ptg).setExternSheetIndex(externSheetIndex);
            ((Area3DPtg) ptg).setArea(ref);
            this.setDefinitionTextLength((short)((Area3DPtg) ptg).getSize());
        } else {

View Full Code Here

Examples of org.apache.poi.hssf.util.RangeAddress


        return result;
    }*/


    public void setArea(String ref){
        RangeAddress ra = new RangeAddress(ref);


        String from = ra.getFromCell();
        String to   = ra.getToCell();


        setFirstColumn((short) (ra.getXPosition(from) -1));
        setFirstRow((short) (ra.getYPosition(from) -1));
        setLastColumn((short) (ra.getXPosition(to) -1));
        setLastRow((short) (ra.getYPosition(to) -1));


    }

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.