[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

--- Comment #5 from matthewnote at yahoo.co.uk ---
(In reply to Eike Rathke from comment #3)
>"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..
> 

I'm a fan of your "yeoldestuff"; thankyou for the precise paragraph as the spec
puts examples of == , but not in 5.2.  Much appreciated.  Added to the work
list here is to create a test file to attempt to test the == implementation.  I
may even start using it (later).  

In any case, I'll write a new bug report with a more open suggestion of
expected result (if OpenCL has limitations with == or if OpenCL is revealing
something else or if Undo:delete is difficult to support in some
circumstances). Just "Chart is expected to plot the Data Range".  

After a Reset User Profile and close re-open Calc (still without changing nor
saving the sample file) there's more chart/range discrepancy and different,
including whole column with wrong result for A=B.  Reproduceable OpenCL on/off
also. The sample file is someone else's yet useful to sort (separate) and
investigate why.  I'll write that step by step in a new (not NEW) report.

For VLB @VLB.  I still see the problem;  there is a bug, just not that function
==.  Bug report closed because my suggestion Err:502 is in error.  I
understand.

I'll be using -- as a trigger for diagnosis (I'm looking for more operators
too;  all welcome).  I only found one instance in your file, in one cell
without dependents.  If our projects have more == I conclude to have to work it
out (deliberate, keyboard bounce, redundant, still wanted for something else or
any other reason?) because it does trigger the bug, does alter the charts (the
Step by Step is valid).  Reading the link in comment 2, Calc can even
automatically put == back in (for valid reasons) while we edit.

-- 
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/20210530/e12ea5cd/attachment.htm>