Skip to Content
0
Nov 06, 2012 at 11:47 AM

Formatting currency in Excel not picked up by Xcelsius

25 Views

Hi

I have a bar chart in a dashboard (Xcelsius Enterprise 5.5.0.0, Build number 12,5,0,1388) that displays some values as currency.

I formatted the pertinent cells in Excel to currency with a £ sign, and all was fine.

However, I need to implement this dashboard for an Irish customer. Therefore, I changed the formatting in Excel to be € but for some reason, the dashboard still displays £.

I added a spreadsheet component and mapped this to the formatted cells (I just wanted to see how they looked). When I preview, the speadsheet table dispays the data as €, great!

The dashboard is still displaying £.

It's like Xcelsius i still holding the old formatting, please can someone suggest how I can work around this?

Many thanks

Eddie