Dear experts,
I am using POI EventModel to read Excel file. All things works fiine but I
could not get the value with formula cell.
Is there any advice?
Thanks.
You'll get a FormulaRecordAggregate. From here, you can get the parsed (RPN)
formula notation. However, since formula's contain references to other parts
of the file, you'll need a reference to a workbook to get a string
representation. The method is FormulaParser#toFormulaString(Workbook,
20070116) as well as previous versions of alpha3, along with the patch files
which were distributed through this list. None of this has worked, I just keep
getting the same error. Has anyone else had this problem?
Thanks
Paul
Okay
After further investigation I needed to alter the classpath so that my app was
finding the correct class files first.
As you were!
Paul
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List:
hello, i would like you to help me with an issue, i am reading an xls file
and trying to go across it. as soon as the rows do not have anymore data,
there is a zone of cells that i need manually to select them (editing the
xls file in MS Excel), and hide them in spanish (ocultar) in order to my
On Tue, 16 Jan 2007, qwerty_giggi wrote:
But the color line is wrong...the only colors that matching are:
red,blue... the others are only black...the RGB's jakarta is the
same of the RGB's Java?I need of a transformation
For font colours, powerpoint stores then as BGR, not RGB. We
for the text I have used :
color = new Color(propr[i].getFontColor());
if (propr[i].getFontColor()!=-1) colorPP = new Color(color.getBlue(),
color.getGreen(), color.getRed(),255);
else colorPP=Color.black;
i have catched the NullPointerException and all set
2007/1/16, Hugo Osorio [EMAIL PROTECTED]:
hello, i would like you to help me with an issue, i am reading an xls file
and trying to go across it. as soon as the rows do not have anymore data,
there is a zone of cells that i need manually to