[Bug 62121] Calculating the power of a negative number with a fracture fails (for example -2^(1/3))

[bu...@apache.org]

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

--- Comment #1 from Javen O'Neal <on...@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-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org