KB‎ > ‎

Excel Mixed Data handling inconsistent

Defect Id: 2583042 
Last Edited: March 21st, 2013
 
Description:

In Excel, when refreshing data, Data Manager cannot import mixed data types and therefore the string values do not pull through.

  
Cause:

Some shapes store numeric values, say 'TotalCost' as string data types, and other shapes store them as numbers.

When the shapes are exported to Excel, it exports as a mixed data type (i.e. different cells in the same column have different data types).

 
Workaround:
This issue was Fixed in PN 11.2
 
Applies to:
  • Process Navigator versions Pre 11.1