How can I read a Formula Cell value

[martin_r]

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]>