May 28th, 2008

More Excel Woes!

Posted at 06:41:19 PM| Permanent Link: More Excel Woes!

Although the technique "copy as table and paste into spreadsheet" works, it is limited, e.g. if the view is too wide, you can't copy it as a table (but shrinking the column widths does work). Also, graphic icons in a view don't get pasted.

An alternative thought occurred to me: Why not export the view as a Lotus 123 file, and then import it into a IBM Symphony spreadsheet. Surely two IBM products would be compatible with each other? Surely...? Not a chance! The error message is "IBM Symphony do not support this file format." (love the grammar!) Unfortunately Open Office can't import Lotus 123 spreadsheets either, and I haven't yet been able to find any filters on the web. I'll keep trying because there is a need coming up in a few weeks.

[1] More Excel Woes
Created 5/29/2008 8:05:01 AM by Palmi
(Palmi )

Chris - I hope that Symphony 1.0 is going to have support for Lotus123. MS Office 2007 (Security patch) disables the save of WK4 format.


Add Comment
 
Subject:
   
Name:
E-mail:
Web Site:
 
Comment:  (No HTML - Links will be converted if prefixed http://)
 
Remember Me?