[Libreoffice-bugs] [Bug 142891] FILEOPEN, EDITING, Chart or Range fails to update using Undo:delete for OpenCL when a cell with operator == is present

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Wed Jun 16 09:22:57 UTC 2021


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

--- Comment #2 from matthewnote at yahoo.co.uk ---
The attachment is a simplification of the file used to progress Bug 86321.  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 Bug 140722 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 Bug 86321
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).

-- 
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/20210616/7c291e3d/attachment.htm>


More information about the Libreoffice-bugs mailing list