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

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

    /**
     * Setup the merged regions
     * @exception IOException
     */
    public void endProcessing() throws IOException {
        RangeAddress rangeAddress = new RangeAddress(getCellRange());
        Sheet sheet = this.getSheet();


        //subtracting one since rangeaddress starts at 1,1 where rows/cols
        // start at 0,0
        short fromCol =
            (short) (rangeAddress.getXPosition(rangeAddress.getFromCell()) - 1);
        int fromRow = rangeAddress.getYPosition(rangeAddress.getFromCell()) - 1;
        short toCol =
            (short) (rangeAddress.getXPosition(rangeAddress.getToCell()) - 1);
        int toRow = rangeAddress.getYPosition(rangeAddress.getToCell()) - 1;


        if (getLogger().isDebugEnabled()) {
            getLogger().debug("Merging Range: Row (" + fromRow + ") Col ("
                    + fromCol + ")" + " to Row (" + toRow + ") Col (" + toCol
                    + ")");

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

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

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


        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


        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

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.