Re: Stop formula manipulation in POI 3.7 with Excel

2010-12-07 Thread Aniket Banerjee
Thanks!!! On Wed, Dec 8, 2010 at 5:59 AM, Nick Burch wrote: > On Tue, 7 Dec 2010, Aniket Banerjee wrote: > >> Thanks Nick for the reply. Is POI planning to implement functions like >> CLEAN and ADDRESS etc in future release, as I have found there many such >> functions that are "Not Implemented

Re: NullPointerException in org.apache.poi.xssf.usermodel.XSSFRichTextString.getLengthOfFormattingRun

2010-12-07 Thread sanjeev.x.verma
Hey Nick, thanks for the quick reply. After a few hit and trials, I am able to get rid of the NPE by making the following change to "XSSFRichTextString.java". /** * Returns the number of characters this format run covers. * * @param index the index of the formatting run

Re: Updating an embedded Excel file inside Word

2010-12-07 Thread Nick Burch
On Tue, 7 Dec 2010, Aram Mirzadeh wrote: On 12/7/2010 12:47 AM, Nick Burch wrote: On Sun, 5 Dec 2010, Aram Mirzadeh wrote: I'm trying to update the values for the excel chart. I can read the docx, get the embeded object, and read and modify the cells that I need. My question is how do you sa

Re: Stop formula manipulation in POI 3.7 with Excel

2010-12-07 Thread Nick Burch
On Tue, 7 Dec 2010, Aniket Banerjee wrote: Thanks Nick for the reply. Is POI planning to implement functions like CLEAN and ADDRESS etc in future release, as I have found there many such functions that are "Not Implemented Yet". POI is an open source project driven by volunteer contributions.

Re: NullPointerException in org.apache.poi.xssf.usermodel.XSSFRichTextString.getLengthOfFormattingRun

2010-12-07 Thread Nick Burch
On Tue, 7 Dec 2010, sanjeev.x.verma wrote: While executing the autoSizeColumn method of the XSSFSheet in my code (using POI-3.7), I am getting a NPE. The stack trace is as below: java.lang.NullPointerException at org.apache.poi.xssf.usermodel.XSSFRichTextString.getLengthOfFormattingRun(X

NullPointerException in org.apache.poi.xssf.usermodel.XSSFRichTextString.getLengthOfFormattingRun

2010-12-07 Thread sanjeev.x.verma
Gurus: While executing the autoSizeColumn method of the XSSFSheet in my code (using POI-3.7), I am getting a NPE. The stack trace is as below: java.lang.NullPointerException at org.apache.poi.xssf.usermodel.XSSFRichTextString.getLengthOfFormattingRun(XSSFRichTextString.java:334)

Re: Updating an embedded Excel file inside Word

2010-12-07 Thread Aram Mirzadeh
On 12/7/2010 12:47 AM, Nick Burch wrote: On Sun, 5 Dec 2010, Aram Mirzadeh wrote: I'm trying to update the values for the excel chart. I can read the docx, get the embeded object, and read and modify the cells that I need. My question is how do you save the embedded excel file? You'll get

Re: NPV bug?

2010-12-07 Thread Jon Svede
Some additional information: If I enumerate the values in the area in the formula, the evaluation works (=NPV(B5,B1,B2,B3,B4) ). However the result doesn't match what Excel has. Thanks, Jon - Original Message From: Jon Svede To: POI Users List Sent: Tue, December 7, 2010 9:44:40

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

Re: Using FinanceLib

2010-12-07 Thread Jon Svede
Is this function, the FinanceLib.npv() method, the one used internally by POI when a cell in a spreadsheet specifies the NPV function? Thanks, Jon - Original Message From: Edward Ivanovic To: POI Users List Sent: Mon, December 6, 2010 4:24:58 PM Subject: Re: Using FinanceLib Tha

Re: Stop formula manipulation in POI 3.7 with Excel

2010-12-07 Thread Aniket Banerjee
Thanks Nick for the reply. Is POI planning to implement functions like CLEAN and ADDRESS etc in future release, as I have found there many such functions that are "Not Implemented Yet". On Tue, Dec 7, 2010 at 1:14 PM, Nick Burch wrote: > On Tue, 7 Dec 2010, Aniket Banerjee wrote: > >> Can you te