Skip to Content
0
Former Member
Apr 23, 2009 at 07:33 PM

Numbers and % are not looking right in Xcelsius

20 Views

Good evening,

I have Xcelsius 2008 SP1, FP3. I work in the Dutch Language with Excel 2007 and XP. Language in XP and Excel: Dutch. Language Pack Xcelsius also Dutch. Our numbers are written like: 1.234,56. (as opposed in the US: 1,234.56).

When I have a number in my spreadsheet (say 0,05, that is in % x 100% = 5%) and as I make a value field on the canvas formatted in % (%, 3 decimals in properties) on the canvas that returns: 0.005% (I guess that is meant to be 5% with 3 zeros in front with a dot). It looks strange in Xcelsius. For every decimal I add there is another zero added. I learned that decimal is behind the , (0,123 and not 123,). When I make the value field numeric it returns: 0.000 (in spreadsheet: 0,05). also strange.

Is there a solution for this.

Regards,

Dutchy