Uses of Interface
org.apache.poi.hssf.record.formula.functions.FreeRefFunction

Packages that use FreeRefFunction
org.apache.poi.hssf.record.formula.eval   
org.apache.poi.hssf.record.formula.functions   
 

Uses of FreeRefFunction in org.apache.poi.hssf.record.formula.eval
 

Methods in org.apache.poi.hssf.record.formula.eval that return FreeRefFunction
 FreeRefFunction FunctionEval.getFreeRefFunction()
           
 

Uses of FreeRefFunction in org.apache.poi.hssf.record.formula.functions
 

Classes in org.apache.poi.hssf.record.formula.functions that implement FreeRefFunction
 class Indirect
          Implementation for Excel function INDIRECT

INDIRECT() returns the cell or area reference denoted by the text argument.

Syntax:
INDIRECT(ref_text,isA1Style)

ref_text a string representation of the desired reference as it would normally be written in a cell formula.
isA1Style (default TRUE) specifies whether the ref_text should be interpreted as A1-style or R1C1-style.

 class Offset
          Implementation for Excel function OFFSET()

OFFSET returns an area reference that is a specified number of rows and columns from a reference cell or area.

Syntax:
OFFSET(reference, rows, cols, height, width)

reference is the base reference.
rows is the number of rows up or down from the base reference.
cols is the number of columns left or right from the base reference.
height (default same height as base reference) is the row count for the returned area reference.
width (default same width as base reference) is the column count for the returned area reference.

 



Copyright 2008 The Apache Software Foundation or its licensors, as applicable.