| Summary: | CPU-bound hang opening spreadsheet | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Jim Avera <jim.avera> |
| Component: | Calc | Assignee: | Markus Mohrhard <markus.mohrhard> |
| Status: | RESOLVED FIXED | ||
| Severity: | major | CC: | h3734236, ilmari.lauhakangas, raal |
| Priority: | high | Keywords: | bibisected, perf, regression |
| Version: | 5.1.0.0.alpha0+ Master | ||
| Hardware: | Other | ||
| OS: | All | ||
| Whiteboard: | target:5.2.0 | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | Test spreadsheet which make LO "hang" when loading | ||
Reproduced hang. Win 7 Pro 64-bit Version: 5.1.0.0.alpha1+ (x64) Build ID: 9ce08dcc2e32c5554ddf71b79173f8854e0568ad TinderBox: Win-x86_64@62-TDF, Branch:MASTER, Time: 2015-09-17_21:43:51 Locale: en-US (fi_FI) bibescted with 50max, using: git bisect run bash -c "opt/program/soffice -env:UserInstallation=file:///tmp/soffice-bisect ../../bug_94429/test.ods || exit 1" # bad: [dda106fd616b7c0b8dc2370f6f1184501b01a49e] source-hash-0db96caf0fcce09b87621c11b584a6d81cc7df86 # good: [5b9dd620df316345477f0b6e6c9ed8ada7b6c091] source-hash-2851ce5afd0f37764cbbc2c2a9a63c7adc844311 git bisect start 'latest' 'oldest' # skip: [0c30a2c797b249d0cd804cb71554946e2276b557] source-hash-45aaec8206182c16025cbcb20651ddbdf558b95d git bisect skip 0c30a2c797b249d0cd804cb71554946e2276b557 # skip: [0c30a2c797b249d0cd804cb71554946e2276b557] source-hash-45aaec8206182c16025cbcb20651ddbdf558b95d git bisect skip 0c30a2c797b249d0cd804cb71554946e2276b557 # good: [0c30a2c797b249d0cd804cb71554946e2276b557] source-hash-45aaec8206182c16025cbcb20651ddbdf558b95d git bisect good 0c30a2c797b249d0cd804cb71554946e2276b557 # bad: [2ce02b2ce56f12b9fcb9efbd380596975a3a5686] source-hash-17d714eef491bda2512ba8012e5b3067ca19a5be git bisect bad 2ce02b2ce56f12b9fcb9efbd380596975a3a5686 # bad: [2a6310949964d9626c516f2c649b8874f1a24a18] source-hash-871740210e5608e619b37297b47362f534f7ed8d git bisect bad 2a6310949964d9626c516f2c649b8874f1a24a18 # bad: [391054ff3d3d5a47195e45ad70cff490d2e9dd0d] source-hash-1ddd165418d72536e494ce6d2a078ab1ef3b20c9 git bisect bad 391054ff3d3d5a47195e45ad70cff490d2e9dd0d # bad: [534715525a93b0d7d56ba123d253c927cccf0afe] source-hash-40c9a46b78b8919aae82dd9b94774d63bb9cb4e6 git bisect bad 534715525a93b0d7d56ba123d253c927cccf0afe # good: [c255ade961c9628f72d2fbca268fdf3a4e5f60c2] source-hash-4bdbea5447f36beb9cc33df173a89a49a9918290 git bisect good c255ade961c9628f72d2fbca268fdf3a4e5f60c2 # good: [2b4739cd51404149b1279b86643f1fee719de667] source-hash-8ee20e2691aa6f67c67d40c61a8cd1569458b5a8 git bisect good 2b4739cd51404149b1279b86643f1fee719de667 # good: [9891e7d487540e4650378e546aea5025876d02cf] source-hash-b2f76e0e8a81b456f47b677cd881cc105f781cdb git bisect good 9891e7d487540e4650378e546aea5025876d02cf # skip: [891b689ba95b9e53609194ee2a1a2d3b8955843c] source-hash-01f406bc28f53acc5a2734af637aa8074a5d1813 git bisect skip 891b689ba95b9e53609194ee2a1a2d3b8955843c # good: [1e9077bc3cddafd46edbf547ba6ab12628388a9e] source-hash-fa4ce83f567cfb735bdfd2319458585ded4cd554 git bisect good 1e9077bc3cddafd46edbf547ba6ab12628388a9e # good: [7af487a891c9a59de3b45226ebc9e7df95d6c4bb] source-hash-1ac9985ade97f91869a11ce45231ffd6a5440959 git bisect good 7af487a891c9a59de3b45226ebc9e7df95d6c4bb # good: [aa7507ca437687a092c086522a62696d316fc469] source-hash-1028643bc7d294e4c32b4ccea288d90088abae53 git bisect good aa7507ca437687a092c086522a62696d316fc469 # good: [cfa6015c1d535c8e22bef6a6abb9363c757693d1] source-hash-9e678c14e4fc8e58b1e0530744f648fa3958d338 git bisect good cfa6015c1d535c8e22bef6a6abb9363c757693d1 # bad: [0a9eee9b8daa9c3fe698a5d31435df4af462e2a5] source-hash-3da65dc8982167517f19e80a288b049118bc3d23 git bisect bad 0a9eee9b8daa9c3fe698a5d31435df4af462e2a5 # bad: [eb937212a1dc1fca07e61451b053a092b9418ff2] source-hash-ca3700c42238e71684ec1d5f5eacaea4b1ca3b30 git bisect bad eb937212a1dc1fca07e61451b053a092b9418ff2 # bad: [18afb8632caa524fbc70ed5ce3808e23e5dad16f] source-hash-d05a64df34fd143670cb939b72abfb32d6b714c7 git bisect bad 18afb8632caa524fbc70ed5ce3808e23e5dad16f # only skipped commits left to test # possible first bad commit: [18afb8632caa524fbc70ed5ce3808e23e5dad16f] source-hash-d05a64df34fd143670cb939b72abfb32d6b714c7 # possible first bad commit: [891b689ba95b9e53609194ee2a1a2d3b8955843c] source-hash-01f406bc28f53acc5a2734af637aa8074a5d1813 Migrating Whiteboard tags to Keywords: (bibisected) [NinjaEdit] Looks like another case of the STYLE function inside of conditional formatting. Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=28d0e255e231639c4d79f6dedbe972d6daeae7f0 tdf#94429, tdf#92198, tdf#95233: STYLE in conditional formatting It will be available in 5.2.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. I'm still going to either remove STYLE in conditional format formulas or limit it to the 1 parameter version as part of 5.3. This is an ugly hack for 5.2. |
Created attachment 118919 [details] Test spreadsheet which make LO "hang" when loading Using 5.1.0.0.alpha1 on 64-bit linux (Ubuntu 15.04) Something horrible happens with the attached .ods spreadsheet which pegs the CPU and prevents LO from functioning normally. When first opened, a blank window is displayed for maybe 30 seconds; then the spreadsheet view is painted, bit by bit, and after a couple of minutes it all seems to be showing. However LO is unresponsive and the CPU remains pegged at 100%. => This spreadsheet functions perfectly using Apache Open Office 4.4.1 lo 4.4.2.2 opens the spreadsheet quickly, but if macros are enabled it crashes during certain operations. I didn't get far enough to try the macros with 5.1 alpha1, since I can't even load the spreadsheet with macros DISABLED. STEPS TO REPRODUCE: 1. Start lo on the attached spreadsheet 2. When prompted, DISABLE macros EXPECTED RESULTS: Spreadsheet displays promptly ACTUAL RESULTS: Spreadsheet "never" displays, and CPU stays pegged at 100% NOTE/IDEA/CONJECTURE: This .ods file contains several dozen "sheets", each of which contains a few lines which use Conditional Formats to change the color and possibly font size of affected cells, depending on the data. Maybe the problem has something to do with that.