Created attachment 54142 [details] The 2012 budget book linked here: http://www.kent.edu/budgetoffice/index.cfm (probably generated by Excel 201?) Problem description: What the title says. Steps to reproduce: 1. Open attached file 2. Wait 3. ??? 4. Profit! Current behavior: Libreoffice stalls after drawing a blank gray window and it consume all of one core's cycles. Memory usage is nominal and stable. (82.5MB in my case) An essentially useless strace shows that it continues to poll for mouse movement. Expected behavior: File should open and display. All memory and cores should be consumed. Platform: Archlinux x64 libreoffice-calc: 3.4.4-3
Actually, after liboffice runsa at full-tilt for a few minutes (5?), the CPU usage drops to 0. RAM usage is still the same. I'm not sure what's happening at that point, since I didn't throw an strace on it.
seems very slow on looping on properties here is a backtrace (gdb) bt #0 0xac9d57b4 in ScAttrArray::FindStyleSheet (this=0x9096110, pStyleSheet=0xa8c68a88, rUsedRows=..., bReset=false) at /home/lgodard/projets/libreoffice/build/git/master/libo/sc/source/core/data/attarray.cxx:1723 #1 0xaca07348 in ScColumn::FindStyleSheet (this=0x908b518, pStyleSheet=0xa8c68a88, rUsedRows=..., bReset=false) at /home/lgodard/projets/libreoffice/build/git/master/libo/sc/source/core/data/column.cxx:631 #2 0xacb7fe4a in ScTable::StyleSheetChanged (this=0x9085b90, pStyleSheet=0xa8c68a88, bRemoved=false, pDev=0xbfffbad0, nPPTX=0.067000000000000004, nPPTY=0.067000000000000004, rZoomX=1/1, rZoomY=1/1) at /home/lgodard/projets/libreoffice/build/git/master/libo/sc/source/core/data/table2.cxx:2037 #3 0xaca8413c in ScDocument::StyleSheetChanged (this=0x8d64740, pStyleSheet=0xa8c68a88, bRemoved=false, pDev=0xbfffbad0, nPPTX=0.067000000000000004, nPPTY=0.067000000000000004, rZoomX=1/1, rZoomY=1/1) at /home/lgodard/projets/libreoffice/build/git/master/libo/sc/source/core/data/document.cxx:4492 #4 0xad1643d7 in ScStyleObj::SetOnePropertyValue (this=0xa8d68ecc, rPropertyName="WritingMode", pEntry=0x8c4c4f0, pValue=0xabaed438) at /home/lgodard/projets/libreoffice/build/git/master/libo/sc/source/ui/unoobj/styleuno.cxx:1943 #5 0xad162973 in ScStyleObj::setPropertyValues (this=0xa8d68ecc, aPropertyNames=uno::Sequence of length 39 = {...}, aValues=uno::Sequence of length 39 = {...}) at /home/lgodard/projets/libreoffice/build/git/master/libo/sc/source/ui/unoobj/styleuno.cxx:1519 #6 0xac061d82 in ?? () from /home/lgodard/projets/libreoffice/build/git/master/libo/solver/unxlngi6.pro/installation/opt/program/../program/libooxlo.so #7 0xac061eff in ?? () from /home/lgodard/projets/libreoffice/build/git/master/libo/solver/unxlngi6.pro/installation/opt/program/../program/libooxlo.so #8 0xac12ef5c in ?? () from /home/lgodard/projets/libreoffice/build/git/master/libo/solver/unxlngi6.pro/installation/opt/program/../program/libooxlo.so #9 0xac12efbd in ?? () from /home/lgodard/projets/libreoffice/build/git/master/libo/solver/unxlngi6.pro/installation/opt/program/../program/libooxlo.so #10 0xac12eade in ?? () from /home/lgodard/projets/libreoffice/build/git/master/libo/solver/unxlngi6.pro/installation/opt/program/../program/libooxlo.so #11 0xac12f684 in ?? () from /home/lgodard/projets/libreoffice/build/git/master/libo/solver/unxlngi6.pro/installation/opt/program/../program/libooxlo.so #12 0xac12fb80 in ?? () from /home/lgodard/projets/libreoffice/build/git/master/libo/solver/unxlngi6.pro/installation/opt/program/../program/libooxlo.so #13 0xac1339ee in ?? () from /home/lgodard/projets/libreoffice/build/git/master/libo/solver/unxlngi6.pro/installation/opt/program/../program/libooxlo.so #14 0xabdd9438 in ?? () from /home/lgodard/projets/libreoffice/build/git/master/libo/solver/unxlngi6.pro/installation/opt/program/../program/libooxlo.so #15 0xabd2b115 in ?? () from /home/lgodard/projets/libreoffice/build/git/master/libo/solver/unxlngi6.pro/installation/opt/program/../program/fastsax.uno.so #16 0xabdd08e7 in ?? () from /home/lgodard/projets/libreoffice/build/git/master/libo/solver/unxlngi6.pro/installation/opt/program/../program/libooxlo.so #17 0xabdd09ad in ?? () from /home/lgodard/projets/libreoffice/build/git/master/libo/solver/unxlngi6.pro/installation/opt/program/../program/libooxlo.so #18 0xabdde416 in oox::core::XmlFilterBase::importFragment(rtl::Reference<oox::core::FragmentHandler> const&) () from /home/lgodard/projets/libreoffice/build/git/master/libo/solver/unxlngi6.pro/installation/opt/program/../program/libooxlo.so #19 0xac1410d7 in ?? () from /home/lgodard/projets/libreoffice/build/git/master/libo/solver/unxlngi6.pro/installation/opt/program/../program/libooxlo.so #20 0xac13e7a2 in ?? () from /home/lgodard/projets/libreoffice/build/git/master/libo/solver/unxlngi6.pro/installation/opt/program/../program/libooxlo.so #21 0xabdd9438 in ?? () from /home/lgodard/projets/libreoffice/build/git/master/libo/solver/unxlngi6.pro/installation/opt/program/../program/libooxlo.so #22 0xabd2b115 in ?? () from /home/lgodard/projets/libreoffice/build/git/master/libo/solver/unxlngi6.pro/installation/opt/program/../program/fastsax.uno.so #23 0xabdd08e7 in ?? () from /home/lgodard/projets/libreoffice/build/git/master/libo/solver/unxlngi6.pro/installation/opt/program/../program/libooxlo.so #24 0xabdd09ad in ?? () from /home/lgodard/projets/libreoffice/build/git/master/libo/solver/unxlngi6.pro/installation/opt/program/../program/libooxlo.so #25 0xabdde416 in oox::core::XmlFilterBase::importFragment(rtl::Reference<oox::core::FragmentHandler> const&) () from /home/lgodard/projets/libreoffice/build/git/master/libo/solver/unxlngi6.pro/installation/opt/program/../program/libooxlo.so #26 0xac0dfbba in ?? () from /home/lgodard/projets/libreoffice/build/git/master/libo/solver/unxlngi6.pro/installation/opt/program/../program/libooxlo.so #27 0xabdd404a in oox::core::FilterBase::filter(com::sun::star::uno::Sequence<com::sun::star::beans::PropertyValue> const&) () from /home/lgodard/projets/libreoffice/build/git/master/libo/solver/unxlngi6.pro/installation/opt/program/../program/libooxlo.so #28 0xac0dfcac in ?? () from /home/lgodard/projets/libreoffice/build/git/master/libo/solver/unxlngi6.pro/installation/opt/program/../program/libooxlo.so #29 0xb796d0c8 in SfxObjectShell::ImportFrom(SfxMedium&, bool) () from /home/lgodard/projets/libreoffice/build/git/master/libo/solver/unxlngi6.pro/installation/opt/program/libsfxlo.so #30 0xb797436c in SfxObjectShell::DoLoad(SfxMedium*) () from /home/lgodard/projets/libreoffice/build/git/master/libo/solver/unxlngi6.pro/installation/opt/program/libsfxlo.so #31 0xb799625c in SfxBaseModel::load(com::sun::star::uno::Sequence<com::sun::star::beans::PropertyValue> const&) () from /home/lgodard/projets/libreoffice/build/git/master/libo/solver/unxlngi6.pro/installation/opt/program/libsfxlo.so
with profiling help, the offending area http://opengrok.libreoffice.org/xref/core/sc/source/ui/unoobj/styleuno.cxx#1943
in the file xl/styles.xml is 4.7 Mb a lot of styles defined <numFmts count="7"></numFmts><fonts count="95"></fonts><fills count="58"></fills><borders count="25"></borders><cellStyleXfs count="38064"></cellStyleXfs><cellXfs count="248"></cellXfs><cellStyles count="38064"></cellStyles>
Reproduced with LOdev 3.5.0beta2 4ca392c-760cc4d-f39cf3d-1b2857e-60db978 Ubuntu 10.04.3 x86 Linux 2.6.32-37-generic Russian UI Switch to NEW.
Any reason this is not a duplicate of bug 30770 ?
Just FYI: this presists with LO4.3RC1, OS X 10.9.3 LO4.4a0+, win 8.1
Forgot: Excel 2011 on OS X opens this rather fast.
** 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 on a currently supported version of LibreOffice (4.4.1 or later): https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System 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) 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: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for your help! -- The LibreOffice QA Team This NEW Message was generated on: 2015-07-18
Took a minute to open. Set severity to major due to tediousness. Win 7 Pro 64-bit Version: 5.1.0.0.alpha1+ Build ID: 186f32f63434e16ff5776251657f902d5808ed3d TinderBox: Win-x86@39, Branch:master, Time: 2015-10-16_09:42:47 Locale: en-US (fi_FI)
Migrating Whiteboard tags to Keywords: (perf)
On Linux with LO 5.2 and git master loading this document only takes a couple of seconds. Can you verify whether this is also the case with LO 5.2 or a nightly build on Windows? Although the performance is acceptable now, I still have some ideas of improving it further, but I think the bug can be closed with or without those improvements. (going from 5.5 to 4 seconds is nice to have, but not of major importance)
File opens instantly for me. Maarten: do you have some commits regarding this report? Just wondering, how we will close this. Arch Linux 64-bit, KDE Plasma 5 Version: 5.3.0.0.alpha0+ Build ID: cd72269a6a2c85ae9dd4552aa4808ef4fd1f6c0e CPU Threads: 8; OS Version: Linux 4.7; UI Render: default; Locale: fi-FI (fi_FI.UTF-8); Calc: group Built on September 21st 2016
Well, I have a work-in-progress patch lying around. I'll finalize it and submit it to gerrit probably somewhere in the next week. As I said, I think the original very poor is already solved in recent LO, that just needs to be confirmed by the submitter. But in looking where LO git master spends its time, I encountered some sfxstyle related code with german comments in it saying: "this needs to be optimized". So that's what I'm doing.
Ok, sounds great :) Closing this as WFM, then.
Maarten Bosmans committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=9d99a7b2d1dd973b50a699440ffb69d99d614607 tdf#43544 ScStyleObj: Only call StylePool->find() when necessary It will be available in 5.4.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=dd974413acc6ab00168a301cbb53b3c9caa11e32 nitpicks, tdf#43544 follow-up It will be available in 5.4.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Maarten Bosmans committed a patch related to this issue. It has been pushed to "libreoffice-5-3": http://cgit.freedesktop.org/libreoffice/core/commit/?id=852956a271578b9ad7c1ef2983381e109f2a8156&h=libreoffice-5-3 tdf#43544 ScStyleObj: Only call StylePool->find() when necessary It will be available in 5.3.0.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-5-3": http://cgit.freedesktop.org/libreoffice/core/commit/?id=1fe671546218135841d2cb1c99a993b95fd7e12c&h=libreoffice-5-3 nitpicks, tdf#43544 follow-up It will be available in 5.3.0.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.