Excel Coloring export and SP1

I currently have several formulas to change the background or text coloring
based on values in a report. All format render correctly except excel on out
put. If I have a column that changes to red when there is a negative value,
all numbers end up red in that column when exported to excel.
Is anyone else having this problem with SP1? Is there a work around or is
this a but? If it is a but is it fixed in SP2?
(I have asked users just to print to other formats but the are using the
excel data in excel)
ThanksTom,
This was an error I came across in SP1 quite some time ago, I think it
affects matrices, it was some time ago, I can't remember whether I told
Microsoft or not. We've been discouraging users from exporting to excel
which is why I haven't hit the problem again anyway.
I have SP2 Beta and will try it out for you later today. If it's an
error there I'll raise a bug log with MS.
Chris
Tom wrote:
> I currently have several formulas to change the background or text
> coloring based on values in a report. All format render correctly
> except excel on out put. If I have a column that changes to red when
> there is a negative value, all numbers end up red in that column when
> exported to excel.
> Is anyone else having this problem with SP1? Is there a work around
> or is this a but? If it is a but is it fixed in SP2?
> (I have asked users just to print to other formats but the are using
> the excel data in excel)
> Thanks|||Chris,
Any word on this if it is fixed in SP2? Is it still an open issue?
Thanks
Tom
"Chris McGuigan" wrote:
> Tom,
> This was an error I came across in SP1 quite some time ago, I think it
> affects matrices, it was some time ago, I can't remember whether I told
> Microsoft or not. We've been discouraging users from exporting to excel
> which is why I haven't hit the problem again anyway.
> I have SP2 Beta and will try it out for you later today. If it's an
> error there I'll raise a bug log with MS.
> Chris
>
> Tom wrote:
> > I currently have several formulas to change the background or text
> > coloring based on values in a report. All format render correctly
> > except excel on out put. If I have a column that changes to red when
> > there is a negative value, all numbers end up red in that column when
> > exported to excel.
> >
> > Is anyone else having this problem with SP1? Is there a work around
> > or is this a but? If it is a but is it fixed in SP2?
> >
> > (I have asked users just to print to other formats but the are using
> > the excel data in excel)
> >
> > Thanks
>