Class IfFunc

  • All Implemented Interfaces:
    Function, Function2Arg, Function3Arg

    public final class IfFunc
    extends java.lang.Object
    Implementation for the Excel function IF

    Note that Excel is a bit picky about the arguments to this function, when serialised into Ptgs in a HSSF file. While most cases are pretty chilled about the R vs V state of RefPtg arguments, for IF special care is needed to avoid Excel showing #VALUE. See bug numbers #55324 and #55747 for the full details on this. TODO Fix this...