backcolor to PivotAggregate Cell

[marco]

Hi,

I'm still confused in how to set backcolor to the cell for pivot aggregate
object. I was reviewing the drillthrough and cell coloring samples that
comes with the Office XP Toolpack but I can't resolved my issue.

I need to set the individual cells with diferent backcolor at
pivotaggregate level. Is it that possible?

Best Regards!
Ace73

 

[Alvin Bruney - ASP.NET MVP]

You'll need to obtain a reference to the axis in question and iterate it.
Then set the color property. Or you can use an appropriate color formatter
inside a number format - there are a lot of options to do just what you
require. If you are not sure how to iterate the axis, google this newsgroup
for sample code -there's plenty.

--
Warm Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley 2006
Blog: http://msmvps.com/blogs/Alvin/

 

[marco]

Alvin,

Thanks for your reply, I was looking how to iteract the pivot aggregates
cells and now can extract the values for each one, but when i tried to set
the background color and is send me a runtime error: Object doesn't support
this property or method ...

Here is my code ------------------------------------------

Dim crm
Dim ccm
Dim cell
For Each crm In data.RowMembers("VIS").ChildMembers
Set ccm = data.ColumnMembers("Acum").ChildMembers("LCC")
Set cell = data.Cells(crm, ccm).Aggregates(0)

With cell
' .backolor = "rgb(255,0,0)"
.Interior.Color = "vbRed"
End With
Next

----------------------------------------------------------

I tried with backcolor and Interior color properties but both doesn't work!


Is there something that I'm missing?

Best Regards!
Ace73

 

[Alvin Bruney - ASP.NET MVP]

not sure if this is a typo or you realize that backcolor has been
mis-spelled in your with clause

 

[marco]

Hi Alvin,

Misspelling was corrected and i still having problems to set the backcolor.
Please check the following thread:

http://www.ureader.com/message/3475786.aspx

Best Regards!
Ace73

 

[Alvin Bruney - ASP.NET MVP]

A list of the supported properties is available in the OWC pivot table help
documentation.