0 Replies Latest reply: Feb 17, 2010 10:17 AM by Helle Knudsen RSS

Number formatting scorecard and spreadsheet component

Helle Knudsen
Currently Being Moderated

Hi,

 

In Xcelsius SP3 I have a problem getting the right number formatting for the values.Using the 'spreadsheet' component the number formatting from Excel is not transferred to the spreadsheet component:

 

Data in Excel formatted with 1000 seperator and 0 decimals is shown without 1000 seperator and with 1 decimal.

 

Data in Excel formatted wthout 1000 seperator and 1 decimal is shown with 3 decimals.

 

If removing the 1000 seperator in Excel, the values with 0 decimals is shown correct, but the figures with 1 decimal is shown without decimals.

 

If using the 'scorecard' component the number formatting is identical for the whole column (mix of KPis with different number formatting), so it is not possible to have e.g. KPIs with 1000 seperator and 0 decimals in the same column ad KPIs with 1 decimal.

 

Any advice is highly appreciated.

 

Best regards

Helle

Actions