Bug 84393 - FILEOPEN: calc hangs opening large text file
Summary: FILEOPEN: calc hangs opening large text file
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.3.2.2 release
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
: 86489 (view as bug list)
Depends on:
Blocks:
 
Reported: 2014-09-27 09:57 UTC by Burak Ural
Modified: 2014-11-23 11:15 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
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 Burak Ural 2014-09-27 09:57:13 UTC 
Problem description: 
I have a linux configuration file (named.conf) with 16000 lines of short texts.
When I try to open the file with calc, it hangs and consumes cpu.

Steps to reproduce:
1. Have a text file with 16000 lines of text.
2. Right click file, select open with Libreoffice Calc.

Current behavior:
Calc hangs and begans to consume cpu.

Expected behavior:
Opening the file normally with a text filter.
              
Operating System: Windows XP
Version: 4.3.2.2 release
Comment 1 Luuk 2014-09-27 10:58:43 UTC 
I created a textfile with 16000 lines, and have no problem opening this file in Calc. I'm running Windows7

Can you give a more detaild explanation on what you consider 'short texts'?
Maybe some (10 lines) examples?

What is the size of the file?
Comment 2 Burak Ural 2014-09-27 21:18:31 UTC 
This happens on xp, I just tried the same file on different pc with windows 7 , it opened very fast. 2 seconds.

I waited on xp , and it opened as well but taking 67 seconds.

The xp pc cpu is AMD Athlon 64 X2 Dual Core TK-55 1.80
I also see that until the text filter dialog box comes, it takes all processing power of one core.

The file has zone and domain definitions, it is in ansi , unix format.
It is 972 KB (995613 bytes)
Each line has approx 64 characters a few more or less.
Comment 3 Luuk 2014-09-28 13:56:05 UTC 
Try deleting (or renaming) your user profile
(https://wiki.documentfoundation.org/UserProfile)
Comment 4 Burak Ural 2014-09-28 14:17:59 UTC 
I deleted the profile and it worked , what is causing this?
Comment 5 Luuk 2014-09-28 16:01:13 UTC 
The answer was deleted during deletion of you old profile.... 

But if your problem is solved, you should change the status of this bug
Comment 6 Jean-Baptiste Faure 2014-09-28 17:26:55 UTC 
Due to comment #4 set status to WorksForMe because we don't know which commit fixed the problem.

Best regards. JBF
Comment 7 bugreport 2014-11-23 11:15:17 UTC 
*** Bug 86489 has been marked as a duplicate of this bug. ***