Issue 126292

Summary:	Opening attached Excel file takes 3.5 HOURS!
Product:	Calc	Reporter:	Taed Wynnell <taedn>
Component:	open-import	Assignee:	AOO issues mailing list <issues>
Status:	UNCONFIRMED ---	QA Contact:
Severity:	Normal
Priority:	P5 (lowest)	CC:	oooforum, taedn
Version:	4.1.1
Target Milestone:	---
Hardware:	PC
OS:	Windows XP
URL:	https://www.dropbox.com/s/4b9zyziw622j5ir/ForgedAnvil%20D%26D%205E%20Character%20Generator%20v1.41.xlsm?dl=0
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

Description Taed Wynnell 2015-05-05 17:20:16 UTC

The attached largish Excel file takes just 5 seconds to open in Excel 2007.  It's a large file, but completely usable on my machine and I don't notice any problems or slowness with it at all.  Yes, I have macros enabled.

On the same machine, it takes 3.5 HOURS to open in OpenOffice Calc -- about 2500 times slower.  It uses one core of the CPU at nearly 100% during that time.  Once it is open, it seems fine and behaves basically equivalently to running it in Excel.

I do not know what is special about the file that makes it so slow to open.  It is a file created by someone else for people to use for creating characters in Dungeons & Dragons.

Comment 1 Taed Wynnell 2015-05-05 17:24:18 UTC

I couldn't attach the file, but it is on my DropBox at (https://www.dropbox.com/s/4b9zyziw622j5ir/ForgedAnvil%20D%26D%205E%20Character%20Generator%20v1.41.xlsm?dl=0).

Comment 2 oooforum (fr) 2015-05-06 10:30:09 UTC

I confirm that import is a very long process.
But AOO can't save in xlsm format.
So once done, you must save as ODS.
This file opens faster.