[Libreoffice-bugs] [Bug 93831] FILEOPEN XLSX Slow to open

[bugzilla-daemon]

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

--- Comment #21 from Xisco Faulí  ---
(In reply to Xisco Faulí from comment #18)
> in
> 
> Version: 7.0.0.0.alpha0+
> Build ID: a11c10a83f6fceae6cfb519725d06f8eaf1013fb
> CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3; 
> Locale: en-US (en_US.UTF-8); UI-Language: en-US
> Calc: threaded
> 
> it takes
> 
> real  1m54,802s
> user  1m52,350s
> sys   0m3,853s
> 
> while it takes
> 
> real  7m8,964s
> user  7m9,469s
> sys   0m3,468s
> 
> before the commit. Nice!!
> @Noel, thanks for fixing this issue!!

wow, it takes

real0m13,383s
user0m13,588s
sys 0m1,122s

iin

Version: 7.2.0.0.alpha0+ / LibreOffice Community
Build ID: 4eac7a11e5d39ca6c783f65f1ca2df009b9a37e4
CPU threads: 4; OS: Linux 5.7; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

including all the commits improving bug 130326. Nicee!!

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93831] FILEOPEN XLSX Slow to open

[bugzilla-daemon]

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

Xisco Faulí  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=13
   ||0326

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93831] FILEOPEN XLSX Slow to open

[bugzilla-daemon]

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

NISZ LibreOffice Team  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=13
   ||6113

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93831] FILEOPEN XLSX Slow to open

[bugzilla-daemon]

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

--- Comment #20 from Commit Notification 
 ---
Noel Grandin committed a patch related to this issue.
It has been pushed to "libreoffice-6-3":

https://git.libreoffice.org/core/commit/ff1588da212285122e4c4efdbfb723fe9c56caa8

tdf#93831 xlsx file full of pictures of numbers slow to open

It will be available in 6.3.6.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93831] FILEOPEN XLSX Slow to open

[bugzilla-daemon]

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

Commit Notification  changed:

   What|Removed |Added

 Whiteboard|target:7.0.0 target:6.4.3   |target:7.0.0 target:6.4.3
   ||target:6.3.6

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93831] FILEOPEN XLSX Slow to open

[bugzilla-daemon]

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

--- Comment #19 from Commit Notification 
 ---
Noel Grandin committed a patch related to this issue.
It has been pushed to "libreoffice-6-4":

https://git.libreoffice.org/core/commit/6935465f9b56d99557ba627d845b9d1a2f2f2d07

tdf#93831 xlsx file full of pictures of numbers slow to open

It will be available in 6.4.3.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93831] FILEOPEN XLSX Slow to open

[bugzilla-daemon]

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

Commit Notification  changed:

   What|Removed |Added

 Whiteboard|target:7.0.0|target:7.0.0 target:6.4.3

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93831] FILEOPEN XLSX Slow to open

[bugzilla-daemon]

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

Xisco Faulí  changed:

   What|Removed |Added

 Status|RESOLVED|VERIFIED

--- Comment #18 from Xisco Faulí  ---
in

Version: 7.0.0.0.alpha0+
Build ID: a11c10a83f6fceae6cfb519725d06f8eaf1013fb
CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded

it takes

real1m54,802s
user1m52,350s
sys 0m3,853s

while it takes

real7m8,964s
user7m9,469s
sys 0m3,468s

before the commit. Nice!!
@Noel, thanks for fixing this issue!!

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93831] FILEOPEN XLSX Slow to open

[bugzilla-daemon]

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

Noel Grandin  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |FIXED

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93831] FILEOPEN XLSX Slow to open

[bugzilla-daemon]

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

--- Comment #17 from Commit Notification 
 ---
Noel Grandin committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/edf13fe1247e7ef411a9ff5435385573fad01f56

tdf#93831 xlsx file full of pictures of numbers slow to open

It will be available in 7.0.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93831] FILEOPEN XLSX Slow to open

[bugzilla-daemon]

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

Commit Notification  changed:

   What|Removed |Added

 Whiteboard||target:7.0.0

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93831] FILEOPEN XLSX Slow to open

[bugzilla-daemon]

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

--- Comment #16 from Noel Grandin  ---
The cells in this spreadsheet are pictures of numbers instead of actual
numbers.

Why?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93831] FILEOPEN XLSX Slow to open

[bugzilla-daemon]

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

--- Comment #15 from Xisco Faulí  ---
for me it takes

real3m1,621s
user2m59,361s
sys 0m1,037s

in

Version: 6.5.0.0.alpha0+
Build ID: bf540873f5e258452fed5006f65a403c95e7872a
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US
Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93831] FILEOPEN XLSX Slow to open

[bugzilla-daemon]

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

Roman Kuznetsov <79045_79...@mail.ru> changed:

   What|Removed |Added

 CC||noelgran...@gmail.com

--- Comment #14 from Roman Kuznetsov <79045_79...@mail.ru> ---
Noel, could you look at it?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93831] FILEOPEN XLSX Slow to open

[bugzilla-daemon]

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

--- Comment #13 from Julien Nabet  ---
Created attachment 156857
  --> https://bugs.documentfoundation.org/attachment.cgi?id=156857=edit
Flamegraph

Here's a Flamegraph retrieved on pc Debian x86-64 with master sources updated
today.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93831] FILEOPEN XLSX Slow to open

[bugzilla-daemon]

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

