internal void FromConditionalFormat(ConditionalFormat cf)
{
SetAllNull();
if (cf.Scope != null)
{
Scope = cf.Scope.Value;
}
if (cf.Type != null)
{
Type = cf.Type.Value;
}
if (cf.Priority != null)
{
Priority = cf.Priority.Value;
}
SLPivotArea pa;
using (var oxr = OpenXmlReader.Create(cf))
{
while (oxr.Read())
{
if (oxr.ElementType == typeof(PivotArea))
{
pa = new SLPivotArea();
pa.FromPivotArea((PivotArea)oxr.LoadCurrentElement());
PivotAreas.Add(pa);
}
}
}
}
internal SLPivotArea Clone()
{
var pa = new SLPivotArea();
pa.Field = Field;
pa.Type = Type;
pa.DataOnly = DataOnly;
pa.LabelOnly = LabelOnly;
pa.GrandRow = GrandRow;
pa.GrandColumn = GrandColumn;
pa.CacheIndex = CacheIndex;
pa.Outline = Outline;
pa.Offset = Offset;
pa.CollapsedLevelsAreSubtotals = CollapsedLevelsAreSubtotals;
pa.Axis = Axis;
pa.FieldPosition = FieldPosition;
pa.PivotAreaReferences = new List <SLPivotAreaReference>();
foreach (var par in PivotAreaReferences)
{
pa.PivotAreaReferences.Add(par.Clone());
}
return(pa);
}
private void SetAllNull()
{
PivotArea = new SLPivotArea();
Chart = 0;
Format = 0;
Series = false;
}
private void SetAllNull()
{
PivotArea = new SLPivotArea();
Field = null;
Formula = "";
}
private void SetAllNull()
{
PivotArea = new SLPivotArea();
Action = FormatActionValues.Formatting;
FormatId = null;
}
private void SetAllNull()
{
PivotArea = new SLPivotArea();
}
