Export Cross table to Excel with Color

[Venkatesh s]

Currently I am using Spotfire 10. I am having issue while using Export to Excel Option.

I have a cross table having Columns A, B, C. C is nothing but A/B. I have applied the color code to C using segments option. All the color code works perfectly in spotfire.

But When I export the cross table using Export Excel option and Select the option Export coloring. The color code gets applied to A,B & C in excel with the segments range given for C.

I tried all the option, recreated the visualization, but nothing working out. Having color code to A& B gives the wrong perception to data. Please let me know if anyone face this issue.

Any Solution for this issue or what I am doing wrong

 

Thanks

Venkatesh

[Shashank Gurnalkar]

What exact option are you using Would you be able to share a screenshot