To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=40758 Issue #:|40758 Summary:|Extremely slow to open and save moderate-size |spreadsheet with internal hyperlinks Component:|Spreadsheet Version:|OOo 1.1.1 Platform:|PC URL:| OS/Version:|Linux Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P2 Subcomponent:|code Assigned to:|spreadsheet Reported by:|kimvette
------- Additional comments from [EMAIL PROTECTED] Sun Jan 16 16:37:56 -0800 2005 ------- I have an excel spreadsheet consisting of three worksheets - two have data, the third is empty (two populated spreadsheets). Each field in each record is linked to another record in the other worksheet. The size of the spreadsheet is not large; I'd consider it to be barely moderate-size (1130 lines and 20 columns in one sheet, 5,268 lines and 9 columns in the second, and about 10 columns each sheet) This file takes only a few seconds (<5 seconds) to open in Microsoft Excel (office XP version) on Windows XP SP2 running on a dual Pentium III with 1GB RAM. On the same exact hardware, running the Linux 2.6.5-7.111.19-smp kernel, it takes well over 20 minutes to open the file, followed by roughly 22 minutes of "adapting row height" processing before I can work with the file. While waiting for the file to open, monitoring in top and/or kguard shows that this is processor-bound - not an IO issue. Both CPUs are pinned at 99%+ utilization while the file opens and formats. Total time to open the file (in M$ Excel format) was exactly 48:17.08 according to top (yes I sat there and watched it). In trying to save the file natively (.sxc) format, thinking it's the M$ Office import filter which is the problem, I find that time savings are minimal at best - _maybe_ 10% faster working in the native format. The hard drives in this box are configured for DMA, the cables are good (system test utilities report no problems), memtest86 checks out perfectly. Dual Pentium III currently clocked at 975Mhz, 1GB PC-133 RAM. (Without running OpenOffice in a a debugger) that the file opens in under 5 seconds in Office XP (including launch time for Excel) indicates to me that the hardware is fine. Note: Reason for my submitting it as a P2 Defect (if this were a commercial product I were in charge of I'd consider it a showstopping fatal P1 defect) is that nearly 50 minutes to simply open a moderate (not even large) spreadsheet when Excel can open a 55,000 line spreadsheet in under two minutes is a compelling reason for people to stick with the Windows/MS Office "monopoly." In my experience in QA and Release Engineering I considered such problems to be defects and not feature requests. Please don't take this comment personally. Developers: email me if you need the spreadsheet in question to reproduce the issue. I'm hesitant to attach it to a public defect report. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
