Examples of SheetReferences

org.apache.poi.hssf.util.SheetReferences
Holds a collection of Sheet names and their associated reference numbers. @author Andrew C. Oliver (acoliver at apache dot org)
org.apache.poi.ss.util.SheetReferences
Holds a collection of Sheet names and their associated reference numbers. @author Andrew C. Oliver (acoliver at apache dot org)

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

    assertEquals(3, listener.getBoundSheetRecords().length);
    assertEquals(1, listener.getExternSheetRecords().length);
    
    assertEquals(3, listener.getStubWorkbook().getNumSheets());
    
    SheetReferences ref = listener.getStubWorkbook().getSheetReferences();
    assertEquals("Sh3", ref.getSheetName(0));
    assertEquals("Sheet1", ref.getSheetName(1));
    assertEquals("S2", ref.getSheetName(2));
  }

View Full Code Here

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

        }
        return linkTable;
    }


    public SheetReferences getSheetReferences() {
        SheetReferences refs = new SheetReferences();
        
        if (linkTable != null) {
            int numRefStructures = linkTable.getNumberOfREFStructures();
            for (short k = 0; k < numRefStructures; k++) {
                
                String sheetName = findSheetNameFromExternSheet(k);
                refs.addSheetReference(sheetName, k);
                
            }
        }
        return refs;
    }

View Full Code Here

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

    protected Record createEOF() {
        return new EOFRecord();
    }


    public SheetReferences getSheetReferences() {
        SheetReferences refs = new SheetReferences();
        
        if (externSheet != null) {
            for (int k = 0; k < externSheet.getNumOfREFStructures(); k++) {
                
                String sheetName = findSheetNameFromExternSheet((short)k);
                refs.addSheetReference(sheetName, k);
                
            }
        }
        return refs;
    }

View Full Code Here

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




        assertEquals(true, flag.getValue());
        assertEquals("Y", y.getValue());
        assertEquals("N", n.getValue());
        assertEquals("IF", funif.toFormulaString(new SheetReferences()));
        assertTrue("Goto ptg exists", goto1.isGoto());
    }

View Full Code Here

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

        }
    }


    public String getCellFormula() {
        //Workbook.currentBook=book;
        SheetReferences refs = book.getSheetReferences();
        String retval = FormulaParser.toFormulaString(refs, ((FormulaRecordAggregate)record).getFormulaRecord().getParsedExpression());
        //Workbook.currentBook=null;
        return retval;
    }

View Full Code Here

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

     * @return reference of the named range
     */    


    public String getReference() {
        String result;
        SheetReferences refs = book.getSheetReferences();
        result = name.getAreaReference(refs);


        return result;
    }

View Full Code Here

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

    protected Record createEOF() {
        return new EOFRecord();
    }


    public SheetReferences getSheetReferences() {
       SheetReferences refs = new SheetReferences();


       if (externSheet != null) {
          for (int k = 0; k < externSheet.getNumOfREFStructures(); k++) {
              String sheetName = findSheetNameFromExternSheet((short)k);
              refs.addSheetReference(sheetName, k);
          }
       }
       return refs;
    }

View Full Code Here

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

   
    /** toString on the parser instance returns the RPN ordered list of tokens
     *   Useful for testing
     */
    public String toString() {
        SheetReferences refs = null;
        if (book!=null)  book.getSheetReferences();
        StringBuffer buf = new StringBuffer();
           for (int i=0;i<tokens.size();i++) {
            buf.append( ( (Ptg)tokens.get(i)).toFormulaString(refs));
            buf.append(' ');

View Full Code Here

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

    setLastRowRelative(  !lastCell.isRowAbsolute() );
  }


  public String toFormulaString(Workbook book)
  {
    SheetReferences refs = book == null ? null : book.getSheetReferences();
    StringBuffer retval = new StringBuffer();
    if ( refs != null )
    {
      retval.append( refs.getSheetName( this.field_1_index_extern_sheet ) );
      retval.append( '!' );
    }
    retval.append( ( new CellReference( getFirstRow(), getFirstColumn(), !isFirstRowRelative(), !isFirstColRelative() ) ).toString() );
    retval.append( ':' );
    retval.append( ( new CellReference( getLastRow(), getLastColumn(), !isLastRowRelative(), !isLastColRelative() ) ).toString() );

View Full Code Here

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

    protected Record createEOF() {
        return new EOFRecord();
    }


    public SheetReferences getSheetReferences() {
        SheetReferences refs = new SheetReferences();
        
        if (externSheet != null) {
            for (int k = 0; k < externSheet.getNumOfREFStructures(); k++) {
                
                String sheetName = findSheetNameFromExternSheet((short)k);
                refs.addSheetReference(sheetName, k);
                
            }
        }
        return refs;
    }

View Full Code Here

0 1 2 3 4

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.