IBM Support

DOORS export to Excel column limit

Question & Answer


Question

Is there a limit to the number of columns that can be exported to Microsoft Excel from a module in IBM Rational DOORS ?

Cause

Excel spread sheet is missing some columns after exporting a DOORS module.

Answer

The maximum number of columns is 32. This also the maximum number of columns DOORS can display in a view.

Note: Prior to DOORS 9.3 there was a limit of 25 columns when exporting directly to Excel.
To export more than 25 columns use Export to Spreadsheet using a comma-separated or tab separated data.

[{"Product":{"code":"SSKR2T","label":"IBM Engineering Requirements Management DOORS"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"General Information","Platform":[{"code":"PF033","label":"Windows"}],"Version":"9.3;9.3.0.1;9.3.0.2;9.3.0.3;9.3.0.4;9.3.0.5;9.3.0.6","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
01 May 2020

UID

swg21324618