To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103424 Issue #|103424 Summary|Calc: Background AutoRecovery freezes Calc, making it |unusable Component|Spreadsheet Version|DEV300m49 Platform|PC URL| OS/Version|Windows 2000 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P1 Subcomponent|save-export Assigned to|spreadsheet Reported by|discoleo
------- Additional comments from [email protected] Wed Jul 8 19:43:05 +0000 2009 ------- Summary: The AutoRecovery processes running in the background freezes all instances of Calc, making it unusable SETTING Open 3 real-life spreadsheets simultaneously PROBLEM Calc seuqentially saves the spreadsheets in the background. Every instance of Calc becomes unresponsive during this time, blocking every work. EXPLANATION Each SAVE operation takes 1-2 minutes on a real-life, decent spreadsheet, but even 10 seconds would be highly disruptive. Unfortunately, all instances of Calc are affected, so when the first instance begins the SAVE operation, all instances are unresponsive for 1-2 minutes. The same issue happens 5 minutes later, and again 5 minutes later. In summary, Calc will save every few minutes one of the open spreadsheets. During this time, all Calc instances are unresponsive. Anyone working in a commercial setting with real-life spreadsheets will be completely hindered to work with Calc. SOLUTION [in NO particular order] 1. Make each Calc instance run in a separate process, without inter-process lock 2. Make Calc responsive during background AutoRecovery save operations 3. Make the SAVE operation much faster, virtually save data instantly [from a user perspective] PERSONAL Unfortunately, this error is a critical one. I wasn't as much aware of this problem when working at home on insignificant tasks. MS Office 2007 is used in the commercial setting and has completely replaced any other Office suite. Trying to do the same work using OOo revealed this critical error. basically, OOo is unsuitable in a commercial setting, unless this error is fixed. PRIORITY I struggled to set the correct priority. While some may argue that this should be less than priority one (but at least P2), I considered that P2 is too weak to accurately describe the relevance of this issue. Actually, this issue completely removes OOo from the list of applications suitable for a large segment of commercial uses. I would suggest, this is a very severe issue. Maybe no one complained, because MS Office is the norm in these settings, and this is likely to stay like this as long as OOo doesn't become competitive in this setting. All potential advantages (mathematical accuracy, standardization, advanced features) are completely useless, if you cannot work. And you cannot work, believe me, I have tried, because I am still a staunch supporter of OOo. --------------------------------------------------------------------- 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]
