https://bugs.documentfoundation.org/show_bug.cgi?id=148488
--- Comment #7 from Regina Henschel <[email protected]> --- Excel gives -1.37972966146122 as result of =(-5)^0.2. LibreOffice does the same. ODF defines operator ^ with the POWER function. Both Excel and LibreOffice behaves that way. We should keep the current behavior. ODF 1.3 has specified POWER(A,B), where A ≤ 0 and INT(B) != B, is implementation-defined. So our current behavior is valid against ODF. An "implementation-defined" behavior means, that the application must document the behavior. Our page for this is https://wiki.documentfoundation.org/Development/ODF_Implementer_Notes/List_of_LibreOffice_ODF_implementation-defined_items. In section "Functions" it refers to the Help, for LO 7.3 https://help.libreoffice.org/7.3/en-US/text/scalc/01/04060106.html?DbPAR=CALC and https://help.libreoffice.org/7.3/en-US/text/scalc/01/04060199.html?DbPAR=CALC But there the description of this behavior is missing for the POWER function and the ^ operator as well. So this is actually a documentation bug. -- You are receiving this mail because: You are the assignee for the bug.
