<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - FILEOPEN, EDITING, Chart or Range fails to update using Undo:delete for OpenCL when a cell with operator == is present"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=142891#c2">Comment # 2</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - FILEOPEN, EDITING, Chart or Range fails to update using Undo:delete for OpenCL when a cell with operator == is present"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=142891">bug 142891</a>
from <span class="vcard"><a class="email" href="mailto:matthewnote@yahoo.co.uk" title="matthewnote@yahoo.co.uk">matthewnote@yahoo.co.uk</a>
</span></b>
<pre>The attachment is a simplification of the file used to progress <a class="bz_bug_link
bz_status_VERIFIED bz_closed"
title="VERIFIED FIXED - EDITING, FORMATTING: diagram didn't automatic update when change variable (steps in comment 28)"
href="show_bug.cgi?id=86321">Bug 86321</a>. To
remove the traces and notification of a macro, the menu method did not
eliminate. The flatods method did not succeed either. An event-listener line
was found (manually) in the xml; once removed that, then the macro warnings
stopped. In any case the step by step was learnt before removing the warnings
(macro disabled).
The file was/is full of ROUND and formatting about that with mixed display of
values after formulae. Noted (may be subject to <a class="bz_bug_link
bz_status_NEW "
title="NEW - calc: storing of rounded values and recalculation on load harming display after reload | was: calc: save-load-cycle: some cells shown with wrong value until recalc (F9)"
href="show_bug.cgi?id=140722">Bug 140722</a> as well as this
one)
The cell in the original file with operator == has no dependent, appears to be
a keyboard key bounce when generating the file (most probably a typing error)
and that the forced calculation is unintentional. The test file of <a class="bz_bug_link
bz_status_VERIFIED bz_closed"
title="VERIFIED FIXED - EDITING, FORMATTING: diagram didn't automatic update when change variable (steps in comment 28)"
href="show_bug.cgi?id=86321">Bug 86321</a>
shows the same symptoms as here step by step. It has many sheets and charts
with several million cells and over one hundred named expressions. The only
cell with something unusual == was found by eye, looking at every single cell
(took about ten days to find). The sample here is stripped down to only two
lines and all precedents on one sheet.
I'd prefer to do a clean sheet report soon (when I can), however I also keep an
eye on backwards compatibility issues that might severely affect User projects.
I understand the Bug report has a lot of steps; but it's all there, chart
updates, OpenCL, == trigger/block, autocalculate, sporadic fail and it's
reproduceable (which I hope helps!).
My User Profiles available on request for any step or all steps. I've
installed Virtual Studio and can offer debug also (please specify which steps
to record).</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>