HD76716: KWE: DESIGN TABLE DOES NOT LOAD EXCEL FILE IF FILE IS PROTECTED SHEET AND THERE ARE SOME COLUMNS HIDDEN.

APAR status

• Closed as program error.

Error description

• KWE: Design Table does not load Excel file if file is
  Protected sheet and there are some columns
  hidden.
  THE PROBLEM WAS REPORTED ON V5R18SP05.
  THE PROBLEM IS REPRODUCIBLE ON CXR19
  (07/30/2008)
  .
  Scenario:
  1. Launch CATIA.
  2. Select "Tools" > "Options" from menu bar.
  =>"Option" dialog box is displayed.
  3. Select "Part Infrastructure" on the tree.
  Select "Display" tab.
  4. Activate "Parameters" and "Relations".
  Click "OK".
  5. Start "Microsoft Excel" and open attached
  file: "DesignTable1.xls".
  6. Select rows 1, 2, 3 and Hide them through
  contextual menu.
  7. Select "Tools" > "Protection" > "Sheet
  protection" by menu bar on Excel file.
  =>"Protection of sheet" dialog box is displayed.
  8. Click "OK". And Save the excel file.
  9. Open the file : "D00481.CATPart".
  Workbench : "Knowledge Advisor".
  10. Expand "Relations" node fro spec tree. Then
  Design Table.1/ Configuration.
  11. Double click on Configuration =>"Edit
  Parameter" dialog box is displayed.
  12. Click "Open a dialog that allows you to change
  driving design table configuration" button.
  =>"DesignTable.1 configuration" dialog box is
  displayed.
  =>The data of "Excel" was loaded. This is a correct
  behavior.
  13. Say Cancel and close this "CATPart" file without
  save.
  14. Activate "Excel" window. Select "Tools"
  > "Protection" > "Release of sheet protection" from
  menu bar.
  15. Select all cells. Click "Format" > "Lines" > "Re-
  display" from menu bar.
  =>"Excel" data gets reset.
  16. Multi-select columns from "A" to "I". Click the
  selected column by MB3.
  17. Select Hide from contextual menu.=>The "A"
  to "I" columns are hidden.
  18. Select "Tools" > "Protection" > "Sheet
  protection" from menu bar.
  =>"Protection of sheet" dialog box is displayed.
  19. Click "OK". Save Excel file.
  20. Again open same CATPart. Double click on
  Design Table.1/ Configuration again.
  21. Do Double click on Configuration =>"Edit
  Parameter" dialog box is displayed.
  =>"DesignTable.1 configuration" dialog box is
  displayed.
  =>The data of "Excel" file is not loaded. This is a
  problem.
  "Design Table" does not load the data of "Excel"
  when the cell of "Excel" was hidden by column and
  sheet was protected. This is a problem.
  .
  

Local fix

Problem summary

• KWE: Design Table does not load Excel file if file is Protected
  sheet and there are some columns hidden.
  KWE: Design Table does not load Excel file if file is
  Protected sheet and there are some columns
  hidden.
  THE PROBLEM WAS REPORTED ON V5R18SP05.
  THE PROBLEM IS REPRODUCIBLE ON CXR19
  (07/30/2008)
  .
  Scenario:
  1. Launch CATIA.
  2. Select "Tools" > "Options" from menu bar.
  =>"Option" dialog box is displayed.
  3. Select "Part Infrastructure" on the tree.
  Select "Display" tab.
  4. Activate "Parameters" and "Relations".
  Click "OK".
  5. Start "Microsoft Excel" and open attached
  file: "DesignTable1.xls".
  6. Select rows 1, 2, 3 and Hide them through
  contextual menu.
  7. Select "Tools" > "Protection" > "Sheet
  protection" by menu bar on Excel file.
  =>"Protection of sheet" dialog box is displayed.
  8. Click "OK". And Save the excel file.
  9. Open the file : "D00481.CATPart".
  Workbench : "Knowledge Advisor".
  10. Expand "Relations" node fro spec tree. Then
  Design Table.1/ Configuration.
  11. Double click on Configuration =>"Edit
  Parameter" dialog box is displayed.
  12. Click "Open a dialog that allows you to change
  driving design table configuration" button.
  =>"DesignTable.1 configuration" dialog box is
  displayed.
  =>The data of "Excel" was loaded. This is a correct
  behavior.
  13. Say Cancel and close this "CATPart" file without
  save.
  14. Activate "Excel" window. Select "Tools"
  > "Protection" > "Release of sheet protection" from
  menu bar.
  15. Select all cells. Click "Format" > "Lines" > "Re-
  display" from menu bar.
  =>"Excel" data gets reset.
  16. Multi-select columns from "A" to "I". Click the
  selected column by MB3.
  17. Select Hide from contextual menu.=>The "A"
  to "I" columns are hidden.
  18. Select "Tools" > "Protection" > "Sheet
  protection" from menu bar.
  =>"Protection of sheet" dialog box is displayed.
  19. Click "OK". Save Excel file.
  20. Again open same CATPart. Double click on
  Design Table.1/ Configuration again.
  21. Do Double click on Configuration =>"Edit
  Parameter" dialog box is displayed.
  =>"DesignTable.1 configuration" dialog box is
  displayed.
  =>The data of "Excel" file is not loaded. This is a
  problem.
  "Design Table" does not load the data of "Excel"
  when the cell of "Excel" was hidden by column and
  sheet was protected. This is a problem.
  .
  

Problem conclusion

• THIS PROBLEM WILL BE FIXED ON CATIA VERSION
  5 RELEASE 20 GA LEVEL.
  AND ON V5R19SP04 LEVEL
  Incident diagnosis:
  KWE: Design Table does not load Excel file if file is
  Protected sheet and there are some columns
  hidden.
  .
  Correction explanation:
  Algorithm modified to get expected behavior.
  .
  .
  

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