https://bugs.documentfoundation.org/show_bug.cgi?id=114929
--- Comment #1 from Karel Hruska <[email protected]> ---
(In reply to Regina Henschel from comment #0)
> 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.
Hi Regina,
thank you for setting this request. I've tested the same on MS Office 2016 and
the result is identical - MS says, that -3^2 = 9, no bracket handling is
implemented. Google spreadsheet does the same.
Karel
--
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
