Hi Yegor A similar example to my formula would be C1 = AND(C2="YES",C2="NO",C3="WARNING",)
That is if there is a missing operand in the AND. I have an extra comma at the end. I removed this from the formula and now the evaluator works fine. This is the same problem Dmitri saw in the link i posted below. Apparently Excel 2007 supports this feature of missing operands. Thanks Vidhya On Wed, Nov 30, 2011 at 3:05 AM, Yegor Kozlov <[email protected]> wrote: > Can you reproduce the problem with a new worksheet ? Create a new > workbook in Excel, manually enter the problematic formula and try to > evaluate it with POI. Does it work ? > > I'm not asking you to upload the workbook, I need only the formula > string. Can you post it ? If not, can you obfuscate the formula > (change worksheet names, etc.) ? > Without the formula we can't do much to help you. > > Yegor > > On Tue, Nov 29, 2011 at 9:01 PM, vidhya murthy > <[email protected]> wrote: > > Hi Yegor > > I cannot at present post this formula on public domain.Can you suggest > some > > way I can narrow down the problem? > > Thanks > > Vidhya > > > > > > On Fri, Nov 25, 2011 at 5:54 AM, Yegor Kozlov <[email protected]> > wrote: > > > >> Please post the formula so that we can verify the problem. > >> > >> Yegor > >> > >> On Thu, Nov 24, 2011 at 10:40 PM, vidhya murthy > >> <[email protected]> wrote: > >> > Hi > >> > I am using the POI XSSF component. I have some complicated formulas > in my > >> > excel 2007 xlsx files. When I evaluate a IF condition I get the > following > >> > exception. Has anyone seen this before and could you explain what > needs > >> to > >> > be done? > >> > > >> > java.lang.RuntimeException: Unexpected eval > >> > (org.apache.poi.ss.formula.eval.MissingArgEval) > >> > > >> > I saw a similar post by another user but haven't seen any replies. > >> > http://osdir.com/ml/user-poi.apache.org/2010-03/msg00029.html > >> > Thanks > >> > Vidhya > >> > > >> > >> --------------------------------------------------------------------- > >> To unsubscribe, e-mail: [email protected] > >> For additional commands, e-mail: [email protected] > >> > >> > > > > > > -- > > Think before you print. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > -- Think before you print.
