[Libreoffice-bugs] [Bug 140604] New: Some DDE Fields won't load - Multiple empty fields on large/frequently updated dde links.

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 140604
           Summary: Some DDE Fields won't load - Multiple empty fields on
                    large/frequently updated dde links.
           Product: LibreOffice
           Version: 5.3 all versions
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: pedroh.u at hotmail.com

Created attachment 169969
  --> https://bugs.documentfoundation.org/attachment.cgi?id=169969&action=edit
Screenshots of the DDE links behavior in different LibreOffice Versions.

Given a Calc Sheet with multiple DDE cells frequently updated, some cells will
be loaded into the sheet without any data (Field left blank) and without
presenting any errors neither on the Calc nor on the DDE Server.

For this instance, there were approximately 330 DDE cells where roughly 20% of
them were updated through an XTYP_ADV_REQ with intervals < 1 second while the
remaining cells were updated in random intervals ranging from 1 second to
minutes.

In the link manager, the status of the empty cells are marked as Waiting and
are perpetually on this state. Upon manually requesting an update for those
links which are stagnated on the waiting status while the other ones are live,
the requested cell may be updated and have his status changed to automatic or
remain manual with no data.

Furthermore, given enough time, most the cells are going to be filled. Probably
due to new XTYP_ADVISE messages from the server telling LibreOffice to update a
given cell and, as a consequence, it will have the same behavior as a manual
update request where it has a chance to update or not based on luck.

Additionally, given a reduced set of DDE cells or less frequently updated ones,
LibreOffice Calc, regardless of the version, will behave properly.

Given the ever changing nature of the behavior (different cells being ignored /
left blank) at each run, it makes me believe that this might be a concurrency
issue on the LibreOffice Calc Software.

LibreOffice version 5.2.7.2 is behaving properly with no issues whatsoever.
The first version tested that the issue is present was on 5.3.0.1, additionally
this behavior is also happening on the current 7.1 version. It is worth
mentioning that I have also tested the DDE server using a Excel worksheet and
it is behaving properly. 

If need be, we may be able to provide a trial version of the software that
hosts the DDE Server so the issue is easily replicated.

-- 
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/20210222/9483418b/attachment-0001.htm>