Which version of POI/HSSF are you using? 1.5? Its totally not
supported in 1.5. There is some early support for it in 2.0, but no
string formulas as of yet. I'm not sure the value is exposed yet
through the high level model. You could capture it in the event-based
api. Next, we have no formula evaluator yet. (Look for this probably
in 3.0)
Does that answer your question?
-Andy
[EMAIL PROTECTED] wrote:
>I'm trying to do this to read a Numeric, String or Formula value but it
>only shows me the Numeric and String ones. What can I do to read the result
>value of a Formula?:
>
> HSSFRow row=hoja.getRow(fila.celdas[i].getFila());
>
> HSSFCell cell=row.getCell((short)fila.celdas[i].getColumna());
>
> if (cell==null) System.out.println("NULL value");
> else{
>
> // Checking the type
>
> int typecell=cell.getCellType();
>
> if (typecell==0){
> System.out.println("Numeric Value: "+cell.getNumericCellValue());
> } else if (typecell==1){
> System.out.println("String Value: "+cell.getStringCellValue());
> } else if (typecell==2){
> System.out.println("Formula: ");
> }
>
>I've seen FormularRecord is not supported.
>How can I do it?
>
>Thanks for your help,
>
> Rodolfo
>
>
>
>
>
>
>--
>To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
>For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
>
>
>
>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