Roman Kuznetsov <79045_79...@mail.ru> changed:

   What|Removed |Added

 CC||79045_79...@mail.ru,
   ||serval2...@yahoo.fr

--- Comment #12 from Roman Kuznetsov <79045_79...@mail.ru> ---
(In reply to Xisco Faulí from comment #11)

> it takes
> 
> real  2m53,599s
> user  2m53,463s
> sys   0m1,264s
> 
> in
> 
> Version: 6.3.0.0.alpha0+
> Build ID: 3ab6d246cc44617af5ed416b5d49f2f35b61ceea
> CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
> Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US
> Calc: threaded
> 
> nice...

It takes 3:20 min for me in

Version: 6.5.0.0.alpha0+ (x64)
Build ID: 2d736e1a0a2bbd41fe7793d52bbcc7bfc89c7da3
CPU threads: 4; OS: Windows 10.0 Build 18362; UI render: default; VCL: win; 
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded

Julien, can you make the perfgraph here?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93831] FILEOPEN XLSX Slow to open

[bugzilla-daemon]

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

--- Comment #11 from Xisco Faulí  ---
(In reply to Xisco Faulí from comment #9)
> it takes
> 
> real  12m55,698s
> user  12m54,698s
> sys   0m1,577s
> 
> in
> 
> Version: 6.3.0.0.alpha0+
> Build ID: 3b518953a8141b0d5043c2f3996a92956fdc3a47
> CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
> Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US
> Calc: threaded

it takes

real2m53,599s
user2m53,463s
sys 0m1,264s

in

Version: 6.3.0.0.alpha0+
Build ID: 3ab6d246cc44617af5ed416b5d49f2f35b61ceea
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US
Calc: threaded

nice...

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93831] FILEOPEN XLSX Slow to open

[bugzilla-daemon]

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

--- Comment #10 from Buovjaga  ---
Created attachment 150500
  --> https://bugs.documentfoundation.org/attachment.cgi?id=150500=edit
Callgrind output from master

Arch Linux 64-bit
Version: 6.3.0.0.alpha0+
Build ID: 3b518953a8141b0d5043c2f3996a92956fdc3a47
CPU threads: 8; OS: Linux 5.0; UI render: default; VCL: gtk3; 
Locale: fi-FI (fi_FI.UTF-8); UI-Language: en-US
Calc: threaded
Built on 2 April 2019

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93831] FILEOPEN XLSX Slow to open

[bugzilla-daemon]

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

--- Comment #9 from Xisco Faulí  ---
it takes

real12m55,698s
user12m54,698s
sys 0m1,577s

in

Version: 6.3.0.0.alpha0+
Build ID: 3b518953a8141b0d5043c2f3996a92956fdc3a47
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US
Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93831] FILEOPEN XLSX Slow to open

[bugzilla-daemon]

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

Roman Kuznetsov <79045_79...@mail.ru> changed:

   What|Removed |Added

 Blocks||108897, 109530

--- Comment #8 from Roman Kuznetsov <79045_79...@mail.ru> ---
still repro in

Version: 6.3.0.0.alpha0+
Build ID: c57dc7d41bd62f933cffab6131edb7252606382d
CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win; 
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded

I got a freeze of LO


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=108897
[Bug 108897] [META] XLSX (OOXML) bug tracker
https://bugs.documentfoundation.org/show_bug.cgi?id=109530
[Bug 109530] [META] File opening issues
-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93831] FILEOPEN XLSX Slow to open

[bugzilla-daemon]

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

--- Comment #7 from QA Administrators  ---
** Please read this message in its entirety before responding **

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice
from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information
from Help - About LibreOffice.

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave a comment that includes the information from Help
- About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a
REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your
bug pertains to a feature added after 3.3) from
http://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat:
https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93831] FILEOPEN XLSX Slow to open

[bugzilla-daemon]

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

Xisco Faulí  changed:

   What|Removed |Added

   Keywords|bibisectRequest |bibisected
   Hardware|x86-64 (AMD64)  |All
Version|5.0.0.1 rc  |4.0 all versions

--- Comment #6 from Xisco Faulí  ---
Regression introduced in range 

https://cgit.freedesktop.org/libreoffice/core/log/?qt=range=683758efb22d08a4cf211a6d985148f513da2a90..a599f5b4b51848e3b397d471c9d12b373caadcef

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93831] FILEOPEN XLSX Slow to open

[bugzilla-daemon]

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

Buovjaga  changed:

   What|Removed |Added

   Keywords||bibisectRequest, regression
Summary|FILEOPEN, FILESAVE XLSX |FILEOPEN XLSX Slow to open
   |file slow to open and   |
   |crashes on save |
 OS|Windows (All)   |All

--- Comment #5 from Buovjaga  ---
Confirmed it does not crash on save anymore. Still a bit slow to open.

It is faster with 3.6.

Arch Linux 64-bit, KDE Plasma 5
Version: 5.4.0.0.alpha0+
Build ID: 54f9a81a1c041c18d209d7eb4659ac18a3ca76dd
CPU threads: 8; OS: Linux 4.10; UI render: default; VCL: kde4; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group
Built on March 25th 2016

Version: 5.4.0.0.alpha0+ (x64)
Build ID: 193f8966135064a32164c9da08d01dab9c1fc15d
CPU threads: 4; OS: Windows 6.19; UI render: default; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2017-03-25_02:08:45
Locale: fi-FI (fi_FI); Calc: group

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

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs