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

--- Comment #1 from Javen O'Neal <one...@apache.org> ---
Hmm.. -2^0.5 could be interpreted as either -1*(2^0.5)≈0.707 or
(-2)^0.5≈0+0.707i, with the latter being the commonly accepted interpretation
in mathematics. Looks like if Excel interprets this as the former, that's a
quirk in their implementation that we unfortunately have to mimick if we want
to be compatible.

For what it's worth, Google Sheets gives an imaginary number error.

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

Reply via email to