Recently I had a need to look at some spreadsheets from a Windows CD. I had OpenOffice 2.4.1 set up as the default for .xls files on Windows. When I looked at the spreadsheets I was interested in their macros. My coworker was surprised that I could view the macros under OO.o since the worksheet was protected under Excel. So, I saved the worksheets in .ods format so I could view them in Linux as well as Windows. The macros have some incompatibility issues with Open Office, which is understandable, and certainly not my complaint. Out of curiosity I saved the spreadsheets in Excel .xls format, but Excel (2003 Windows XP) reported "unreadable content" and the damage was not repairable. What I wanted to see if Open Office actually removed the protection so that my coworkers could use excel to view the macro code. Note that OpenOffice can open both the .ods and the .xls file it produced. (Actually GNUmeric does not have a problem reading it :-)
The upside of this is if they want to view the macro code, they must upgrade to Open Office. But, I don't understand why the OO.o generated .xls is so corrupted from an Excel point of view. The additional question is should OpenOffice preserve any protection that exists on an Excel spreadsheet? -- -- Jerry Feldman <[EMAIL PROTECTED]> Boston Linux and Unix PGP key id: 537C5846 PGP Key fingerprint: 3D1B 8377 A3C0 A5F2 ECBB CA3B 4607 4319 537C 5846 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
