Who's syntax check? Here's an interesting case where
=6/2(1+2)
is a syntax error:
LibreOffice Calc found an error in the formula entered.
Do you want to accept the correction proposed below?
=6/2*(1+2)
Accepting the proposal yields 9. But it refused to assume that was the intended meaning.
This is a great choice because otherwise you would have to have a setting as to
which convention would be used to resolve the ambiguity of whether the 2( was distributed or
just multiplied. It is perhaps interesting to note that did not offer=6/(2*(1+2)) instead
suggesting simply multiply might be the usual meaning.
Who's syntax check? Here's an interesting case where
=6/2(1+2)
is a syntax error:
LibreOffice Calc found an error in the formula entered.
Do you want to accept the correction proposed below?
=6/2*(1+2)
Accepting the proposal yields 9. But it refused to assume that was the intended meaning.
This is a great choice because otherwise you would have to have a setting as to
which convention would be used to resolve the ambiguity of whether the 2( was distributed or
just multiplied. It is perhaps interesting to note that did not offer=6/(2*(1+2)) instead
suggesting simply multiply might be the usual meaning.