Interesting. Actually a reverse Easter egg would be very cool to see. A Yolk on the outside with egg white in the middle. That could be very interesting to people that like the yolk better then the white. You may be on to something here. :)
-----Original Message----- From: Lum, David [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 4:24 PM To: NT 2000 Discussions Subject: [OT] reverse Excel Easter egg (kind of) We have someone here who does a lot of data mining, which includes output to a .CSV file that is later opened in Excel. Under some conditions Excel would generate an error opening the file, yet it was possible to open this file in Notepad and nothing looked amiss. This person is quite good at complex Excel macro/VB functions. They tried different PC's (and Excel versions) to determine it wasn't an Excel issue and that it was the file itself causing problems (as well as a gazillion other ideas). If you have Excel, open Notepad type IDIOT (in capitals), save it as .CSV and open with Excel. Dimes to dollars you get a "SYLK: file format is not valid" message. Now make it a lower case idiot. Save, then open with Excel. It will open fine. Excel obviously takes exception to "ID" in caps as the first two characters of a file. The beginning of our .CSV file looked like this: ID,Name,Variable .... Kind of weird, but is it a bug or is it a feature? At some level I can understand a program looking for "ID" at the beginning of a file, but I'd think it wouldn't be too uncommon for ID to be the first column in a data table. Dave Lum - [EMAIL PROTECTED] Sr. Network Specialist - Textron Financial 503-675-5510 ------ You are subscribed as [EMAIL PROTECTED] Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe send a blank email to %%email.unsub%% *****This email and any files transmitted with it are confidential and intended solely for the use of the addressee. If you have received this email in error please notify [EMAIL PROTECTED] Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of Stainsafe Inc. or any of its subsidiaries or affiliates. The company accepts no liability for any damage caused by any virus transmitted by this email.***** ------ You are subscribed as [email protected] Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe send a blank email to [EMAIL PROTECTED]
