G
garyn
I'm having a problem formatting my pivot table labels. When I apply grouping to items, I lose the formatting. The group labels and grand total revert back to Arial 10. This is my code:
<script language = "javascript">
var name = "Verdana";
var size = 8;
var v = document.PivotTable.ActiveView;
v.FieldLabelFont.Name = name;
v.FieldLabelFont.Size = size;
v.TotalFont.Name = name;
v.TotalFont.Size = size;
v.HeaderFont.Name = name;
v.HeaderFont.Size = size;
// set font name and size for all detail and subtotal fields.
for (var fs = 0; fs < v.FieldSets.Count; fs++) {
var fldSet = v.FieldSets(fs);
for (var f = 0; f < fldSet.Fields.Count; f++) {
var fld = fldSet.Fields(f);
fld.DetailFont.Name = name;
fld.DetailFont.Size = size;
fld.SubtotalFont.Name = name;
fld.SubtotalFont.Size = size;
fld.SubtotalLabelFont.Name = name;
fld.SubtotalLabelFont.Size = size;
fld.GroupedFont.Name = name;
fld.GroupedFont.Size = size;
}
}
</script>
This is in OWC 10. Any ideas?
<script language = "javascript">
var name = "Verdana";
var size = 8;
var v = document.PivotTable.ActiveView;
v.FieldLabelFont.Name = name;
v.FieldLabelFont.Size = size;
v.TotalFont.Name = name;
v.TotalFont.Size = size;
v.HeaderFont.Name = name;
v.HeaderFont.Size = size;
// set font name and size for all detail and subtotal fields.
for (var fs = 0; fs < v.FieldSets.Count; fs++) {
var fldSet = v.FieldSets(fs);
for (var f = 0; f < fldSet.Fields.Count; f++) {
var fld = fldSet.Fields(f);
fld.DetailFont.Name = name;
fld.DetailFont.Size = size;
fld.SubtotalFont.Name = name;
fld.SubtotalFont.Size = size;
fld.SubtotalLabelFont.Name = name;
fld.SubtotalLabelFont.Size = size;
fld.GroupedFont.Name = name;
fld.GroupedFont.Size = size;
}
}
</script>
This is in OWC 10. Any ideas?