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
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
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
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.
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
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)
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
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
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
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
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
11 matches
Mail list logo