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]
