You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@poi.apache.org by bu...@apache.org on 2022/12/14 08:58:29 UTC

[Bug 66389] POI formula eval result is not same with excel when do an arithmetic operation

https://bz.apache.org/bugzilla/show_bug.cgi?id=66389

PJ Fanning <fa...@yahoo.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 OS|                            |All

--- Comment #1 from PJ Fanning <fa...@yahoo.com> ---
I'm not convinced. I only have access to the web version of Excel and this
evaluates that formula as 2.859426516.

Using Java to try to reverse engineer Excel's internal maths is a major pain in
the neck.

We'll never make everyone happy and what we are arguing about here is a minor
rounding issue.

You can just get Excel to recalculate all the formulas when it loads any
xls/xlsx files you create with POI and not worry about POI's calculations.

Workbook#setForceFormulaRecalculation(boolean)

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org