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;
}
public XLPivotValueCombination(IXLPivotValue pivotValue)
{
_pivotValue = pivotValue;
}
