OWC 10 - AutoFit Pivot Table columns

R

rusty cranbrook

I don't really understand the AutoFit property. I've found that

pt.ActiveView.FieldSets(3).Fields(0).DetailAutoFit = True

will make the columns autofit on a pivot table that has a filter
field, a row field, a column field, and a detail field. I'm not sure
why the index value of 3 works - how is the index populated? I mean
how do I know what index value to hit?

Also, when I set the TitleBar.Caption value, the columns AutoFit. Why
is this?

pt.ActiveView.TitleBar.Caption = "Sigh..."
 
R

rusty cranbrook

An additional note - the AutoFit expression I posted that "works",
does not work after setting the XMLData property of the pivot table,
unless I do something else like initiate a progrmattic pause first.
How can this make sense?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Repost: AutoFit Pivot Table columns 5
autofit width doesn't work for me in macro's 1
Pivot Table AutoFit Questions 1
Retrieve member values for filters in OWC pivot table 0
Additional columns for Pivot table 0
Pivot table report invalid 0
Pivot Table Code - Is there a better way? 2
How to autofit text containing CHR(10)? 3

Top