FileDocCategorySizeDatePackage
Column.javaAPI DocApache Poi 3.0.12318Sun Mar 11 12:59:30 GMT 2007org.apache.poi.hssf.record.formula.functions

Column

public class Column extends Object implements Function
author

Fields Summary
Constructors Summary
Methods Summary
public org.apache.poi.hssf.record.formula.eval.Evalevaluate(org.apache.poi.hssf.record.formula.eval.Eval[] evals, int srcCellRow, short srcCellCol)

        ValueEval retval = null;
        int cnum = -1;
        
        switch (evals.length) {
        default:
            retval = ErrorEval.VALUE_INVALID;
        case 1:
            if (evals[0] instanceof AreaEval) {
                AreaEval ae = (AreaEval) evals[0];
                cnum = ae.getFirstColumn();
            }
            else if (evals[0] instanceof RefEval) {
                RefEval re = (RefEval) evals[0];
                cnum = re.getColumn();
            }
            else { // anything else is not valid argument
                retval = ErrorEval.VALUE_INVALID;
            }
            break;
        case 0:
            cnum = srcCellCol;
        }
        
        if (retval == null) {
            retval = (cnum >= 0)
                    ? new NumberEval(cnum + 1) // +1 since excel colnums are 1 based
                    : (ValueEval) ErrorEval.VALUE_INVALID;
        }
        
        return retval;