Kim Streten <[EMAIL PROTECTED]> skrev den Tue, 12 Apr 2005 15:54:40 +1000:
Thanks Anthony -
The protection was on but password protected and I don't know what the password is so - I can open it OK in Excell without giving it a password but just not in OOo.
Anthony Chilco wrote:
Try the following "workaround" (I doon't know if it works and I don't have Excel installed since a few years back, so I can't verify it); it might just work:
METHOD 1
1. Open the spreadsheet document with Excel.
2. Create a new empty sheet.
3. Select the protected sheet.
4. Select everything in it, then Ctrl+C.
5. Select the new empty sheet.
6. Select everythinbg in it, or A1 only.
7. Ctrl-V.
8. Now you should have a copy of the protected sheet in an unprotected new sheet.
9. Delete the protected sheet, save the file and try to open it with OOo.
If you can't delete a protected sheet, do the following instead:
METHOD 2
1. Open the spreadsheet document with Excel.
2. Create a new empty spreadsheet document (File->New).
3. Select the first sheet of the old spreadsheet document.
4. Select everything in it, then Ctrl+C.
5. Select everything, or A1 only, in first sheet of the new spreadsheet document.
6. Ctrl-V.
7. Give the sheet the same name as in the old spreadsheet document, especially if the different sheets use data from each other.
8. Do the same with all of the other sheets.
9. Save the file. Now you should have a copy of the old spreadsheet document which you should be able to open with OOo.
If you have Excel and OOo on the same machine, it COULD be possible to copy all the data from the Excel file to an ampty OOo file.
Possible problems with the second method:
If the different sheets use data from each other, some cells might be useless since the reference cells can't be found, so some references might look like #Ref! or something like that. I can think of two possible ways to solve this problem.
1. If there is no sheet that refers to other sheets and are referred to from other sheets at the same time, just copy the different sheets in the right order.
1.1. First you copy a sheet which gets no data from other sheets.
1.2. If there are more than one of these, copy them all before you copy anything else.
1.3. Now copy a sheet which needs data from the already copied sheets only.
1.4. Goto 1.3 until all sheets are copied.
2. If all sheets needs data from each other and following steps 1-1.4 above therefor is impossible, try this:
2.1. Switch the auto calculate function off.
2.2. Follow the steps 1-8 in METHOD 2 above. Don't hit F9 (if it's associated to the Calculate function, which I think it might be)
2.3. Switch the auto calculate functiion on again.
2.4 Verify that all cells contains what you expect it to.
2.5 Save the new spreadsheet document, try to open it with OOo.
Hope this helps. I don't know if it does, but this is what I would do if it happened to me.
Johnny
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
