I've been working with Xcelsius for a while now but atm i experience some very weird problems.
I have some grinds to display information. The info is a concatenation of a string and a number.
In the excel sheet I've used custom formats because i need to show + and - signs all the time.
In my development screen all the grids are filled in perfectly (+123,4 or -124,4) but when the dashboard is generated it randomly changes the comma sings , to points .
All my formats are correct before the concatenation or even before the custom format is applied , i even changed the elements to chars to make sure the concatenation uses text elements instead of numbers
Anyone any idea what is causing this or how to solve it ?
Thanks in advance
The element that is used to show the result is a grid, the weird thing is that some elements are shown correctly and others aren't. I even tried changing the properties of the grid itself.
There is no consistency in what is shown correctly and what istn't.
I've checked the different cases
If I have understood your issue correctly, then you are trying to display a set of numbers, which have comma and points in a grid. And when you preview it the commas are changing to points. Have i understood it correctly?
I tried replicating it at my end, and for me its working fine...i did'nt observe any behaviour like the one described above?
Let me know if i missed anything and i will try it again.
You understood correctly, i have a set of cells that consist op a concatenation of a string and a number (the number has a custom number format because i always want to see the sign ( positive or negative)
This is the screen in the excel part, as you can see the comma's are here
this is a screen from the generated dashboard
notice the points..and comma mixed