https://bugs.documentfoundation.org/show_bug.cgi?id=148488
--- Comment #16 from Michal Svoboda <[email protected]> --- The issue still partly persists, but the interpretation of fractional powers of negative numbers is more of a question of interpretation. Google Sheets consistently flags formulae like (-5)^(1/x), where x is an integer, as an error, even when real roots exist. Excel (and Calc) reports real roots when x = 5; otherwise, it reports an error. Calc also reports real roots when x is an ODD number. This is, of course, inconsistent with complex mathematics, but again, the problem is that Spreadsheets cannot perform complex mathematics (more than one result of a formula) in principle. The ways to flag this are open to interpretation. For me, you can close the issue. -- You are receiving this mail because: You are the assignee for the bug.
