Bug 96594 - FILEOPEN: Calc needs over 2 minutes to open document (over 2 MB, conditional formatting)
Summary: FILEOPEN: Calc needs over 2 minutes to open document (over 2 MB, conditional ...
Status: RESOLVED DUPLICATE of bug 95437
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.4.0.3 release
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bisected, regression
Depends on:
Blocks:
 
Reported: 2015-12-19 11:23 UTC by Robert Großkopf
Modified: 2016-04-08 08:51 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Open the *.ods-file and wait ... (1.99 MB, application/vnd.oasis.opendocument.spreadsheet)
2015-12-19 11:23 UTC, Robert Großkopf 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Robert Großkopf 2015-12-19 11:23:22 UTC 
Created attachment 121400 [details]
Open the *.ods-file and wait ...

Open the attached Calc-file.
LO seems to hang for over 2 minutes at the end of calculating the file.

Works right up to LO 4.3.7, fails since LO 4.4.0.
It's the same behavior with OpenSUSE 42.1 Leap and Windows 7, so seams independant of OS.
Comment 1 raal 2015-12-19 11:56:46 UTC 
I can confirm with Version: 5.2.0.0.alpha0+
Build ID: dab2582f05979cd99a5937cb95a387cfed70bb8d
CPU Threads: 4; OS Version: Linux 4.2; UI Render: default; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2015-12-17_10:07:59
Comment 2 Jochen 2015-12-19 13:55:54 UTC 
I can confirm: hang over for over 2 minutes
LO 5.0.3
OS: Windows 8.1 64 bit
Comment 3 Terrence Enger 2015-12-20 06:43:17 UTC 
I am adding keyword bibisected as, working in the 50max bibisect
repository, I see from `git bisect good` (newlines added at will) ...

    6dbe7829ae2e823eb13343da435867b5c10b104d is the first bad commit
    commit 6dbe7829ae2e823eb13343da435867b5c10b104d
    Author: Matthew Francis <mjay.francis@gmail.com>
    Date:   Wed May 27 17:25:54 2015 +0800

        source-hash-573f5dfba805b733dd2da62bde3cd5d9d25879d9
    
        commit 573f5dfba805b733dd2da62bde3cd5d9d25879d9
        Author:     Eike Rathke <erack@redhat.com>
        AuthorDate: Thu Dec 18 13:26:48 2014 +0100
        Commit:     Eike Rathke <erack@redhat.com>
        CommitDate: Thu Dec 18 13:33:48 2014 +0100
    
            Resolves: fdo#86978 append formula cells to track instead of tree
    
            Cells in FormulaTree are assumed to be tracked already and their
            dependents be notified. Also postpone tracking until all listeners are
            established.
    
            Change-Id: I7f27fba979fe231e3d3cd071fcc8a273142cb3f3

    :040000 040000 7543a1f88a8fe0b7a5b0899b193d01802b30c27c
        41c6acfd8257ebb96ca624b39d36c76e61ef7874 M	opt

and from `git bisect log` ...

    # bad: [dda106fd616b7c0b8dc2370f6f1184501b01a49e]
         source-hash-0db96caf0fcce09b87621c11b584a6d81cc7df86
    # good: [5b9dd620df316345477f0b6e6c9ed8ada7b6c091]
         source-hash-2851ce5afd0f37764cbbc2c2a9a63c7adc844311
    git bisect start 'latest' 'oldest'
    # bad: [0c30a2c797b249d0cd804cb71554946e2276b557]
         source-hash-45aaec8206182c16025cbcb20651ddbdf558b95d
    git bisect bad 0c30a2c797b249d0cd804cb71554946e2276b557
    # bad: [770ff0d1a74d2450c2decb349b62c5087e12c46b]
         source-hash-549b7fad48bb9ddcba7dfa92daea6ce917853a03
    git bisect bad 770ff0d1a74d2450c2decb349b62c5087e12c46b
    # good: [227af65db5e34efcf8dcb0b53333efecd30f37f8]
         source-hash-193c7ba9be48f00b46f9e789f233db577e7b3303
    git bisect good 227af65db5e34efcf8dcb0b53333efecd30f37f8
    # good: [78b395d05689a5207f2ec4cc29ec296d64076a96]
         source-hash-a2e4be6ded508030a6c2a33919cbe8cb504382e0
    git bisect good 78b395d05689a5207f2ec4cc29ec296d64076a96
    # bad: [8dd6442885c969ae43ae5ff9ddfc53c9f04a9c27]
         source-hash-d07f0997c54e9cef31d996ebeb2aabfb4b4e0265
    git bisect bad 8dd6442885c969ae43ae5ff9ddfc53c9f04a9c27
    # bad: [0c544096152075c642ed598111cb02e8b74161ee]
         source-hash-1ac3ad7743c7c98b83f7a8a4c3e03a83721b46b9
    git bisect bad 0c544096152075c642ed598111cb02e8b74161ee
    # bad: [80f9488222ce032799b51c38d9efb7d6e9d98fc4]
         source-hash-68d87e98951ae3ed5f7b863954667bfdd9805985
    git bisect bad 80f9488222ce032799b51c38d9efb7d6e9d98fc4
    # bad: [32ca531be8281e56479e9efd9ea831c0af47f02a]
         source-hash-217c09adcc3a73ee2c9e49e00af240195da63bc6
    git bisect bad 32ca531be8281e56479e9efd9ea831c0af47f02a
    # bad: [10b1fe22b0cf3cce25551ad0aae5ee0844b3e6e9]
         source-hash-9de415945a608b8b90b648e04ad06bac2d53a9cd
    git bisect bad 10b1fe22b0cf3cce25551ad0aae5ee0844b3e6e9
    # bad: [6b9ba7e0ca5081e9de5d6fc289ee374141e019d7]
         source-hash-564fe23374fa544c34875da0dd695cb8a939f0f2
    git bisect bad 6b9ba7e0ca5081e9de5d6fc289ee374141e019d7
    # good: [9cdf40c9081931c9b1a4a7a611ec90a8c198c3a0]
         source-hash-84a7fa47a548e95892797e9f61d96ae051123121
    git bisect good 9cdf40c9081931c9b1a4a7a611ec90a8c198c3a0
    # bad: [6dbe7829ae2e823eb13343da435867b5c10b104d]
         source-hash-573f5dfba805b733dd2da62bde3cd5d9d25879d9
    git bisect bad 6dbe7829ae2e823eb13343da435867b5c10b104d
    # good: [f35ce73a6b4ebbd2ef6d43870c0b2fc971520a41]
         source-hash-87561f10ba76de6d5453ed906ce24a052df72f18
    git bisect good f35ce73a6b4ebbd2ef6d43870c0b2fc971520a41
    # first bad commit: [6dbe7829ae2e823eb13343da435867b5c10b104d]
         source-hash-573f5dfba805b733dd2da62bde3cd5d9d25879d9
Comment 4 Markus Mohrhard 2016-03-26 18:12:44 UTC 
Most likely the worst parts have been fixed with the changes for Bug 95437.
Comment 5 Markus Mohrhard 2016-03-26 22:29:20 UTC 
Yeap. Conditional format code does not show up in the profile any more during import.
Comment 6 Markus Mohrhard 2016-04-08 08:51:13 UTC 

*** This bug has been marked as a duplicate of bug 95437 ***