Issue 111037 - An example of XLS/ODS file which slows down OOo
Summary: An example of XLS/ODS file which slows down OOo
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.2
Hardware: Unknown All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on: 109276
  Show dependency tree
Reported: 2010-04-21 11:10 UTC by hiddenman
Modified: 2019-06-04 01:06 UTC (History)
4 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.1.6
Developer Difficulty: ---

An example of ODS file which slows down OOo (139.34 KB, application/vnd.oasis.opendocument.spreadsheet)
2010-04-21 11:11 UTC, hiddenman
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description hiddenman 2010-04-21 11:10:22 UTC

In the attachement you can find an example of ODS file (it was exported from XLS
which had exactly the same problem) that slows down openoffice.  Just try to
delete a column or select all text and do something with formatting etc. OOo
will think for minutes after each action.

Google Docs edits this file without any problem.

Thank you.
Comment 1 hiddenman 2010-04-21 11:11:49 UTC
Created attachment 69020 [details]
An example of ODS file which slows down OOo
Comment 2 Regina Henschel 2010-04-21 22:49:59 UTC
I can confirm the defect with DEV300m76 on WinXp. If I enter something first
time, OOo sleeps for 5 seconds. It reacts normally to further actions.
Comment 3 hiddenman 2010-04-21 22:53:20 UTC
Regina, do you mean you don't have any problems with file after first sleep?
Can you delete the column A, for example, without any sleep/slowness?
Comment 4 Regina Henschel 2010-04-21 23:13:50 UTC
You are right, deleting columns is still slow. Editing of cells is normal. For
me it looks like the comments are reason for the slowness. If you remove the
comments, the reaction seems to be normal. To remove all comments, cut the whole
area and paste it with "paste special", where you check all but "notes".
Comment 5 Regina Henschel 2010-04-21 23:20:24 UTC
Seems to be the same as issue 109276 and issue 102716.
Comment 6 hiddenman 2010-04-21 23:33:40 UTC
It seems that you are right. Pasting without comments solves the problem.
Btw, as far as i can see, there was no reaction/solution for the tickets you
mentioned. So i suppose mine will have the same status? :-)
Comment 7 Rainer Bielefeld 2010-05-10 16:25:24 UTC
Issue 111390 seems to be concerning the same or at least a similar problem.

Insert a new line 9 takes:

0,5s  with "2.4.1  Multilingual version German UI WIN XP: [680m17(Build9310)]"

10s with "Ooo 3.1.1 WIN XP DE[OOO310m19 (Build 9420)]"

15s with "Ooo-Dev 3.2.1 multilingual version English UI WIN XP: [OOO320m16
(Build 9497)] (only 10s with unhidden comments)

So it seems that the problem is not so heavy as with LINUX, but also visible.

My opinion: these all are DUPs of Issue 109276
Comment 8 Rainer Bielefeld 2010-05-10 16:47:38 UTC
Sorry, wrong OS
Comment 9 b. 2019-06-03 21:12:26 UTC
retested this bug today with AOO416m1(Build:9790)  -  Rev. 1844436
2018-10-23 12:57 under win7 pro (x64) SP1, still an issue, pls. see add. comments in #128121, could somebody pls. recheck and raise priority? 
see also #109276