Bug 105635 - Calc stops responding for a minute when applying filter or chnging sizes of columns xlsx document
Summary: Calc stops responding for a minute when applying filter or chnging sizes of c...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.1.4.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-01-31 11:33 UTC by Aleksey
Modified: 2017-07-05 08:22 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
one of our general tables (17.25 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2017-01-31 11:33 UTC, Aleksey
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Aleksey 2017-01-31 11:33:52 UTC
Created attachment 130789 [details]
one of our general tables

Our company uses MS Office 2013 in general. When we tried to migrate several machines to LibreOffice on Linux Mint everything was fine except this issue. If we open one of our important documents, created in Excel 2013, the operations on changing size of a column or applying a filter takes too much time. 30 - 60 secs. If we save the document in "ods", it starts to work as fast as possible. We can not pass to "ods" with that documents since not all machines use calc. The newly created xlsx documents works fast.
Comment 1 Aleksey 2017-01-31 14:09:36 UTC
We think it should be usefull to solve the issue since we are not the only who wants to use open source instead of ms platform. And it seems that it is the last critical thing that stops us
Comment 2 Bartosz 2017-02-01 08:34:22 UTC
Unfortunately Unable to reproduce:
1. I opened file which you attached in LO 5.2
2. I changed the width of column 
3. I need to wait about 1-2 second, till resizing is complete. It is still better than in your case (30-60 seconds)

Could you please provide step by step instruction how to reproduce this issue?
Comment 3 Aleksey 2017-02-01 14:32:38 UTC
We did nothing special. Just opened the file with the previous release. Seems like it is the solution to upgrade our LO. 
It turn out that the file is quite old and had some issues even it was used in the MS Office. Once we fixed these issues, the normal functionality of the LibreOffice restored.
closing the topic...