Examples of Area3DEval

org.apache.poi.hssf.record.formula.eval.Area3DEval
@author Amol S. Deshmukh < amolweb at ya hoo dot com >

Examples of org.apache.poi.hssf.record.formula.eval.Area3DEval

                    for (short y = col0; row != null && y < col1 + 1; y++) {
                        values[(x - row0) * (col1 - col0 + 1) + (y - col0)] = 
                            getEvalForCell(row.getCell(y), row, xsheet, workbook);
                    }
                }
                AreaEval ae = new Area3DEval(a3dp, values);
                stack.push(ae);
            }
            else {
                Eval ptgEval = getEvalForPtg(ptgs[i]);
                stack.push(ptgEval);
            }
        }
        ValueEval value = ((ValueEval) stack.pop());
        if (value instanceof RefEval) {
            RefEval rv = (RefEval) value;
            value = rv.getInnerValueEval();
        }
        else if (value instanceof AreaEval) {
            AreaEval ae = (AreaEval) value;
            if (ae.isRow()) 
                value = ae.getValueAt(ae.getFirstRow(), srcColNum);
            else if (ae.isColumn()) 
                value = ae.getValueAt(srcRowNum, ae.getFirstColumn());
            else
                value = ErrorEval.VALUE_INVALID;
        }
        return value;
    }

View Full Code Here

Examples of org.apache.poi.hssf.record.formula.eval.Area3DEval

        if(row1 == -1 && row0 >= 0) {
            row1 = (short)xsheet.getLastRowNum();
        }
        
        ValueEval[] values = evalArea(workbook, xsheet, row0, col0, row1, col1);
        return new Area3DEval(a3dp, values);
    }

View Full Code Here

Examples of org.apache.poi.hssf.record.formula.eval.Area3DEval

        if(row1 == -1 && row0 >= 0) {
            row1 = (short)xsheet.getLastRowNum();
        }
        
        ValueEval[] values = evalArea(workbook, xsheet, row0, col0, row1, col1);
        return new Area3DEval(a3dp, values);
    }

View Full Code Here

Examples of org.apache.poi.hssf.record.formula.eval.Area3DEval

      _firstRowIndex = ae.getFirstRow();
      _firstColumnIndex = ae.getFirstColumn();
      _height = ae.getLastRow() - ae.getFirstRow() + 1;
      _width = ae.getLastColumn() - ae.getFirstColumn() + 1;
      if (ae instanceof Area3DEval) {
        Area3DEval a3e = (Area3DEval) ae;
        _externalSheetIndex = a3e.getExternSheetIndex();
      } else {
        _externalSheetIndex = INVALID_SHEET_INDEX;
      }
    }

View Full Code Here

Examples of org.apache.poi.hssf.record.formula.eval.Area3DEval

                    for (short y = col0; row != null && y < col1 + 1; y++) {
                        values[(x - row0) * (col1 - col0 + 1) + (y - col0)] = 
                            getEvalForCell(row.getCell(y), row, xsheet, workbook);
                    }
                }
                AreaEval ae = new Area3DEval(a3dp, values);
                stack.push(ae);
            }
            else {
                Eval ptgEval = getEvalForPtg(ptgs[i]);
                stack.push(ptgEval);
            }
        }
        ValueEval value = ((ValueEval) stack.pop());
        if (value instanceof RefEval) {
            RefEval rv = (RefEval) value;
            value = rv.getInnerValueEval();
        }
        else if (value instanceof AreaEval) {
            AreaEval ae = (AreaEval) value;
            if (ae.isRow()) 
                value = ae.getValueAt(ae.getFirstRow(), srcColNum);
            else if (ae.isColumn()) 
                value = ae.getValueAt(srcRowNum, ae.getFirstColumn());
            else
                value = ErrorEval.VALUE_INVALID;
        }
        return value;
    }

View Full Code Here

Examples of org.apache.poi.hssf.record.formula.eval.Area3DEval

        if(row1 == -1 && row0 >= 0) {
            row1 = (short)xsheet.getLastRowNum();
        }
        
        ValueEval[] values = evalArea(workbook, xsheet, row0, col0, row1, col1);
        return new Area3DEval(a3dp, values);
    }

View Full Code Here

Examples of org.apache.poi.hssf.record.formula.eval.Area3DEval

                    for (short y = col0; row != null && y < col1 + 1; y++) {
                        values[(x - row0) * (col1 - col0 + 1) + (y - col0)] = 
                            getEvalForCell(row.getCell(y), row, xsheet, workbook);
                    }
                }
                AreaEval ae = new Area3DEval(a3dp, values);
                stack.push(ae);
            }
            else {
                Eval ptgEval = getEvalForPtg(ptgs[i]);
                stack.push(ptgEval);
            }
        }
        ValueEval value = ((ValueEval) stack.pop());
        if (value instanceof RefEval) {
            RefEval rv = (RefEval) value;
            value = rv.getInnerValueEval();
        }
        else if (value instanceof AreaEval) {
            AreaEval ae = (AreaEval) value;
            if (ae.isRow()) 
                value = ae.getValueAt(ae.getFirstRow(), srcColNum);
            else if (ae.isColumn()) 
                value = ae.getValueAt(srcRowNum, ae.getFirstColumn());
            else
                value = ErrorEval.VALUE_INVALID;
        }
        return value;
    }

View Full Code Here

Examples of org.apache.poi.hssf.record.formula.eval.Area3DEval

      _firstRowIndex = ae.getFirstRow();
      _firstColumnIndex = ae.getFirstColumn();
      _height = ae.getLastRow() - ae.getFirstRow() + 1;
      _width = ae.getLastColumn() - ae.getFirstColumn() + 1;
      if (ae instanceof Area3DEval) {
        Area3DEval a3e = (Area3DEval) ae;
        _externalSheetIndex = a3e.getExternSheetIndex();
      } else {
        _externalSheetIndex = INVALID_SHEET_INDEX;
      }
    }

View Full Code Here

Examples of org.apache.poi.hssf.record.formula.eval.Area3DEval

        if(row1 == -1 && row0 >= 0) {
            row1 = (short)xsheet.getLastRowNum();
        }
        
        ValueEval[] values = evalArea(workbook, xsheet, row0, col0, row1, col1);
        return new Area3DEval(a3dp, values);
    }

View Full Code Here

Examples of org.apache.poi.hssf.record.formula.eval.Area3DEval

                    for (short y = col0; row != null && y < col1 + 1; y++) {
                        values[(x - row0) * (col1 - col0 + 1) + (y - col0)] = 
                            getEvalForCell(row.getCell(y), row, sheet, workbook);
                    }
                }
                AreaEval ae = new Area3DEval(a3dp, values);
                stack.push(ae);
            }
            else {
                Eval ptgEval = getEvalForPtg(ptgs[i]);
                stack.push(ptgEval);
            }
        }
        ValueEval value = ((ValueEval) stack.pop());
        if (value instanceof RefEval) {
            RefEval rv = (RefEval) value;
            value = rv.getInnerValueEval();
        }
        else if (value instanceof AreaEval) {
            AreaEval ae = (AreaEval) value;
            if (ae.isRow()) 
                value = ae.getValueAt(ae.getFirstRow(), srcColNum);
            else if (ae.isColumn()) 
                value = ae.getValueAt(srcRowNum, ae.getFirstColumn());
            else
                value = ErrorEval.VALUE_INVALID;
        }
        return value;
    }

View Full Code Here

0 1

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.