Hi all,
   I use this code 
     CellValue cellValue = formulaEvaluator.evaluate(cell);
     cellValue.getNumberValue();
  to evaluate formula in xls.   (POI version is 3.9)
  and display value is 21.1, but parsed value is 21.099999999999998.
  Can I get the same value with the display one ?  (I know POI get the 'cached' 
value in xml, but excel display the different value based on the xml)
  Also I want to scale 2 point . but the value will add two o. For example:  3  
-> 3.00


please give me some advice. 


Best regards,
marvin




 

Reply via email to