Spreadsheet probem with thousand seperator in excel

other Xcelsius - Crystal Dashboard Design
1

Hi ,

I have spread sheet table in my dashbaord , This spread sheet table is linked with a radio button having three labels buttons.
My first radio button selection contains negative values . These negative values are shown in red colour using thousand seperator in excel .
Now I clicked on second radio button , But now i dont have negative values for this selection . but still values are showing in red colour (but not in brackets ) .

Why the colour is applying for positive values also . Is there any problem with spread sheet .

Please help me out . I cannot use SCore card component as i dont have control on row height .

Many thanks in advance for reading my post .

Reagrds,
Dirasa

Dirasa :india: (BOB member since 2008-05-12)

2

Did you try using GRID component. You can use multiple GRID components and have alerts take care of your color issues. Answering you based on what i can understand you issue as, would be able to better assist you if you can explain the same with an example…

hope this helps.

boe_bods :india: (BOB member since 2008-03-14)