[Libreoffice-bugs] [Bug 130851] New: When allowed to auto-update external links, Calc accesses them without need

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 130851
           Summary: When allowed to auto-update external links, Calc
                    accesses them without need
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: mikekaganski at hotmail.com
                CC: erack at redhat.com

Created attachment 158084
  --> https://bugs.documentfoundation.org/attachment.cgi?id=158084&action=edit
An XLSX with an external link in named range, which is not referenced anywhere

The attachment contain no data on a single empty sheet; the only thing that is
defined in the document is a named range that references a file on a network
share with Windows UNC name "\\path\to\file.xls" (and an invalid reference
there). The range is not used anywhere in the document, it's only defined.

When the document is opened, LO shows an infobar telling that automatic updates
of external links are disabled (with default settings). The problem is that if
the update is allowed, soffice.bin tries to access the network path.

This is a performance issue: if the share is unavailable, the request to access
the file must time out before LibreOffice can proceed. Given that the data in
not referenced anywhere, the network access is useless.

The time is spent in Content::isFolder (ucbhelper/source/client/content.cxx).
Eike: do you think it's possible to not try to access not referenced data? I
suppose that could also speed up documents that link to local files, too.

-- 
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/20200221/ae1ea71f/attachment.htm>