When you export CA Clarity PPM information to Microsoft Excel, the format settings for each column are exported to Microsoft Excel. The formulas that are used for aggregating or comparing column values are exported. You can expect certain changes in how information is displayed in Excel.
The following list describes how the various values appear in the Excel spreadsheet:
String
Hyperlinked string
If the link is an image, then the column information in Excel is the image description (alternate text).
Yes/No
Up to three columns: one for value (number), one for range description, and one narrow column with background color if stoplights are displayed. Formulas export actual values, not the formulas themselves.
Date formatting is preserved.
Two columns: numeric value and currency code. The correct number of decimal places is preserved.
Three columns: Item name, start date, and end date, in addition to a Gantt chart column header prefix to show they all belong together.
Three columns: Item name, start date, and end date, in addition to a Gantt column header prefix to show that the columns belong together. The header prefix also shows that the columns are different from the primary bar.
Three columns: Current stage name, current stage number, and number of stages, in addition to a Progress column header prefix to show that the columns belong together.
If present in CA Clarity PPM, this value appears.
Appears in a separate column; the column header title uses the attribute name.
One column for each time slice (years, months, quarters, weeks, or days). In addition, a Gantt column header prefix shows that the time slices belong together.
The values or results are displayed in rows. The values are gray and do not display a corresponding row header. Select an aggregation or comparison value to see the formula for calculating the value in the Excel formula bar.
The two highlighted rows in Excel do not appear highlighted in Excel.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|