internal SLPivotAreaReference Clone() { var par = new SLPivotAreaReference(); par.Field = Field; par.Selected = Selected; par.ByPosition = ByPosition; par.Relative = Relative; par.DefaultSubtotal = DefaultSubtotal; par.SumSubtotal = SumSubtotal; par.CountASubtotal = CountASubtotal; par.AverageSubtotal = AverageSubtotal; par.MaxSubtotal = MaxSubtotal; par.MinSubtotal = MinSubtotal; par.ApplyProductInSubtotal = ApplyProductInSubtotal; par.CountSubtotal = CountSubtotal; par.ApplyStandardDeviationInSubtotal = ApplyStandardDeviationInSubtotal; par.ApplyStandardDeviationPInSubtotal = ApplyStandardDeviationPInSubtotal; par.ApplyVarianceInSubtotal = ApplyVarianceInSubtotal; par.ApplyVariancePInSubtotal = ApplyVariancePInSubtotal; par.FieldItems = new List <uint>(); foreach (var i in FieldItems) { par.FieldItems.Add(i); } return(par); }
internal void FromPivotArea(PivotArea pa) { SetAllNull(); if (pa.Field != null) { Field = pa.Field.Value; } if (pa.Type != null) { Type = pa.Type.Value; } if (pa.DataOnly != null) { DataOnly = pa.DataOnly.Value; } if (pa.LabelOnly != null) { LabelOnly = pa.LabelOnly.Value; } if (pa.GrandRow != null) { GrandRow = pa.GrandRow.Value; } if (pa.GrandColumn != null) { GrandColumn = pa.GrandColumn.Value; } if (pa.CacheIndex != null) { CacheIndex = pa.CacheIndex.Value; } if (pa.Outline != null) { Outline = pa.Outline.Value; } if (pa.Offset != null) { Offset = pa.Offset.Value; } if (pa.CollapsedLevelsAreSubtotals != null) { CollapsedLevelsAreSubtotals = pa.CollapsedLevelsAreSubtotals.Value; } if (pa.Axis != null) { Axis = pa.Axis.Value; } if (pa.FieldPosition != null) { FieldPosition = pa.FieldPosition.Value; } SLPivotAreaReference par; using (var oxr = OpenXmlReader.Create(pa)) { while (oxr.Read()) { if (oxr.ElementType == typeof(PivotAreaReference)) { par = new SLPivotAreaReference(); par.FromPivotAreaReference((PivotAreaReference)oxr.LoadCurrentElement()); PivotAreaReferences.Add(par); } } } }