private void BuildFormatting(PivotTag pivot, DataPivotTag tag, IXLPivotValue pf) { if (pivot.HasParameter("NoPreserveFormatting") && pivot.HasParameter("CaptionNoFormatting")) { var fmtRange = tag.Cell; } // TODO pivot value formatting /* * ' If (Args(14) = True) And (Args(17) = True) Then' + vbCR + * ' On Error Resume Next' + vbCR + * ' For i = 1 To DataFieldsCount' + vbCR + * ' V = Datas(i)' + vbCR + * ' Set PF = PT.DataFields(i)' + vbCR + // V(2) & " ")' + vbCR + * ' Set FmtRange = SrcRange.Cells(2, V(1) - 1)' + vbCR + * ' If PF.DataType <> xlText Then' + vbCR + * ' PF.NumberFormat = FmtRange.NumberFormat' + vbCR + * ' End If' + vbCR + * ' PF.DataRange.Interior.ColorIndex = FmtRange.Interior.ColorIndex' + vbCR + * ' PF.DataRange.Font.Name = FmtRange.Font.Name' + vbCR + * ' PF.DataRange.Font.Color = FmtRange.Font.Color' + vbCR + * ' PF.DataRange.Font.Size = FmtRange.Font.Size' + vbCR + * ' PF.DataRange.Font.FontStyle = FmtRange.Font.FontStyle' + vbCR + * ' PF.DataRange.HorizontalAlignment = FmtRange.HorizontalAlignment' + vbCR + * ' PF.DataRange.VerticalAlignment = FmtRange.VerticalAlignment' + vbCR + * ' If Args(17) = True Then' + vbCR + * ' Set CaptionRange = SrcRange.Cells(1, V(1) - 1)' + vbCR + * ' PF.LabelRange.Interior.ColorIndex = CaptionRange.Interior.ColorIndex' + vbCR + * ' PF.LabelRange.Font.Name = CaptionRange.Font.Name' + vbCR + * ' PF.LabelRange.Font.Color = CaptionRange.Font.Color' + vbCR + * ' PF.LabelRange.Font.Size = CaptionRange.Font.Size' + vbCR + * ' PF.LabelRange.Font.FontStyle = CaptionRange.Font.FontStyle' + vbCR + * ' PF.LabelRange.HorizontalAlignment = CaptionRange.HorizontalAlignment' + vbCR + * ' PF.LabelRange.VerticalAlignment = CaptionRange.VerticalAlignment' + vbCR + * ' End If' + vbCR + * ' Next' + vbCR + * ' End If' + vbCR + */ }
public IXLPivotValueStyleFormat ForValueField(IXLPivotValue valueField) { FieldReferences.Add(new PivotValueFieldReference(valueField.SourceName)); return(this); }
public Int32 IndexOf(IXLPivotValue pivotValue) { return(IndexOf(pivotValue.SourceName)); }
public Boolean Contains(IXLPivotValue pivotValue) { return(_pivotValues.ContainsKey(pivotValue.SourceName)); }
public XLPivotValueCombination(IXLPivotValue pivotValue) { _pivotValue = pivotValue; }