To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=77124
                 Issue #|77124
                 Summary|Calc corrupted Excel files, can't be opened in Calc no
                        |r Excel
               Component|Spreadsheet
                 Version|OOo 2.2
                Platform|PC
                     URL|
              OS/Version|Windows Vista
                  Status|UNCONFIRMED
       Status whiteboard|
                Keywords|
              Resolution|
              Issue type|DEFECT
                Priority|P3
            Subcomponent|save-export
             Assigned to|spreadsheet
             Reported by|acastanaza





------- Additional comments from [EMAIL PROTECTED] Tue May  8 21:26:45 +0000 
2007 -------
>From 3 weeks ago, I've been working only on OOo 2.2 Calc using Excel files in 
>my
Windows Vista machine.
Sometimes I use hibernation instead of shutting down, leaving sometimes files
open  in Calc and other apps.
I was glad everything was working ok until some of my spreadsheets could not be
opened, in Calc and Excel neither.
The message in Excel was (XP and 2003 versions of excel): The format is not 
valid.
The message in Calc (2.2 and 2.0): General error: input/output error.

I looked for backups of my files: in one case, I could open my backup.  In the
other case, my backup could not be opened either, showing the same error 
message.
Another file instead of the error messaged described earlier, showed me a box
asking me to select the filter to use, and when choosing Excel 97/2000/XP it
then showed the message Unknown Excel format.
Other spreadsheets were not corrupted.

I'm sorry that I can't detail how to reproduce the problem, since I myself can't
 see what could have I done that triggered this problem.
The spreadsheets do not containg charts, links, or other advanced tools, they
just contain some formulas, cell formatting (dates, currencies, background
colors), and several sheets in each file.

Finally I could recover my files using the repair option in Excel 2003, which at
first could not repair the files, but when clicking the button "Extract data"
and then "Recover formulas" the files were recovered.  Data and formulas were
recovered, and all formatting was lost.  The repaired files where plain white,
without borders, colors, number formatting, etc.

One thing I noticed, I compared the broken files with earlier copies, and they
grew quite a bit in size, even compared with the newly repaired files saved in
Excel.

Hope this helps, and thank you.

---------------------------------------------------------------------
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]

Reply via email to