Generation sometimes doesn't keep cell formatting

Bram Van den Brande

May 23, 2012 10:32 AM

Currently Being Moderated

Hey all,

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

Re: Generation sometimes doesn't keep cell formatting

Rajendra Cheraku May 23, 2012 11:23 AM (in response to Bram Van den Brande)

Currently Being Moderated

Hi,
What is the component you are using to display the data after format.
Is it Grid or Spread Sheet table ot Scorecard?
Thanks,
Raj
Report Abuse

Like (0)
- Re: Generation sometimes doesn't keep cell formatting
  
  Bram Van den Brande May 23, 2012 11:31 AM (in response to Rajendra Cheraku)
  
  Currently Being Moderated
  
  Grid
  
  Report Abuse
  
  Like (0)
  - Re: Generation sometimes doesn't keep cell formatting
    
    Bram Van den Brande May 23, 2012 1:22 PM (in response to Bram Van den Brande)
    
    Currently Being Moderated
    
    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
    
    Report Abuse
    
    Like (0)
Re: Generation sometimes doesn't keep cell formatting

Sujit Honrao May 25, 2012 8:45 AM (in response to Bram Van den Brande)

Currently Being Moderated

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.

Thanks.

Sujit Honrao
Report Abuse

Like (0)
- Re: Generation sometimes doesn't keep cell formatting
  
  Bram Van den Brande May 25, 2012 10:48 AM (in response to Sujit Honrao)
  
  Currently Being Moderated
  
  Sujit Honrao,
  
  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
  
  the weird thing is that not all comma's are changed to points, some of them are shown correctly while others show a point.
  
  this is a screen from the generated dashboard
  
  notice the points..and comma mixed
  
  Report Abuse
  
  Like (0)
  - Re: Generation sometimes doesn't keep cell formatting
    
    Rajendra Cheraku May 25, 2012 3:21 PM (in response to Bram Van den Brande)
    
    Currently Being Moderated
    
    Did you try with Spreadsheet table or List View or Scorecard?
    
    THanks,
    Raj
    
    Report Abuse
    
    Like (0)
    - Re: Generation sometimes doesn't keep cell formatting
      
      Bram Van den Brande May 29, 2012 9:55 AM (in response to Rajendra Cheraku)
      
      Currently Being Moderated
      
      Nop i haven't tried those, the spreadsheet is ugly and the weird thing is that some elements are shown correctly and some arre corrupt.
      
      I'll look into the scorecard/list view elements
      
      Thanks
      
      Report Abuse
      
      Like (0)

Go to original post