Keep this in mind: >From http://poi.apache.org/spreadsheet/eval.html: "*Using** FormulaEvaluator.evaluate**(Cell cell)*
This evaluates a given cell, and returns the new value, without affecting the cell" On 5 Nov 2015 3:41 p.m., "Jason Tomforde" <[email protected]> wrote: > If you are referring to this ... > CellValue cellValue = evaluator.evaluate(cell); > > Then yes. > > Most likely not the latest version.... I will give that a shot. > > Thank you, > Jason. > > > Date: Thu, 5 Nov 2015 23:36:20 +0000 > > From: [email protected] > > To: [email protected] > > Subject: Re: Formula not working as expected > > > > On Thu, 5 Nov 2015, Jason Tomforde wrote: > > > A1 string cell = 1 > > > A2 numeric cell = 2 > > > A3 numeric cell = 3 > > > A4 formula cell = IF(A1=1,A2,A3) > > > > > > The result I am getting is 0. > > > > > > Any thoughts? > > > > Are you evaluating the formula when you're doing with settings cells? > > http://poi.apache.org/spreadsheet/eval.html > > > > Are you using a new enough version of Apache POI? > > http://poi.apache.org/download.html > > > > Nick > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [email protected] > > For additional commands, e-mail: [email protected] > > >
