Current PTF Listing Page 1 Product ID . . . . . . : 2A55XL1 Excel-erator - Gumbo Software, Inc. Release . . . . . . . . : V1R5M0 As of . . . . . . . . . : 2005/06/08 Status Superseded PTF ID Description Date By ------- -------------------------------------------------- -------- ------- 1X50ALL Cumulative PTF Package Last Updated 2005/06/08 1X50001 XL1 SNDFEXCEL Does't Honor COLHDGFMT() 06/08/05 1X50003 o SNDFEXCEL command drops COLHDGFMT() parameter. 1X50002 XL1 Switch to 1900 Date/Edit Field Count 06/08/05 1X50003 o Biff provides for two different date formats, "1900" and "1904". Excel-erator was correctly storing dates in the 1904 format. However, Excel defaults to the 1900 format and doesn't accurately convert between the 2 during cut and paste operations. To avoid the problem, dates are now stored in the 1900 format. Excel erroneously believes that 1900 was a leap year, which it is not. Consequently, dates between 1900/01/01 and 1900/03/01 are mishandled by Excel. To avoid the problem, Excel-erator stores dates before 1900/03/01 as character literals in the generated spreadsheet. o Previously the number of fields being included in the spreadsheet was not edited. This allowed creation of invalid spread sheets with more than the Excel allowed maximum 256 columns. Now an error message is issued and the conversion terminated. 1X50003 XL1 Blank Trim Character Fields 06/08/05 o Previously character (alpha) fields were copied verbatum, including trailing blanks, to the spreadsheet cell. The fields are now blank trimmed to reduce file size and more closely resemble Excel generated spreadsheets. * * * * * E n d O f L i s t * * * * *