PH61064: EXCEL ADAPTER COULD NOT HANDLE LINE FEED (ALT-ENTER) IN DATA

APAR status

• Closed as program error.

Error description

• In an Microsoft Excel spreadsheet, you can have text that spans
  multiple lines by typing ALT-ENTER.  For example if you have a
  cell that you want to look like:
  
  Text Message 1
  Text Message 2
  
  In Excel itself, for that cell, you would type:  Text Message 1,
  then type the key sequence of ALT-ENTER and then type Text
  Message 2
  
  As a text file this is represented as "Text Message 1" followed
  by a Line Feed, followed by "Text Message 2"
  
  When you attempt to write this cell data to a spreadsheet using
  the Excel adapter, only the last part of the cell data, "Text
  Message 2", is written to the spreadsheet.
  

Local fix

• ITXCQ - ITX00062452
  TR / TR
  Circumvention: None
  

Problem summary

• Users Affected:
  IBM Transformation Extender users using the Excel adapter.
  
  Problem Description:
  Excel adapter could not handle Line Feed in data.
  
  Platforms Affected:
  All
  

Problem conclusion

• Problem Conclusion:
  Excel adapter now handles Line Feed in data.
  
  Applies to:
  10.1.1.1, 10.1.2.1, 11.0.0.0
  
  Fixed in the next service packs and releases.
  
  To obtain the fix for this APAR:
  
  To see if the next fix pack or product release is available,
  check the IBM Transformation Extender product Release Notes
  page:
  https://www.ibm.com/support/pages/node/318755
  
  If a fix pack release is available, download it from Fix
  Central:
  http://www.ibm.com/support/fixcentral/
  
  If a new product release is available, download it from Passport
  Advantage:
  https://www.ibm.com/software/passportadvantage/pao_customer.html
  
  
  If the fix pack or product release is not available and you
  require the APAR fix immediately, request a Limited Availability
  Interim Fix (LAIF) by opening a support Case:
  https://www.ibm.com/mysupport
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  ITX

• Fixed component ID

  5724Q2300

Applicable component levels