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

    /** 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

     * @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);
        }


    //allow the poi utilities to parse it out
        name.setAreaReference(ref);

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


        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);
        }


    //allow the poi utilities to parse it out
        name.setAreaReference(ref);

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

    /** 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 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

    {
        field_5_last_column = column;
    }


    public String getArea(){
        RangeAddress ra = new RangeAddress( getFirstColumn(),getFirstRow() + 1, getLastColumn(), getLastRow() + 1);
        String result = ra.getAddress();


        return result;
    }

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.