To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108531 Issue #|108531 Summary|Spreadsheet containing lots of VLOOKUP which reference |s nonexisting file freezes Component|Spreadsheet Version|OOo 3.1.1 Platform|Opteron/x86_64 URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|save-export Assigned to|spreadsheet Reported by|slipset
------- Additional comments from [email protected] Thu Jan 21 09:19:27 +0000 2010 ------- Receiving an Excel spreadsheet (.xls) with about 700 rows containing one column with VLOOKUP towards cells in another Excel spreadsheet (which is not found on my computer) Calc opens this perfectly. Editing and then trying to save as .xls makes my machine totaly unresponsive by entering a massive swap storm. I have an example spreadsheet which demonstrates this behaviour, but there seems no way to attach it here. The offending VLOOKUP looks like this: =VLOOKUP(B14,'file:///tmp/foo.xls'#$Hoved.$C$10:$AA$2487,21,0) --------------------------------------------------------------------- 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]
