| Package | Description | 
|---|---|
| org.apache.poi.ss.formula | This package contains common internal POI code for manipulating formulas. | 
| org.apache.poi.ss.formula.eval | 
| Modifier and Type | Class and Description | 
|---|---|
| class  | CacheAreaEval | 
| Modifier and Type | Method and Description | 
|---|---|
| AreaEval | LazyRefEval. offset(int relFirstRowIx,
      int relLastRowIx,
      int relFirstColIx,
      int relLastColIx) | 
| AreaEval | CacheAreaEval. offset(int relFirstRowIx,
      int relLastRowIx,
      int relFirstColIx,
      int relLastColIx) | 
| Modifier and Type | Class and Description | 
|---|---|
| class  | AreaEvalBase | 
| Modifier and Type | Method and Description | 
|---|---|
| AreaEval | RefEval. offset(int relFirstRowIx,
      int relLastRowIx,
      int relFirstColIx,
      int relLastColIx)Creates an  AreaEvaloffset by a relative amount from this RefEval | 
| AreaEval | AreaEval. offset(int relFirstRowIx,
      int relLastRowIx,
      int relFirstColIx,
      int relLastColIx)Creates an  AreaEvaloffset by a relative amount from from the upper left cell
 of this area | 
| Modifier and Type | Method and Description | 
|---|---|
| static ValueEval | OperandResolver. chooseSingleElementFromArea(AreaEval ae,
                           int srcCellRow,
                           int srcCellCol)Implements (some perhaps not well known) Excel functionality to select a single cell from an
 area depending on the coordinates of the calling cell. | 
| static ValueEval | OperandResolver. getElementFromArray(AreaEval ae,
                   EvaluationCell cell)Retrieves a single value from an area evaluation utilizing the 2D indices of the cell
 within its own area reference to index the value in the area evaluation. | 
Copyright 2021 The Apache Software Foundation or its licensors, as applicable.