[Libreoffice-bugs] [Bug 116425] New: FILEOPEN XLSX Excel spreadsheet takes forever and a lot of CPU time to open

[b***@bugs.documentfoundation.org]

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

Bug ID: 116425
Summary: FILEOPEN XLSX Excel spreadsheet takes forever and a
lot of CPU time to open
Product: LibreOffice
Version: 6.0.2.1 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-***@lists.freedesktop.org
Reporter: ***@gmail.com

Description:
Here I have a spreadsheet that Calc absolutely chokes on. Just opening the file
take about 2 minutes of CPU time, while Calc is completely unresponsive. Even
after the document is open, all operations are very sluggish and Calc
repeatedly locks up and stops responding for many seconds. MS Excel 2016 has no
problems opening the file under 10-20 seconds.

Steps to Reproduce:
1. Try to open attached document
2. Observe that it locks up, uses 100% of one CPU core, and after a long time
it opens the document
3. Observe that any attempted operation in the document can take a very long
time

Actual Results:
The file takes forever to open and locks up LO for extended periods of time

Expected Results:
The file should open quickly, without excessive CPU usage. LO should not lock
up and stop responding while loading the document.


Reproducible: Always


User Profile Reset: No



Additional Info:
Verzió: 6.0.2.1 (x64)
Build az.: f7f06a8f319e4b62f9bc5095aa112a65d2f3ac89
CPU szálak: 2; OS: Windows 6.1; FelÌletmegjelenítés: alapértelmezett;
TerÌleti beállítások: hu-HU (hu_HU); Calc: CL


User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:56.0) Gecko/20100101
Firefox/56.0.4 Waterfox/56.0.4

[b***@bugs.documentfoundation.org]

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

***@gmail.com changed:

What |Removed |Added
----------------------------------------------------------------------------
CC| |***@gmail.com

--- Comment #1 from ***@gmail.com ---
Created attachment 140660
--> https://bugs.documentfoundation.org/attachment.cgi?id=140660&action=edit
document that triggers the issue

[b***@bugs.documentfoundation.org]

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

m.a.riosv <***@libreoffice.org> changed:

What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |WORKSFORME

[b***@bugs.documentfoundation.org]

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

m.a.riosv <***@libreoffice.org> changed:

What |Removed |Added
----------------------------------------------------------------------------
CC| |***@libreoffice.o
| |rg

--- Comment #2 from m.a.riosv <***@libreoffice.org> ---
Created attachment 140661
--> https://bugs.documentfoundation.org/attachment.cgi?id=140661&action=edit
Cleaned spreadsheet

There is a lot of unused cell with direct format, cleaning it the spreadsheet
opens fine.

btw the sheet it's protected.

Resolved as works for me, please if you are not agree, reopen it.

[b***@bugs.documentfoundation.org]

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

***@gmail.com changed:

What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |REOPENED
Resolution|WORKSFORME |---
Ever confirmed|0 |1

--- Comment #3 from ***@gmail.com ---
(In reply to m.a.riosv from comment #2)

Created attachment 140661 [details]
Cleaned spreadsheet
There is a lot of unused cell with direct format, cleaning it the
spreadsheet opens fine.
btw the sheet it's protected.
Resolved as works for me, please if you are not agree, reopen it.

I have no idea how to clean unused cells with direct format, could you write
down how you did it please? (or link a tutorial/guide?)

I also disagree that this is not a bug.
LibreOffice should be fully compatible with MS Office, and thus not being able
to open some files that MS Office can open without problems is a huge issue.
Ordinary users should never be forced to file a bug report. My mother run into
this problem (she has no MS Office on her computer), and she was in complete
despair, because she had no idea what went wrong and how to fix it or get
information. Issues like this one completely ruin the usability of LO for
noobs.

[b***@bugs.documentfoundation.org]

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

--- Comment #4 from m.a.riosv <***@libreoffice.org> ---
To clear a direct format use Ctrl+M on the selected cells.

As I comment the file is protectod so it's no possible e.g. to see if there are
conditional formats slowing the file.

LibreOffice is more oriented to the use of the styles, with all those cells
having defined styles is quicker.

Reopen the bug, it's your choice.

[b***@bugs.documentfoundation.org]

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

Xisco Faulí <***@libreoffice.org> changed:

What |Removed |Added
----------------------------------------------------------------------------
Status|REOPENED |UNCONFIRMED
CC| |***@libreoffice.org
Ever confirmed|1 |0

--- Comment #5 from Xisco Faulí <***@libreoffice.org> ---
You can't confirm your own bugs. Moving it back to UNCONFIRMED until someone
else confirms it.

[b***@bugs.documentfoundation.org]

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

Buovjaga <***@suomi24.fi> changed:

What |Removed |Added
----------------------------------------------------------------------------
CC| |***@suomi24.fi

--- Comment #6 from Buovjaga <***@suomi24.fi> ---
Created attachment 140865
--> https://bugs.documentfoundation.org/attachment.cgi?id=140865&action=edit
Callgrind output from master

Let's leave it open in case someone wants to optimise things based on this
callgrind.

Arch Linux 64-bit
Version: 6.1.0.0.alpha0+
Build ID: 144bc302b8e610422f0bdbfceb1726822454dfbc
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: kde4;
Locale: fi-FI (fi_FI.UTF-8); Calc: group
Built on March 23th 2018

[b***@bugs.documentfoundation.org]

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

Buovjaga <***@suomi24.fi> changed:

What |Removed |Added
----------------------------------------------------------------------------
Keywords| |bibisectRequest,
| |filter:xlsx, haveBacktrace,
| |perf, regression
Status|UNCONFIRMED |NEW
Ever confirmed|0 |1

--- Comment #7 from Buovjaga <***@suomi24.fi> ---
Uu, this is actually a regression as 3.6 opens it very quickly.

Arch Linux 64-bit
Version 3.6.7.2 (Build ID: e183d5b)

[b***@bugs.documentfoundation.org]

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

Xisco Faulí <***@libreoffice.org> changed:

What |Removed |Added
----------------------------------------------------------------------------
Version|6.0.2.1 release |4.1 all versions

--- Comment #8 from Xisco Faulí <***@libreoffice.org> ---
Reproduced in


Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)

but not in

LibreOffice 3.3.0
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4

[b***@bugs.documentfoundation.org]

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

Buovjaga <***@suomi24.fi> changed:

What |Removed |Added
----------------------------------------------------------------------------
Version|4.1 all versions |4.0.0.3 release
Keywords|bibisectRequest |bibisected

--- Comment #9 from Buovjaga <***@suomi24.fi> ---
Bibisected on Linux with 43all to range
https://cgit.freedesktop.org/libreoffice/core/log/?qt=range&q=b67a51b40a4876f4bd97a2917103112006710b0c...c33019b36d613f951787ce9836e34d74bfbd6a1b
Has lots of commits from Kohei.

[b***@bugs.documentfoundation.org]

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

Roman Kuznetsov <***@mail.ru> changed:

What |Removed |Added
----------------------------------------------------------------------------
Blocks| |108897


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=108897
[Bug 108897] [META] XLSX (OOXML) bug tracker