Current PTF Listing Page 1 Product ID . . . . . . : 2A55XL1 Excel-erator - Gumbo Software, Inc. Release . . . . . . . . : V1R4M0 As of . . . . . . . . . : 2004/11/09 Status Superseded PTF ID Description Date By ------- -------------------------------------------------- -------- ------- 1X40ALL CUMULATIVE PTF PACKAGE LAST UPDATED 2004/11/09 1X40001 BIF Broken BOF, XP Won't Open Sheet 02/24/04 1X40012 o Incorrect type value in BOF record prevents XP from opening spreadsheet. 1X40002 XL1 Preserve Trailing Zeros In Numerics 02/24/04 1X40017 o Numeric fields with decimal positions are now formatted to preserve trailing zeros. For example a two decimal position field now shows as 1.10 instead of 1.1. 1X40003 BIF Add Excel 4 Record Support 03/01/04 1X40012 o New support for BIFF4 required record types added. 1X40004 XL1 Update To Output BIFF4 (Excel4) Sheets 03/01/04 1X40017 o Previously, spreadsheets were generated in a variant of BIFF2 most closely resembling that generated by Excel 2.1. With this update files are generated as BIFF4 i.e. Excel 4.0. With this change, various Excel based functions are enabled. For example the formating control buttons bold, italic, underline, currency, percent, and comma now work. 1X40005 XL1 Suppress Blank *COLHDG Lines 03/05/04 1X40017 o Previously, the *COLHDG special value always generated 3 rows of column heading even if one or more rows were blank for all fields. Entirely blank heading rows are now suppressed. 1X40006 BIF Formats Not Properly Translated 03/15/04 1X40012 o Formats not properly translated for ccsid other than 37 resulting in Excel warnings about missing data. 1X40007 XL1 Extended Font Support 03/17/04 1X40017 o Added processing for extended font support. 1X40008 XL1 CPYTOEXCEL Add Extended Font Support 03/15/04 1X40013 o Added FONT() parameter to CPYTOEXCEL command. It allows you to specify the font used in the generated spreadsheet. o Added the following special values to the COLHDG() parameter: *ALIASBLD - Same as *ALIAS but using bold *FLDNAMBLD - Same as *FLDNAM but using bold Current PTF Listing Page 2 Product ID . . . . . . : 2A55XL1 Excel-erator - Gumbo Software, Inc. Release . . . . . . . . : V1R4M0 As of . . . . . . . . . : 2004/11/09 Status Superseded PTF ID Description Date By ------- -------------------------------------------------- -------- ------- *COLHDGBLD - Same as *COLHDG but using bold 1X40009 XL1 SNDFEXCEL Add Extended Font Support 03/15/04 1X40014 o Added FONT() parameter to SNDFEXCEL command. It allows you to specify the font used in the generated spreadsheet. o Added the following special values to the COLHDG() parameter: *ALIASBLD - Same as *ALIAS but using bold *FLDNAMBLD - Same as *FLDNAM but using bold *COLHDGBLD - Same as *COLHDG but using bold 1X40010 SND INCOROUT Some Email Addresses 04/13/04 1X40016 o Email address parser was mishandling domains and routes that contain seldom used but legal characters such as the underscore (_). 1X40011 XL1 Update Help Text 04/14/04 o Update help text for new parameters. 1X40012 BIF Add Support For NOTE Field 04/14/04 o Add support for NOTE field used by comments. 1X40013 XL1 CPYTOEXCEL Add Comment Support 04/14/04 o Added COMMENT() parameter to CPYTOEXCEL command. It allows you to add comments to cells in the generated spreadsheet. o Added missing FONT() prompt text. 1X40014 XL1 SNDFEXCEL Add Comment Support 04/14/04 o Added COMMENT() parameter to SNDFEXCEL command. It allows you to add comments to cells in the generated spreadsheet. o Added missing FONT() prompt text. 1X40015 XL1 Enable Comment Support 04/14/04 1X40017 o Enable new comment support. 1X40016 SND Broken Attachments With Compiler PTF 04/14/04 o IBM PTF to ILE/C compiler changed semantics of #pragma convert() introducing errors most often seen as broken e-mail attachments. 1X40017 XL1 Suppress Blank *COLHDG Lines Correction 11/09/04 o Blank *COLHDG suppression sometimes results wrong headings. * * * * * E n d O f L i s t * * * * *