[Libreoffice-bugs] [Bug 142556] FILEOPEN, EDITING, Cell with syntax ==IF() displays a result, no error, corrupts calculations and user profile

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=142556

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |NOTABUG

--- Comment #3 from Eike Rathke <erack at redhat.com> ---
Not a bug.

In spreadsheet syntax there is no == boolean equality operator, the equality
operator is one = with two operands. Starting a formula expression with two ==
equal signs instead of one = means that formula will be interpreted on every
change of the spreadsheet, not just if a predecessor it depends on changes.
Meant for side effects of macro functions that otherwise have no indication
whether they are volatile or not.

See also OpenDocument Format OpenFormula specification 5.2 Basic Expressions
https://docs.oasis-open.org/office/OpenDocument/v1.3/cs02/part4-formula/OpenDocument-v1.3-cs02-part4-formula.html#__RefHeading__1017934_715980110

Note the explanatory text for "forced recalculation" is wrong, instead of
"should be recalculated whenever one of its predecessors it depends on changes"
(which of course is the normal behaviour) it should be "should be recalculated
whenever recalculation occurs, not only when one of its predecessors it depends
on changes".

And no, I highly doubt that would corrupt a user profile by any means..

Btw, please don't confirm your own bugs by setting them to NEW, leave them at
UNCONFIRMED so they can be triaged.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210529/ee499d2d/attachment.htm>