https://bz.apache.org/bugzilla/show_bug.cgi?id=62121
--- Comment #4 from Mark Murphy <jmarkmur...@apache.org> --- (In reply to Javen O'Neal from comment #1) > 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. Excel 2016 gives #NUM! for -2^.5. In fact except for the fractions representing odd roots, (1/3, 1/5, 1/7, ...) all other fractions return #NUM! when the base is negative. -- 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
