Bug 114930

Summary:	Add information about associativity and precedence of operators to the help
Product:	LibreOffice	Reporter:	Regina Henschel <rb.henschel>
Component:	Documentation	Assignee:	Olivier Hallot <olivier.hallot>
Status:	RESOLVED FIXED
Severity:	enhancement	CC:	jalojo, olivier.hallot, pushkin
Priority:	medium
Version:	6.1.0.0.alpha0+
Hardware:	x86-64 (AMD64)
OS:	Windows (All)
Whiteboard:	target:7.3.0
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	80430

Description Regina Henschel 2018-01-09 14:05:19 UTC

The help has no information about associativity and precedence of operators. This leads to confusion. Example: The formula =-3^2 in Calc 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.

Request: Add a section about associativity and precedence of operators as they are defined in the standard for Calc formulas. And add a section with examples how to write formulas, to get the behavior known from common school mathematics. And add a section with examples to show the different syntax in Writer.

Comment 1 Jacques Guilleron 2018-01-11 14:51:07 UTC

Hi Regina,

I approve.

Comment 2 Commit Notification 2021-06-17 12:19:22 UTC

Olivier Hallot committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/help/commit/21d0197b3705212a22b9e221ac1f624049516d9a

tdf#114930 Clarify associativity and precedence of operators to the help