Bug 114930 - Add information about associativity and precedence of operators to the help
Summary: Add information about associativity and precedence of operators to the help
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
Version:
(earliest affected)
6.1.0.0.alpha0+
Hardware: x86-64 (AMD64) Windows (All)
: medium enhancement
Assignee: Olivier Hallot
URL:
Whiteboard: target:7.3.0
Keywords:
Depends on:
Blocks: HelpGaps-NewFeatures
  Show dependency tree / graph
 
Reported: 2018-01-09 14:05 UTC by Regina Henschel
Modified: 2021-08-24 17:00 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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