Alignment Problem - for Thao Moua

[Trevor]

I am experiencing a very frustrating problem related to the alignment of the caption for totals on my pivot table using OWC 10

I have swopped my totals to appear as rows using the following cod

// Set Total Orientatio
l_oView.TotalOrientation = c_sPivotTableConstants.plTotalOrientationRow

This makes all the captions centred which does not look so great. So I want to left align the captions with the following code

// Left Align Totals in Dat
for (j = 0; j < l_oView.DataAxis.Totals.Count; j++)
l_oView.DataAxis.Totals(j).CaptionHAlignment = c_sPivotTableConstants.plHAlignLeft


and nothing happens. Funny enough if I use the following code to align the total itself (not the caption)

// Left Align Totals in Dat
for (j = 0; j < l_oView.DataAxis.Totals.Count; j++)
l_oView.DataAxis.Totals(j).HAlignment = c_sPivotTableConstants.plHAlignLeft


it works

Thanks