Problem with CaptionHAlignment

T

Trevor

Hi anybod

I am very frustrated. I am trying to left align my totals in a pivot table using OWC DOM.

Why does this code work (to left align the numbers

for (j = 0; j < l_oView.DataAxis.Totals.Count; j++)
l_oView.DataAxis.Totals(j).HAlignment = c_sPivotTableConstants.plHAlignLeft


and this one does nothing (to left align the captions

for (j = 0; j < l_oView.DataAxis.Totals.Count; j++)
l_oView.DataAxis.Totals(j).CaptionHAlignment = c_sPivotTableConstants.plHAlignLeft
 

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

Alignment Problem - for Thao Moua 0
#VALUE error-- some cells? 3
pivot table column order 0
Subform in Report is blank 1
Error '3061' 2
Automating Excel from Word - How to Sort a Range of Cells 6
"Folder does not contain contacts" in Microsoft Outlook 0
"Folder does not contain contacts" in Microsoft Outlook 1

Top