Re: NPV bug?

2010-12-13 Thread Jon Svede
I can confirm this fixed my issue. Thanks, Marcel! Jon - Original Message From: Yegor Kozlov To: user@poi.apache.org Sent: Fri, December 10, 2010 8:04:08 AM Subject: Re: NPV bug? The patch was applied in r1044370. Please try the latest build from trunk. Daily builds can be

Re: NPV bug?

2010-12-10 Thread Yegor Kozlov
ssage From: Jon Svede To: POI Users List Sent: Wed, December 8, 2010 9:10:40 PM Subject: Re: NPV bug? Hi all, Sorry for the delay in responding. I can create the ticket and the test case, I'll try to get to this by the end of the week. Thanks for the confirmation! Jon

Re: NPV bug?

2010-12-08 Thread Marcel May
ork from that > and > submit his test case or I can create one. > > > Jon > > > > > - Original Message > From: Jon Svede > To: POI Users List > Sent: Wed, December 8, 2010 9:10:40 PM > Subject: Re: NPV bug? > > Hi all, > > S

Re: NPV bug?

2010-12-08 Thread Jon Svede
I created issue #50437 and attached my .xls file. Marcel can work from that and submit his test case or I can create one. Jon - Original Message From: Jon Svede To: POI Users List Sent: Wed, December 8, 2010 9:10:40 PM Subject: Re: NPV bug? Hi all, Sorry for the delay in

Re: NPV bug?

2010-12-08 Thread Jon Svede
I just re-read this, so yes, I will create a bug and upload my test file. Marcel can then attach the patch/test case as needed. Thanks! Jon - Original Message From: Marcel May To: POI Users List Sent: Wed, December 8, 2010 3:33:54 PM Subject: Re: NPV bug? I can confirm this is

Re: NPV bug?

2010-12-08 Thread Jon Svede
t: Re: NPV bug? Hi Marcel, Please have a look at http://poi.apache.org/guidelines.html in the "Submitting Patches" section. Thanks and Regards, Dave On Dec 8, 2010, at 2:46 PM, Marcel May wrote: > > > Oops, the patch got swallowed. > > On Dec 9, 2010, at 2:33 AM,

Re: NPV bug?

2010-12-08 Thread David Fisher
Hi Marcel, Please have a look at http://poi.apache.org/guidelines.html in the "Submitting Patches" section. Thanks and Regards, Dave On Dec 8, 2010, at 2:46 PM, Marcel May wrote: > > > Oops, the patch got swallowed. > > On Dec 9, 2010, at 2:33 AM, Marcel May wrote: > >> I can confirm this

Re: NPV bug?

2010-12-08 Thread Marcel May
Index: src/java/org/apache/poi/ss/formula/functions/Npv.java === --- src/java/org/apache/poi/ss/formula/functions/Npv.java (revision 1043675) +++ src/java/org/apache/poi/ss/formula/functions/Npv.java (working copy) @@ -17,

Re: NPV bug?

2010-12-08 Thread Marcel May
rs List > Sent: Tue, December 7, 2010 9:44:40 AM > Subject: NPV bug? > > I've attached a simple example of my issue but here is the description. > > I have a spreadsheet with values (not formulas) in B1:B4. In B5 there is the > value 0.10. > > > In B6 I have this

Re: NPV bug?

2010-12-08 Thread Yegor Kozlov
Sounds like a bug. Can you create a new bug in bugzilla, and upload the file and a sample code that shows the problem? Ideally it would be a junit test case. Yegor On 12/7/2010 7:44 PM, Jon Svede wrote: I've attached a simple example of my issue but here is the description. I have a spreads

Re: NPV bug?

2010-12-07 Thread Jon Svede
44:40 AM Subject: NPV bug? I've attached a simple example of my issue but here is the description. I have a spreadsheet with values (not formulas) in B1:B4. In B5 there is the value 0.10. In B6 I have this formula: =NPV(B5,B1:B4) This seems to work fine in Excel. When I try to evalua

NPV bug?

2010-12-07 Thread Jon Svede
I've attached a simple example of my issue but here is the description. I have a spreadsheet with values (not formulas) in B1:B4. In B5 there is the value 0.10. In B6 I have this formula: =NPV(B5,B1:B4) This seems to work fine in Excel. When I try to evaluate this B6 cell, I get the error