[Libreoffice-bugs] [Bug 122040] New: Performance issue with highly formatted spreadsheet

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 122040
           Summary: Performance issue with highly formatted spreadsheet
           Product: LibreOffice
           Version: 6.1.3.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: william at gathoye.be

Description:
We have received a bug report via our Twitter account @LibreOfficeFR.

One of our users, being diabetic, has been noting in a XLS spreadsheet all the
aliments he has been eating for a bunch of years now.

The document has two sheets and each of them has quite a bunch of rows. Most of
the row has direct formatted content and some of them even have conditional
formatting rules.

While the document loads rapidly on Office, the user complained it was taking a
huge time to open on LibreOffice.

We have been able to reproduce the issue. While the document loads in instant
on Excel (tested with latest Office 365 version), the document opens in about
1m30 on my machine with LibreOffice. 

The user is still making use of Office 2000. We first thought the issue was due
to that old version, but the document is nearly identical when saving from
Office 365.
The issue is not due to the XLS format either. Converting the document to ods
has still the same issue. The same applies if we copy paste the content of each
sheet to a brand new document and save to ods directly instead of proceeding to
a xls -> ods convertion from an existing XLS file.

By removing the direct formatting (by using Ctrl+M), the opening process is
shorter of 20 seconds.

Arnaud Versini has begun to bisect the issue with cachegrind, and we realized a
method calling C++ Vector is being called a lot of time (the hole list being
scanned over and over again at each iteration). This is a good start to search
of possible optimizations.

Joined to this bug report is the XLS file (original file). We are also
providing a ods conversion where direct formatting has been removed.

Steps to Reproduce:
1. Simpy open the document and see for yourselves.
2.
3.

Actual Results:
Pretty slow to load

Expected Results:
Nearly instant loading.


Reproducible: Always


User Profile Reset: Yes



Additional Info:

-- 
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/20181212/3c5a5593/attachment.html>