To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115914 Issue #|115914 Summary|Save periodically corrupts functioning spreadsheet Component|Spreadsheet Version|OOO320m12 Platform|Other URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|save-export Assigned to|spreadsheet Reported by|billgradwohl
------- Additional comments from billgradw...@openoffice.org Sat Dec 4 00:41:10 +0000 2010 ------- I have a password protected spreadsheet (JP.ods) that gets used 12 hours a day every day. Periodically (every invoice print), a file save is performed via a macro to make sure that if anything goes wrong (power outage, machine failure, etc), we have a very recent copy on disk. In addition, I have a backup script triggered by crontab that runs every minute and copies the current disk version of this spreadsheet to a safe place and modifies its file name with a date and time stamp. I keep 20 UNIQUE versions of the most recent generations for any day, and I keep 10 days worth of generations. I throw duplicate files away. Recently, I turned the machine on in the morning, and attempted to bring up the spreadsheet that was used the previous day without incident. I keyed in the password, and a few seconds later a pop up says: Read-Error. The wrong password has been entered. Note that when I keyed in the password, it took it, and started loading the spreadsheet. After a few seconds of that process it brings up this message. If I purposely key in a wrong password, I get an instantaneous failure message and an option to try again. I am keying in the password correctly and after some processing I get the above message, and no option to try again. The spreadsheet is hosed up somehow. I tried reaching back to previous generations and discovered that all 20 copies for the previous day reacted identically. I had to reach back an additional day to find a version that was loadable. This situation has now occurred twice - on 11/27 and 12/02. From my backups, I isolated 4 files JP.ods.10114727_124421.good JP.ods.10114727_130726.bad JP.ods.10124802_084918.good JP.ods.10124802_085018.bad that are at the boundary of where things went wrong. Once the save process goes wrong, all subsequent generations are bad, so its not a disk drive problem. The problem must be inside the save mechanism in OpenOffice Calc. Note also that the failure occurs when I try to load the spreadsheet. The previous day, it was used all day long and there were no problems. The final manual save at the end of the day is the one I try to load the next morning, and its hosed up. Something in the save process takes a functioning spreadsheet and cripples it making it impossible to reload it. Each file is about 327K in size, and contains information I can't make world public. I'll provide these files including the password, to someone that can debug the failure, if anyone is interested. --------------------------------------------------------------------- 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