https://bugs.documentfoundation.org/show_bug.cgi?id=148488
--- Comment #11 from Michal Svoboda <[email protected]> --- There are more aspects: - giving anything else than a single real number in LO Calc is next to impossible - there are some complex arithmetics functions included within the LO list of functions, anyway, this implementation is somewhat awkward (from my point of view)and, in the case of the fifth root there should be a matrix of five results - all fractions with an odd denominator should be equal, but some of them are more equal than others (1/5, 2/10, 4/20) I'd suggest implementing (if that is possible) - more detailed error message for all instances where any root of a negative number is calculated. This would solve the problem on a short time scope (while keeping compatibility with the same bug in Excel) - returning a real root, where one exists (i.e. also for exponents like 1/3, 1/7, etc.), and notifying the user there are other (complex) roots, too - you're in the complex number domain now boy, could add to clarity and consistency of the arithmetics inside the sheet - or marking all calculations potentially resulting in complex numbers as #ERR! with a comment - you're trying something that is outside the sheet range of real numbers, boy -- You are receiving this mail because: You are the assignee for the bug.
