https://bugs.documentfoundation.org/show_bug.cgi?id=167992
Bug ID: 167992
Summary: help for infix operator "^" lacks info about a
negative base and fractional exponents
Product: LibreOffice
Version: 26.2.0.0 alpha0+ master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Documentation
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
ODF specifies that the expression a^b has to be calculated as POWER(a;b), see
6.4.6 Infix Operator "^", part 4 ODF 1.4.
https://docs.oasis-open.org/office/OpenDocument/v1.4/cs01/part4-formula/OpenDocument-v1.4-cs01-part4-formula.html#Infix_Operator_POW
This information is missing in the help.
In LibreOffice, both the infix-operator "^" and the POWER function use the
implementation ScInterpreter::ScPow() in /sc/source/core/tool/interpr5.cxx
Negative base and fractional exponents are allowed, but the behavior for a
negative base is implementation-defined. The help for POWER has the needed
info, though not really exact, but the user learns that he has to be careful.
For the infix operator "^", info about a negative base is missing.
So perhaps add to the infix operator a sentence:
The expression a^b is calculated the same way as POWER(a,b).
Or write a similar info about negative base and fractional exponents for the
infix operator "^".
https://help.libreoffice.org/26.2/en-US/text/scalc/01/04060106.html#hd_id3155717
https://help.libreoffice.org/26.2/en-US/text/scalc/01/04060199.html
To see the problems for users look at bug 148488.
--
You are receiving this mail because:
You are the assignee for the bug.
