https://bugs.documentfoundation.org/show_bug.cgi?id=114929
Bug ID: 114929
Summary: Make =-3^2 unambiguous by automatically adding
brackets
Product: LibreOffice
Version: 6.1.0.0.alpha0+ Master
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
The formula =-3^2 can be interpreted as =(-3)^2 as in ODF or OOXML standard or
as =0-(3^2) as in common school mathematic and in Writer. This leads to
problems for the user. See e.g. bug 37271 and its duplicates.
Gnumeric resolves this ambiguity by automatically inserting brackets. So the
formula =-3^2 is automatically turned to =(-3)^2 and written to file as such.
An alternative approach is to turn =-3^2 to =0-3^2, which makes the minus to a
binary operator.
I don't know yet, whether MS Office 365 has solved this usability problem.
I suggest to do it the same way as Gnumeric. Inserting brackets gives the same
result as current.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
