HD82741: PS: BOM EXPORTED AS XLS CORRUPTS THE NAMES OF CERTAIN PARTS

APAR status

• Closed as program error.

Error description

• PS: BOM exported as xls corrupts the names of
  certain parts
  .
  SCENARIO:
  0. Start CATIA
  1. Open a new CATProduct
  2. Insert a new CATPart and name it 1/4-20 (Part
  Number attribute)
  3. Go to Analyze - Bill of Material
  4. Click Save As, and choose file type Microsoft
  Excel worksheet (*.xls) and save
  5. Open the Excel spreadsheet and view the results
  .
  PROBLEM:
  Excel recognizes the part number as a date, and
  automatically changes the format. (1/4-20 changes
  to 1/4/2020).
  .
  

Local fix

Problem summary

• PS: BOM exported as xls corrupts the names of certain parts
  PS: BOM exported as xls corrupts the names of
  certain parts
  .
  SCENARIO:
  0. Start CATIA
  1. Open a new CATProduct
  2. Insert a new CATPart and name it 1/4-20 (Part
  Number attribute)
  3. Go to Analyze - Bill of Material
  4. Click Save As, and choose file type Microsoft
  Excel worksheet (*.xls) and save
  5. Open the Excel spreadsheet and view the results
  .
  PROBLEM:
  Excel recognizes the part number as a date, and
  automatically changes the format. (1/4-20 changes
  to 1/4/2020).
  .
  

Problem conclusion

• THIS PROBLEM WILL BE FIXED ON CATIA VERSION
  5 RELEASE 20 GA LEVEL.
  Incident Diagnosis:
  BOM exported as xls corrupts the names of
  certain parts
  .
  Correction Explanation:
  Problem corrected - Force the cell format
  to 'String'. The part that was created displays the
  same name as what is in CATIA.
  .
  

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

  CATIA V5 NT>XP

• Fixed component ID

  569151000

Applicable component levels

• R519 PSN

     UP