formula float point problem

[何鹏飞 <he...@163.com>]

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




 

Re: formula float point problem

["pj.fanning" <fa...@yahoo.com>]

You can use
https://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/DataFormatter.html



--
Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

Re: formula float point problem

["pj.fanning" <fa...@yahoo.com>]

You could also use Java DecimalFormat class to format Doubles are Strings
with the decimal precision set. See
https://www.mkyong.com/java/java-display-double-in-2-decimal-points/ 



--
Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

Re: formula float point problem

["pj.fanning" <fa...@yahoo.com>]

This is what the DataFormatter class is for - could you try it?



--
Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org