https://bugs.documentfoundation.org/show_bug.cgi?id=148488
--- Comment #9 from Michal Svoboda <[email protected]> --- - one of the five fifth roots of a negative number (-5) is real (-1^0.2 gives also a real root -1), but not giving all five roots or otherwise notifying the user that there are five fifth roots is an obvious error from the point of view of mathematics. Spreadsheets should do correct maths. - likewise, one of the 7th roots of a negative number is real, and one of the 3rd roots... however, these are reported with #NUM! - it seems that the number 0.2 (1/5) is somehow special in this case (the same holds for 2/10, 4/20) - the exponent of 0.4 (2/5) gives an error message #NUM!, while it evaluates always to a positive real number in maths =(-5)^(2/5), i.e. (-5)^2*(1/5). It seems someone tried to implement fractional powers of negative numbers for some the special cases and the result was at best incomplete... -- You are receiving this mail because: You are the assignee for the bug.
