Created attachment 120676 [details] This is a spreadsheet that takes ages to load When opening an excel spreadsheet in calc 5 (latest version), it takes over 2 minutes to load. I have asked a collegue to do the same and it still happens, which therefore points to calc and not the performance of my computer. (It has 16 GB of memory anyway) I have checked the box to start libreoffice at bootup, but it makes not difference. I am opening the spreadsheet from outlook email or opening the file that save on my desktop. If I use excel, it open within .5 of a second. The spreadsheet is relatively small. In the strictest confidence I have attached the spreadsheet. Many thanks
I can confirm with Version: 5.1.0.0.alpha1+ Build ID: 8bde421ccec9c10fe1382ad68485852889dd4c74 LO 1-2 min excel 2 sec LO Version 4.0.0.3 (Build ID: 7545bee9c2a0782548772a21bc84a9dcc583b89) - 2 sec => regression bibisect-win32-5.0, oldest version contains bug too. git checkout oldest: Version: 4.5.0.0.alpha0+ Build ID: 57d6b92b69a31260dea0d84fcd1fc5866ada7adb
Created attachment 120691 [details] Sample sheet with direct format beyond data cleared. Something in relation with the format, in the data sheets, there is direct format up to the last column, and in the "PERIOD1 ACTUALvsBUDGET" sheet there is data also up to the last column, clearing those direct formats solves the issue. LibreOffice doesn't like xlsx spreadsheets with a lot of direct format, maybe there is a bug loading direct format cells. Attached sample sheet after clear direct format. loads without any delay for me.
This seems to have begun at the below commit. 2bb13e48deb78b92b5d6736df8907dd4335cf775 is the first bad commit commit 2bb13e48deb78b92b5d6736df8907dd4335cf775 Author: Matthew Francis <mjay.francis@gmail.com> Date: Thu May 28 17:31:49 2015 +0800 source-hash-3797e61e5eb15b9dee9c55afe95013f134ac2d5d commit 3797e61e5eb15b9dee9c55afe95013f134ac2d5d Author: Kohei Yoshida <kohei.yoshida@collabora.com> AuthorDate: Thu Nov 21 15:08:48 2013 -0500 Commit: Kohei Yoshida <kohei.yoshida@collabora.com> CommitDate: Fri Nov 22 09:03:33 2013 -0500 More removal of UNO API for setting document properties. Change-Id: I8c68308394a64eee0985d7d1f8c8b34637a6da74 bibisect-43max$ git bisect log # bad: [74b89c3193673ba9897dc4a4541500ef6e8d9bf7] source-hash-8f97326bdd3f42fc82aa5e1989fd03b0af1daf64 # good: [9c392cfdfe6e9a9bce98555ea989283a957aa3ad] source-hash-fc8f44e82de4ebdd50ac5fbb9207cd1a59a927e3 git bisect start 'latest' 'oldest' # bad: [e289d9d328719fd70e9a2680fd0e4f586a97b3be] source-hash-3c0a7cf4f67720f2cca2c4eb543f838d5b644e7f git bisect bad e289d9d328719fd70e9a2680fd0e4f586a97b3be # bad: [0327d0bc45d60df0d1c8ac2470cf252b6bb8f780] source-hash-38fed70782ae6ac6b0282897c7abc6fa33a6de9e git bisect bad 0327d0bc45d60df0d1c8ac2470cf252b6bb8f780 # bad: [130c0f90cdc74b7300c74ee7d49c459ea8b8c4f4] source-hash-4a969ac35174520f1ffeb4f919f5d7bb6d99a628 git bisect bad 130c0f90cdc74b7300c74ee7d49c459ea8b8c4f4 # bad: [a4ca1d9431eedeb3ce6b22b96cfabc5ccc3cb857] source-hash-c85f1ed54f64bb7c7d309ec87df9ce8027a4a108 git bisect bad a4ca1d9431eedeb3ce6b22b96cfabc5ccc3cb857 # bad: [b41194f886e84e8427e7c389e7cd8e66b888372a] source-hash-0379f8b6393e99667584a2964bedf82e4306c2fa git bisect bad b41194f886e84e8427e7c389e7cd8e66b888372a # bad: [45dfd25d60c9d931c1d173f3fddd6317b3df5235] source-hash-871d8e0f278dab646e1877a505577edc730a26cf git bisect bad 45dfd25d60c9d931c1d173f3fddd6317b3df5235 # bad: [32343c6b902cd03fa9403181fa48a29811e961ad] source-hash-afd16e30f679e8e1e86edf1ee4185cf5b9cf4186 git bisect bad 32343c6b902cd03fa9403181fa48a29811e961ad # skip: [e3c9760077616925aade51d1f1bbe3fc1fa55431] source-hash-c409b66842bd8eb368f9e6be4abb17dee3070682 git bisect skip e3c9760077616925aade51d1f1bbe3fc1fa55431 # skip: [9240b6d230062f6a9ddf0d6d85cdadc1b8ad0fbf] source-hash-a50a2111a31e4d9dd5e2659a146e9de8e292de75 git bisect skip 9240b6d230062f6a9ddf0d6d85cdadc1b8ad0fbf # skip: [93749354238b5f910f2d69d49a885689643aee45] source-hash-79ceef879205c428bbb87e729a2d3ba68d6e6a0f git bisect skip 93749354238b5f910f2d69d49a885689643aee45 # skip: [18d7adb9fb8a48293f684f70f1d20d5eea1213da] source-hash-2a46a01902bccd1f025cce92ce6d32efbabf6825 git bisect skip 18d7adb9fb8a48293f684f70f1d20d5eea1213da # skip: [790e200b495803aee7624235ec3a623e16fed640] source-hash-3a22d789c22452b6a481c331db680a6b9d87a8ca git bisect skip 790e200b495803aee7624235ec3a623e16fed640 # bad: [286b861f969bcf7bca681cfaf2fe52f44bec5921] source-hash-87dc22287604a702b584cd8a9272870421b8b6d1 git bisect bad 286b861f969bcf7bca681cfaf2fe52f44bec5921 # skip: [36fa3e98791b8652f7597a163ae59c348d8a4f06] source-hash-6266efb0fe8cd52ee908d5d36f1de322735fe8bc git bisect skip 36fa3e98791b8652f7597a163ae59c348d8a4f06 # bad: [c0d0bf14380c28710474842c719da7b8b98fcae5] source-hash-263d8b92705c2492473383da11aebb9f9265a06e git bisect bad c0d0bf14380c28710474842c719da7b8b98fcae5 # skip: [59bc8c01a144548a8cd5efdb4189e83616a60c00] source-hash-91efe26d177b0686923b95b5c28cb208798f1df6 git bisect skip 59bc8c01a144548a8cd5efdb4189e83616a60c00 # skip: [4514a63d8d1631c6c75f440679684ff8f6124176] source-hash-fc87d57f04132658e1c3481e92fe36e1183423ed git bisect skip 4514a63d8d1631c6c75f440679684ff8f6124176 # good: [9b5fc8b7cebfcbc2feb5c2cfce038b28ed87e991] source-hash-979f05eee3dafba60f6b93744183035e9cc8be81 git bisect good 9b5fc8b7cebfcbc2feb5c2cfce038b28ed87e991 # skip: [3d1bfeb0b89f5f87eb8185ead6a7065278781285] source-hash-5620f5ba2fa123f029ac449f69a89ffc5703c71e git bisect skip 3d1bfeb0b89f5f87eb8185ead6a7065278781285 # skip: [51b4da2a905738d3496deacd41eb447731bff0cb] source-hash-09e2349c51cd9a8e5d7544e07266a5ff681ef328 git bisect skip 51b4da2a905738d3496deacd41eb447731bff0cb # skip: [7497ea499724ec002cc0961e10669fc9655ba9fc] source-hash-f3f4d9ec0f0eaa1aebdfebe831021a9d96e63f58 git bisect skip 7497ea499724ec002cc0961e10669fc9655ba9fc # skip: [1a0d2c65a995527b4c816184007b0554385f85d8] source-hash-668d6ada160438c396849a8309864f5fd33f33ac git bisect skip 1a0d2c65a995527b4c816184007b0554385f85d8 # skip: [55418b483de971e75084e73eab35faf7be63ea83] source-hash-d7791c933d8f7545b2535fe1a6d706008d2f9605 git bisect skip 55418b483de971e75084e73eab35faf7be63ea83 # skip: [1f5e60a307186d6572e9238296f72ee3549f76c7] source-hash-89633c6da1cde46983926dcc2e0f8e08de0e9378 git bisect skip 1f5e60a307186d6572e9238296f72ee3549f76c7 # skip: [3b46706316b856350d82790f54c9ca38e678b1d0] source-hash-2241fd5302c1ec83c8cbaa2422a477628a569aab git bisect skip 3b46706316b856350d82790f54c9ca38e678b1d0 # skip: [0e979e694c8ed1d69aba47e11df35faf8decb613] source-hash-6c4f737ec88a4f4dc5da8b2295ca5e7de2d4c24f git bisect skip 0e979e694c8ed1d69aba47e11df35faf8decb613 # skip: [5907d69c590c0b536c77558315557b3175b0d30e] source-hash-856ceb2cc5d78c36c7a8fc6118254d85f990d7e6 git bisect skip 5907d69c590c0b536c77558315557b3175b0d30e # skip: [ff4744f2ff39939c3c622486782d305a386da2e4] source-hash-deb249e1b3a3095e0d04c47f57044fe5b0ddf095 git bisect skip ff4744f2ff39939c3c622486782d305a386da2e4 # skip: [5e5f0396a439678d592b3fa07c602847a7d161bd] source-hash-f412c241f18b2ba465352394aadd65b11b31de67 git bisect skip 5e5f0396a439678d592b3fa07c602847a7d161bd # good: [27fb7cc666b5abdba9e4a56a56e64930ad0654f1] source-hash-0762f059c49289d56010d667fd2311d349f5d383 git bisect good 27fb7cc666b5abdba9e4a56a56e64930ad0654f1 # bad: [704388eb655b9d7d909c314689330c7275c47409] source-hash-c403dd11cc7029082b43ef3935ffc5553dbf5064 git bisect bad 704388eb655b9d7d909c314689330c7275c47409 # bad: [58813f0a8dcc992edd842b2051a34fd9d76b6be1] source-hash-6087da0dd402013b7d67fe6754081e647fdc5f8c git bisect bad 58813f0a8dcc992edd842b2051a34fd9d76b6be1 # bad: [2bb13e48deb78b92b5d6736df8907dd4335cf775] source-hash-3797e61e5eb15b9dee9c55afe95013f134ac2d5d git bisect bad 2bb13e48deb78b92b5d6736df8907dd4335cf775 # first bad commit: [2bb13e48deb78b92b5d6736df8907dd4335cf775] source-hash-3797e61e5eb15b9dee9c55afe95013f134ac2d5d
Migrating Whiteboard tags to Keywords: (bibisected, perf)
Looks instant to me in current master.
Reproducible with: Win7x64 Version: 5.0.5.2 Build ID.: 55b006a02d247b5f7215fc6ea0fde844b30035b3 TinderBox: Win-x86@62-merge-TDF, Branch:libreoffice-5-0, Time: 2016-03-07_09:00:12 Opens quick with: Version: 5.1.2.1 (x64) Build ID: 2603b69c5ec5981bb5f053f8ebfd1f3de00a4c29 CPU Threads: 1; OS Version: Windows 6.19; UI Render: default;
Yes, looks to be fixed, few seconds in Version: 5.2.0.0.alpha0+. Closing. IanG, seems to be fixed with dev version. Please could you test it with dev version? You can download it here: http://dev-builds.libreoffice.org/daily/master/
Hi @raal, if I'm not wrong 5.0 it's not EOL, last release will be 18/05/2016. If it won't be fixed, I think resolution must be WONTFIX