To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69993
------- Additional comments from ris...@openoffice.org Sun Nov 22 17:14:30 +0000 2009 ------- I have had this problem as long as I have used Openoffice on a Mac. I used NeoOffice from 1.1.2 to NeoOffice 3, then to evade this error I switched to OpenOffice Aqua and currently run OpenOffice native 3.1.1. I will state facts: 1) I use Openoffice for character sheets for gaming, work, and more. 2) I never close documents, I leave them open for weeks/months/years (never make it years.) 3) I never run out of disk space (laptop has 500 gb with 200+ gb free.) 4) I never save on a network share, local disk only. 5) I noticed the "temporary directory" in options is gone (/var/tmp/hu/huQhsjhf... and still fails if you alter the temp directory to be /var/tmp for instance.) 6) You can save in any document format other than ods or odt such as xls. 7) You can not save the document as the same name, as a different name, or on a different file system (such as a flash disk or external disk.) 8) You must have left the file open between weekly games and it rarely fails in 1 week but often fails after 2 weeks. 9) It does not depend on the file, as every document fails and all of them were created organically from scratch (no comment sheets and no comment document; in other words all documents that fail started as "create new document".) 10) I have found no work around for this problem in 5 years and all the work arounds I've seen for similar problems point to locking, disk full, and other non-issues. 11) Toggling "Save Autorecovery information" and "Use openoffice open/save dialogs" after the problem presents does not allow saving. 12) I never use macros and never have macros enabled, but I always have complex sheets with hundreds, possibly thousands of cells referencing other cells. Theorized assertions: 1) I suspect all files have at some point in their life have been through a recovery cycle due to laptop crash. 2) When the problem presents with one document, not all open documents will present the problem (in other words, I have notice that sometimes only 1 or 2 documents will fail while others that have failed in the past successfully save.) This is the sure fire way to reproduce: Open a new document. Past in a lot of text in different cells in different sheets over several weeks. Craft cells that reference other cells that reference many other cells. Modify several cells over several hours, then leave the document open for a week. Repeat the last line without saving until you decide/remember to save. Sometimes you are gifted with the power to save, often you are not. If you are unconvinced and want a copy of an offending file, I can provide one. But since every single openoffice document I've ever used in my life has exhibited the problem I strongly believe it isn't a document issue. I have been taught to save often and frequently to work around the problem, but I am human and sometimes forget to save. Even simple files with say 12 columns and 20,000 rows of data each referring the cells on the same row has exhibited the problem. I'm posting this information in 88318 also. --------------------------------------------------------------------- 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
