public RowItem Pivot(TickCounter tickCounter, RowItem rowItem)
{
foreach (var pivotColumn in PivotColumns)
{
var parent = pivotColumn.Parent.CollectionAncestor();
IList <PivotKey> pivotKeys;
if (null == parent)
{
pivotKeys = new PivotKey[] { null };
}
else
{
pivotKeys = rowItem.PivotKeys.Where(key => key.Last.Key.Equals(parent.PropertyPath)).ToArray();
}
foreach (var pivotKey in pivotKeys)
{
var parentValue = pivotColumn.Parent.GetPropertyValue(rowItem, pivotKey);
if (null != parentValue)
{
var keys = pivotColumn.CollectionInfo.GetKeys(parentValue).Cast <object>().ToArray();
if (keys.Length > 0)
{
var newPivotKeys = rowItem.PivotKeys.Except(new[] { pivotKey }).ToList();
var pivotKeyLocal = pivotKey ?? PivotKey.EMPTY;
var propertyPath = pivotColumn.PropertyPath;
newPivotKeys.AddRange(keys.Select(key => pivotKeyLocal.AppendValue(propertyPath, key)));
rowItem = rowItem.SetPivotKeys(new HashSet <PivotKey>(newPivotKeys));
}
}
}
}
return(rowItem);
}
public IEnumerable <RowItem> Expand(TickCounter tickCounter, RowItem rowItem, int sublistColumnIndex)
{
if (sublistColumnIndex >= SublistColumns.Count)
{
return(new[] { rowItem });
}
var sublistColumn = SublistColumns[sublistColumnIndex];
object parentValue = sublistColumn.Parent.GetPropertyValue(rowItem, null);
if (null == parentValue)
{
return(new[] { rowItem });
}
var items = sublistColumn.CollectionInfo.GetItems(parentValue).Cast <object>().ToArray();
if (items.Length == 0)
{
return(new[] { rowItem });
}
IList <object> keys = null;
if (sublistColumn.CollectionInfo.IsDictionary)
{
keys = sublistColumn.CollectionInfo.GetKeys(parentValue).Cast <object>().ToArray();
}
var expandedItems = new List <RowItem>();
for (int index = 0; index < items.Length; index++)
{
object key = keys == null ? index : keys[index];
var child = rowItem.SetRowKey(rowItem.RowKey.AppendValue(sublistColumn.PropertyPath, key));
expandedItems.AddRange(Expand(tickCounter, child, sublistColumnIndex + 1));
}
return(expandedItems);
}
private void CreateRows(UserResults userResults)
{
RowItem rowUserName = Instantiate(RowUserNamePrefab.gameObject).GetComponent <RowItem>();
rowUserName.Init();
rowUserName.TxtCols[0].text = userResults.UserName;
m_Rows.Add(rowUserName);
rowUserName.transform.SetParent(m_PnlVerticalGroup);
rowUserName.transform.localScale = Vector3.one;
int i = 0;
userResults.Results.ForEach(result =>
{
RowItem rowResult = Instantiate(RowResultPrefab.gameObject).GetComponent <RowItem>();
rowResult.Init();
rowResult.TxtCols[0].text = result.Date;
rowResult.TxtCols[1].text = result.Person;
rowResult.TxtCols[2].text = result.ResultValue;
rowResult.ImgBg.enabled = (i % 2) == 0;
m_Rows.Add(rowResult);
rowResult.transform.SetParent(m_PnlVerticalGroup);
rowResult.transform.localScale = Vector3.one;
i++;
});
}
public void InitializeRows()
{
int x, y;
if (m_oRowCollection != null)
{
for (x = m_oRowCollection.Count - 1; x >= 0; x--)
{
m_oRowCollection.Remove(x);
}
}
m_oRowCollection = new Row_Collection();
for (x = 0; x <= ReferenceListView.Items.Count - 1; x++)
{
ListViewAlternateBackgroundColors.RowItem oItem = new RowItem();
for (y = 0; y <= ReferenceListView.Items[x].SubItems.Count - 1; y++)
{
ListViewAlternateBackgroundColors.ColumnItem oColumnItem = new ColumnItem();
oColumnItem.ReferenceBackgroundColor = this.ReferenceBackgroundColor;
oColumnItem.ReferenceAlternateBackgroundColor = this.ReferenceAlternateBackgroundColor;
oColumnItem.ReferenceSelectedRowBackgroundColor = this.ReferenceSelectedRowBackgroundColor;
oItem.m_oColumnCollection.Add(oColumnItem);
}
m_oRowCollection.Add(oItem);
}
}
public IFileHolder <XLWorkbook> GetFile(string fileName)
{
// получаем сохраненный файл
string xsltPath = Path.Combine(_hostingEnvironment.WebRootPath, "excel", fileName);
// начало использования библиотеке ClosedXML
var workbook = new XLWorkbook(xsltPath);
var worksheet = workbook.Worksheet(1);
var model = new FileHolder <XLWorkbook>(fileName, workbook);
var capacity = worksheet.FirstColumnUsed().LastCellUsed().Address.RowNumber;
capacity--;
foreach (var column in worksheet.ColumnsUsed())
{
var rowItem = new RowItem(capacity);
foreach (var usedCell in column.CellsUsed().Where(c => c.Address.RowNumber > 1))
{
rowItem.SetValue(usedCell.Address.RowNumber - 2, usedCell.Value.ToString());
}
model.FileRowList.AddRow(rowItem);
}
return(model);
}
private void GenerateChoiceLists()
{
List <ColumnItem> columns = new List <ColumnItem>();
char ch = 'A';
for (int i = 1; i <= 10; i++)
{
ColumnItem column = new ColumnItem();
column.ColumnID = i;
column.Letter = ch;
ch++;
columns.Add(column);
}
cbColumn.Enabled = true;
cbColumn.DataSource = columns;
cbColumn.DisplayMember = "Letter";
cbColumn.ValueMember = "ColumnID";
List <RowItem> rows = new List <RowItem>();
for (int i = 1; i <= 10; i++)
{
RowItem row = new RowItem();
row.RowID = i;
rows.Add(row);
}
cbRow.Enabled = true;
cbRow.DataSource = rows;
cbRow.DisplayMember = "RowID";
cbRow.ValueMember = "RowID";
}
internal RowItem ToRowItem()
{
var ri = new RowItem();
if (ItemType != ItemValues.Data)
{
ri.ItemType = ItemType;
}
if (RepeatedItemCount != 0)
{
ri.RepeatedItemCount = RepeatedItemCount;
}
if (Index != 0)
{
ri.Index = Index;
}
foreach (var i in MemberPropertyIndexes)
{
if (i != 0)
{
ri.Append(new MemberPropertyIndex {
Val = i
});
}
else
{
ri.Append(new MemberPropertyIndex());
}
}
return(ri);
}
internal RowItem ToRowItem()
{
RowItem ri = new RowItem();
if (this.ItemType != ItemValues.Data)
{
ri.ItemType = this.ItemType;
}
if (this.RepeatedItemCount != 0)
{
ri.RepeatedItemCount = this.RepeatedItemCount;
}
if (this.Index != 0)
{
ri.Index = this.Index;
}
foreach (int i in this.MemberPropertyIndexes)
{
if (i != 0)
{
ri.Append(new MemberPropertyIndex()
{
Val = i
});
}
else
{
ri.Append(new MemberPropertyIndex());
}
}
return(ri);
}
public RowItem CommitAddNew(RowItem rowItem)
{
var listItem = rowItem.Value as ListItem;
if (listItem == null)
{
return(null);
}
var values = ((ListItem.NewRecordData)listItem.GetRecord()).UncommittedValues;
if (values.Count == 0)
{
return(null);
}
ListItemId?listItemId = null;
SkylineDataSchema.ModifyDocument(EditDescription.Message(ListRef.PROTOTYPE.ChangeName(ListName), string.Format(Resources.ListViewContext_CommitAddNew_Add_new_item_to_list___0__, ListName)), doc =>
{
var listData = doc.Settings.DataSettings.FindList(ListName);
ListItemId newItemId;
listData = listData.AddRow(((ListItem.NewRecordData)listItem.GetRecord()).UncommittedValues, out newItemId);
listItemId = newItemId;
return(doc.ChangeSettings(
doc.Settings.ChangeDataSettings(doc.Settings.DataSettings.ReplaceList(listData))));
}, AuditLogEntry.SettingsLogFunction);
if (!listItemId.HasValue)
{
return(null);
}
return(new RowItem(ConstructListItem(listItemId.Value)));
}
public void Restore()
{
currentRow = normalRow;
for (int i = 0; i < currentRow.RowOrders.Length; i++)
{
limitedRow.RowOrders[i] = i;
limitedRow.RowVisibilities[i] = true;
}
}
public IEnumerable <Color?> GetSeriesColors(PivotedProperties.Series series, RowItem rowItem)
{
if (!_seriesColorManagers.TryGetValue(series.SeriesId, out ColorManager colorManager))
{
return(Enumerable.Repeat((Color?)null, series.PropertyIndexes.Count));
}
return(colorManager.GetRowValues(rowItem).Select(colorManager.ColorScheme.GetColor));
}
public Color?GetColor(DataPropertyDescriptor propertyDescriptor, RowItem rowItem)
{
if (!_colorManagers.TryGetValue(propertyDescriptor.Name, out ColorManager colorManager))
{
return(null);
}
return(colorManager.ColorScheme.GetColor(colorManager.GetRowValue(rowItem, propertyDescriptor)));
}
/// <summary>
/// delete row from table
/// </summary>
/// <param name="fileName"></param>
public void DeleteRow(string fileName)
{
TableItem itemToRemove = RowItem.Single(r => r.FileName.FullName == fileName);
if (itemToRemove != null)
{
RowItem.Remove(itemToRemove);
_bService.DeleteImadgeData(fileName);
}
}
private RowItem MakeLive(RowItem rowItem)
{
if (rowItem.Value is GroupedRow)
{
return(rowItem);
}
int index = WrappedList.IndexOfKey(WrappedList.GetKey((TItem)rowItem.Value));
TItem item = index >= 0 ? WrappedList[index] : default(TItem);
return(rowItem.SetValue(item));
}
public IEnumerable <object> GetRowValues(RowItem rowItem)
{
var rawValues = PropertyDescriptors.Select(pd => pd.GetValue(rowItem));
if (Transform != null)
{
return(Transform.TransformRow(rawValues).Cast <object>());
}
return(rawValues);
}
public SortRow(CancellationToken cancellationToken, QueryParameters queryParameters, RowItem rowItem, int rowIndex)
{
CancellationToken = cancellationToken;
QueryParameters = queryParameters;
RowItem = rowItem;
OriginalRowIndex = rowIndex;
_keys = new object[Sorts.Count];
for (int i = 0; i < Sorts.Count; i++)
{
_keys[i] = Sorts[i].PropertyDescriptor.GetValue(RowItem);
}
}
public SortRow(CancellationToken cancellationToken, DataSchema dataSchema, ListSortDescriptionCollection sorts, RowItem rowItem, int rowIndex)
{
CancellationToken = cancellationToken;
DataSchema = dataSchema;
Sorts = sorts;
RowItem = rowItem;
OriginalRowIndex = rowIndex;
_keys = new object[Sorts.Count];
for (int i = 0; i < Sorts.Count; i++)
{
_keys[i] = Sorts[i].PropertyDescriptor.GetValue(RowItem);
}
}
private ChromFileInfoId GetChromFileInfoId(RowItem rowItem)
{
if (null == rowItem)
{
return(null);
}
var result = rowItem.Value as Result;
if (null != result)
{
return(result.GetResultFile().ChromFileInfoId);
}
return(null);
}
public IDataResult <IRowItem> RowParser
(ExcelWorksheet excelWorksheet, int row, ExcelConfiguration excelConfiguration)
{
IDataResult <IRowItem> dataResult =
new DataResult <IRowItem>()
{
Success = false
};
IRowItem rowItem = new RowItem();
List <IColumnItem> columnItems = new List <IColumnItem>();
int end = excelWorksheet.Dimension.End.Column;
for (int j = excelWorksheet.Dimension.Start.Column;
j <= end;
j++)
{
IExcelWorksheetEntity tmpEntity = new ExcelWorksheetEntity();
tmpEntity.CellNo = j;
tmpEntity.RowNo = row;
tmpEntity.ExcelWorksheet = excelWorksheet;
IExcelWorksheetEntity titleEntity = new ExcelWorksheetEntity();
titleEntity.RowNo = excelConfiguration.DataRowIndex.Title;
titleEntity.CellNo = j;
titleEntity.ExcelWorksheet = excelWorksheet;
IDataResult <string> nametitleResilt = _readExcelData.GetValue(titleEntity);
if (!nametitleResilt.Success)
{
break;
}
IDataResult <IColumnItem> getDataResult =
ColumnParser(tmpEntity, excelConfiguration);
dataResult.Message += getDataResult.Message;
if (getDataResult.Success)
{
columnItems.Add(getDataResult.Data);
}
}
rowItem.ColumnItems = columnItems;
dataResult.Data = rowItem;
dataResult.Success = true;
return(dataResult);
}
public object GetRowValue(RowItem rowItem, DataPropertyDescriptor propertyDescriptor)
{
if (Transform == null)
{
return(propertyDescriptor.GetValue(rowItem));
}
var pdIndex = PropertyDescriptors.IndexOf(propertyDescriptor);
if (pdIndex < 0)
{
return(null);
}
return(GetRowValues(rowItem).Skip(pdIndex).FirstOrDefault());
}
public bool IsNewRowEmpty(RowItem rowItem)
{
var listItem = rowItem.Value as ListItem;
if (listItem == null)
{
return(true);
}
var values = ((ListItem.NewRecordData)listItem.GetRecord()).UncommittedValues;
if (values.Count == 0)
{
return(true);
}
return(false);
}
public XNode ToXML()
{
XElement xTable = new XElement(Fb2Const.fb2DefaultNamespace + Fb2TableElementName);
if (!string.IsNullOrEmpty(ID))
{
xTable.Add(new XAttribute("id", ID));
}
if (!string.IsNullOrEmpty(Style))
{
xTable.Add(new XAttribute("style", Style));
}
foreach (TableRowItem RowItem in rows)
{
xTable.Add(RowItem.ToXML());
}
return(xTable);
}
private void button1_Click(object sender, EventArgs e)
{
using (OpenFileDialog ofd = new OpenFileDialog())
{
if (ofd.ShowDialog() == DialogResult.OK)
{
byte[] filecontents = File.ReadAllBytes(ofd.FileName);
// Get the Item object represented by the selected row
RowItem selecteditem = gridView1.GetFocusedRow() as RowItem;
if (selecteditem == null)
{
return;
}
selecteditem.Bytes = filecontents;
selecteditem.FileName = ofd.FileName;
gridView1.RefreshData();
}
}
}
public void Execute(BasePage Context)
{
Int32 DeleteRow = 0;
Int32 DeletePane = 0;
Boolean Success = false;
Int32 PaneID = WebHelper.GetIntParam(Context.Request, "PaneID", 0);
if (PaneID > 0)
{
DNNGo_ThemePlugin_MenuPane MenuPane = DNNGo_ThemePlugin_MenuPane.FindByKeyForEdit(PaneID);
if (MenuPane != null && MenuPane.ID > 0)
{
List <DNNGo_ThemePlugin_MenuRowItem> RowItems = DNNGo_ThemePlugin_MenuRowItem.FindAll(DNNGo_ThemePlugin_MenuRowItem._.PaneID, PaneID);
foreach (var RowItem in RowItems)
{
if (RowItem.Delete() > 0)
{
DeleteRow++;
}
}
if (MenuPane.Delete() > 0)
{
DeleteRow = 1;
Success = true;
}
}
else
{
Success = false;
}
}
else
{
Success = false;
}
//转换数据为json
ResponseString = new { DeletePane = DeletePane, DeleteRow = DeleteRow, Success = Success }.ToJson();
}
private int?GetReplicateIndex(RowItem rowItem)
{
if (rowItem == null)
{
return(null);
}
var replicate = rowItem.Value as Replicate;
if (null != replicate)
{
return(replicate.ReplicateIndex);
}
var result = rowItem.Value as Result;
if (null != result)
{
return(result.GetResultFile().Replicate.ReplicateIndex);
}
return(null);
}
/// <inheritdoc />
public int Read(BinaryReader reader)
{
var byteCount = 0;
var header = reader.ReadBytes(TableHead.Length);
byteCount += TableHead.Length;
if (!CompareBytes(header, GetHashedBytes(TableHead, TableIdx)))
{
throw new ConfigException("Invalid Table Header");
}
byteCount += ConfigStructureUtils.ReadString(reader, out var tableName);
TableName = tableName;
ColumnCount = reader.ReadUInt16();
byteCount += sizeof(ushort);
for (var i = 0; i < ColumnCount; ++i)
{
byteCount += ConfigStructureUtils.ReadString(reader, out var colName);
ColumnName.Add(colName);
var colSep = reader.ReadByte();
if (colSep != ColSep)
{
throw new ConfigException("Invalid Column Separator");
}
byteCount += 1;
}
RowCount = reader.ReadUInt32();
byteCount += sizeof(uint);
for (var i = 0; i < RowCount; ++i)
{
var rowItem = new RowItem(ColumnCount);
byteCount += rowItem.Read(reader);
RowData.Add(rowItem);
var sep = reader.ReadBytes(RowSep.Length);
byteCount += RowSep.Length;
if (!CompareBytes(sep, GetHashedBytes(RowSep, i)))
{
throw new ConfigException("Invalid Row Separator");
}
}
return(byteCount);
}
public RowItemCollection ListarRowItemCollection(string procedimiento, List <object> parametros)
{
RowItemCollection ocol = new RowItemCollection();
RowItem be;
Query query = new Query(procedimiento);
foreach (var item in parametros)
{
query.input.Add(item);
}
//query.connection = Constant.connectionWMSprod;
using (IDataReader dr = new DAO().GetCollectionIReader(query))
{
ocol.nroColumns = dr.FieldCount;
for (int idx = 0; idx < ocol.nroColumns; idx++)
{
ocol.columns.Add(new Column()
{
campo = string.Format("v{0}", (idx + 1).ToString().PadLeft(2, '0')),
key = dr.GetName(idx),
index = idx,
});
}
int nroRows = 0;
while (dr.Read())
{
be = new RowItem();
foreach (Column c in ocol.columns)
{
be.GetValue(c.campo, dr[ocol.columns[c.index].index].ToString());
}
ocol.rows.Add(be);
nroRows++;
}
ocol.rowsCount = nroRows;
}
return(ocol);
}
internal void FromRowItem(RowItem ri)
{
this.SetAllNull();
if (ri.ItemType != null)
{
this.ItemType = ri.ItemType.Value;
}
if (ri.RepeatedItemCount != null)
{
this.RepeatedItemCount = ri.RepeatedItemCount.Value;
}
if (ri.Index != null)
{
this.Index = ri.Index.Value;
}
MemberPropertyIndex mpi;
using (OpenXmlReader oxr = OpenXmlReader.Create(ri))
{
while (oxr.Read())
{
if (oxr.ElementType == typeof(MemberPropertyIndex))
{
mpi = (MemberPropertyIndex)oxr.LoadCurrentElement();
if (mpi.Val != null)
{
this.MemberPropertyIndexes.Add(mpi.Val.Value);
}
else
{
this.MemberPropertyIndexes.Add(0);
}
}
}
}
}
/// <summary>
/// add new image files to table by draging
/// </summary>
/// <param name="filename"></param>
public void AddNewByDraging(string filename)
{
if (!HaveThisFileName(filename))
{
var item = new TableItem(filename);
var row = new List <TableItem>();
item.KrakenURL = "";
row.Add(item);
RowItem.Add(item);
_bService.SaveNewData(item);
AddingRows?.Invoke(this, row);
}
else
{
Messaging?.Invoke(this, "One or more file(s) already in use. Remove first it(s) if need");
}
if (!_krakenIsStarting)
{
Task.Run(() => GetStartedWithKraken());
}
}
public RowItemCollection GetLotesActivos(int esquema)
{
Database db = new SqlDatabase(GS.configuration.Init.GetValue(Constant.sistema, Constant.key, "genesys"));
RowItemCollection ocol = new RowItemCollection();
int nresult = -1;
using (DbConnection connection = db.CreateConnection())
{
connection.Open();
DbCommand dbCommand = db.GetStoredProcCommand(Entities.Common.Constant.getEsquemaBD(esquema) + "USP_WMS_TASK_SEL_LOTEACTIVO");
RowItem be;
using (IDataReader dr = db.ExecuteReader(dbCommand))
{
be = new RowItem();
for (int i = 0; i < dr.FieldCount; i++)
{
be.v01 = string.Format("{0}{1}", be.v01, dr.GetName(i) + "|");
}
ocol.rows.Add(be);
while (dr.Read())
{
be = new RowItem();
for (int i = 0; i < dr.FieldCount; i++)
{
be.v01 = string.Format("{0}{1}", be.v01, dr[i] + "|");
}
ocol.rows.Add(be);
}
}
ocol.rowsCount = ocol.rows.Count();
connection.Close();
return(ocol);
}
}
// Generates content of pivotTablePart3.
private void GeneratePivotTablePart3Content(PivotTablePart pivotTablePart3)
{
PivotTableDefinition pivotTableDefinition5 = new PivotTableDefinition(){ Name = "PivotTable1", CacheId = (UInt32Value)1U, ApplyNumberFormats = false, ApplyBorderFormats = false, ApplyFontFormats = false, ApplyPatternFormats = false, ApplyAlignmentFormats = false, ApplyWidthHeightFormats = true, DataCaption = "Values", UpdatedVersion = 5, MinRefreshableVersion = 5, UseAutoFormatting = true, ItemPrintTitles = true, CreatedVersion = 4, Indent = (UInt32Value)0U, Outline = true, OutlineData = true, MultipleFieldFilters = false, ChartFormat = (UInt32Value)13U };
Location location3 = new Location(){ Reference = "A1:B5", FirstHeaderRow = (UInt32Value)1U, FirstDataRow = (UInt32Value)1U, FirstDataColumn = (UInt32Value)1U };
PivotFields pivotFields3 = new PivotFields(){ Count = (UInt32Value)7U };
PivotField pivotField14 = new PivotField(){ NumberFormatId = (UInt32Value)14U, ShowAll = false };
Items items7 = new Items(){ Count = (UInt32Value)15U };
Item item54 = new Item(){ Index = (UInt32Value)0U };
Item item55 = new Item(){ Index = (UInt32Value)1U };
Item item56 = new Item(){ Index = (UInt32Value)2U };
Item item57 = new Item(){ Index = (UInt32Value)3U };
Item item58 = new Item(){ Index = (UInt32Value)4U };
Item item59 = new Item(){ Index = (UInt32Value)5U };
Item item60 = new Item(){ Index = (UInt32Value)6U };
Item item61 = new Item(){ Index = (UInt32Value)7U };
Item item62 = new Item(){ Index = (UInt32Value)8U };
Item item63 = new Item(){ Index = (UInt32Value)9U };
Item item64 = new Item(){ Index = (UInt32Value)10U };
Item item65 = new Item(){ Index = (UInt32Value)11U };
Item item66 = new Item(){ Index = (UInt32Value)12U };
Item item67 = new Item(){ Index = (UInt32Value)13U };
Item item68 = new Item(){ ItemType = ItemValues.Default };
items7.Append(item54);
items7.Append(item55);
items7.Append(item56);
items7.Append(item57);
items7.Append(item58);
items7.Append(item59);
items7.Append(item60);
items7.Append(item61);
items7.Append(item62);
items7.Append(item63);
items7.Append(item64);
items7.Append(item65);
items7.Append(item66);
items7.Append(item67);
items7.Append(item68);
pivotField14.Append(items7);
PivotField pivotField15 = new PivotField(){ Axis = PivotTableAxisValues.AxisRow, ShowAll = false };
Items items8 = new Items(){ Count = (UInt32Value)11U };
Item item69 = new Item(){ Index = (UInt32Value)0U };
Item item70 = new Item(){ Missing = true, Index = (UInt32Value)4U };
Item item71 = new Item(){ Missing = true, Index = (UInt32Value)3U };
Item item72 = new Item(){ Index = (UInt32Value)1U };
Item item73 = new Item(){ Index = (UInt32Value)2U };
Item item74 = new Item(){ Missing = true, Index = (UInt32Value)9U };
Item item75 = new Item(){ Missing = true, Index = (UInt32Value)8U };
Item item76 = new Item(){ Missing = true, Index = (UInt32Value)7U };
Item item77 = new Item(){ Missing = true, Index = (UInt32Value)6U };
Item item78 = new Item(){ Missing = true, Index = (UInt32Value)5U };
Item item79 = new Item(){ ItemType = ItemValues.Default };
items8.Append(item69);
items8.Append(item70);
items8.Append(item71);
items8.Append(item72);
items8.Append(item73);
items8.Append(item74);
items8.Append(item75);
items8.Append(item76);
items8.Append(item77);
items8.Append(item78);
items8.Append(item79);
pivotField15.Append(items8);
PivotField pivotField16 = new PivotField(){ DataField = true, ShowAll = false };
PivotField pivotField17 = new PivotField(){ ShowAll = false };
PivotField pivotField18 = new PivotField(){ NumberFormatId = (UInt32Value)14U, ShowAll = false };
Items items9 = new Items(){ Count = (UInt32Value)5U };
Item item80 = new Item(){ Index = (UInt32Value)0U };
Item item81 = new Item(){ Index = (UInt32Value)1U };
Item item82 = new Item(){ Index = (UInt32Value)3U };
Item item83 = new Item(){ Index = (UInt32Value)2U };
Item item84 = new Item(){ ItemType = ItemValues.Default };
items9.Append(item80);
items9.Append(item81);
items9.Append(item82);
items9.Append(item83);
items9.Append(item84);
pivotField18.Append(items9);
PivotField pivotField19 = new PivotField(){ ShowAll = false };
PivotField pivotField20 = new PivotField(){ ShowAll = false, DefaultSubtotal = false };
Items items10 = new Items(){ Count = (UInt32Value)5U };
Item item85 = new Item(){ Index = (UInt32Value)0U };
Item item86 = new Item(){ Index = (UInt32Value)1U };
Item item87 = new Item(){ Index = (UInt32Value)2U };
Item item88 = new Item(){ Index = (UInt32Value)3U };
Item item89 = new Item(){ Index = (UInt32Value)4U };
items10.Append(item85);
items10.Append(item86);
items10.Append(item87);
items10.Append(item88);
items10.Append(item89);
pivotField20.Append(items10);
pivotFields3.Append(pivotField14);
pivotFields3.Append(pivotField15);
pivotFields3.Append(pivotField16);
pivotFields3.Append(pivotField17);
pivotFields3.Append(pivotField18);
pivotFields3.Append(pivotField19);
pivotFields3.Append(pivotField20);
RowFields rowFields3 = new RowFields(){ Count = (UInt32Value)1U };
Field field3 = new Field(){ Index = 1 };
rowFields3.Append(field3);
RowItems rowItems3 = new RowItems(){ Count = (UInt32Value)4U };
RowItem rowItem11 = new RowItem();
MemberPropertyIndex memberPropertyIndex9 = new MemberPropertyIndex();
rowItem11.Append(memberPropertyIndex9);
RowItem rowItem12 = new RowItem();
MemberPropertyIndex memberPropertyIndex10 = new MemberPropertyIndex(){ Val = 3 };
rowItem12.Append(memberPropertyIndex10);
RowItem rowItem13 = new RowItem();
MemberPropertyIndex memberPropertyIndex11 = new MemberPropertyIndex(){ Val = 4 };
rowItem13.Append(memberPropertyIndex11);
RowItem rowItem14 = new RowItem(){ ItemType = ItemValues.Grand };
MemberPropertyIndex memberPropertyIndex12 = new MemberPropertyIndex();
rowItem14.Append(memberPropertyIndex12);
rowItems3.Append(rowItem11);
rowItems3.Append(rowItem12);
rowItems3.Append(rowItem13);
rowItems3.Append(rowItem14);
ColumnItems columnItems3 = new ColumnItems(){ Count = (UInt32Value)1U };
RowItem rowItem15 = new RowItem();
columnItems3.Append(rowItem15);
DataFields dataFields3 = new DataFields(){ Count = (UInt32Value)1U };
DataField dataField3 = new DataField(){ Name = "Sum of Quantity", Field = (UInt32Value)2U, BaseField = 0, BaseItem = (UInt32Value)0U };
dataFields3.Append(dataField3);
ChartFormats chartFormats3 = new ChartFormats(){ Count = (UInt32Value)9U };
ChartFormat chartFormat14 = new ChartFormat(){ Chart = (UInt32Value)4U, Format = (UInt32Value)0U, Series = true };
PivotArea pivotArea14 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences14 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference14 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem36 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference14.Append(fieldItem36);
pivotAreaReferences14.Append(pivotAreaReference14);
pivotArea14.Append(pivotAreaReferences14);
chartFormat14.Append(pivotArea14);
ChartFormat chartFormat15 = new ChartFormat(){ Chart = (UInt32Value)5U, Format = (UInt32Value)2U, Series = true };
PivotArea pivotArea15 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences15 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference15 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem37 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference15.Append(fieldItem37);
pivotAreaReferences15.Append(pivotAreaReference15);
pivotArea15.Append(pivotAreaReferences15);
chartFormat15.Append(pivotArea15);
ChartFormat chartFormat16 = new ChartFormat(){ Chart = (UInt32Value)6U, Format = (UInt32Value)0U, Series = true };
PivotArea pivotArea16 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences16 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference16 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem38 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference16.Append(fieldItem38);
pivotAreaReferences16.Append(pivotAreaReference16);
pivotArea16.Append(pivotAreaReferences16);
chartFormat16.Append(pivotArea16);
ChartFormat chartFormat17 = new ChartFormat(){ Chart = (UInt32Value)7U, Format = (UInt32Value)14U, Series = true };
PivotArea pivotArea17 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences17 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference17 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem39 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference17.Append(fieldItem39);
pivotAreaReferences17.Append(pivotAreaReference17);
pivotArea17.Append(pivotAreaReferences17);
chartFormat17.Append(pivotArea17);
ChartFormat chartFormat18 = new ChartFormat(){ Chart = (UInt32Value)8U, Format = (UInt32Value)1U, Series = true };
PivotArea pivotArea18 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences18 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference18 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem40 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference18.Append(fieldItem40);
pivotAreaReferences18.Append(pivotAreaReference18);
pivotArea18.Append(pivotAreaReferences18);
chartFormat18.Append(pivotArea18);
ChartFormat chartFormat19 = new ChartFormat(){ Chart = (UInt32Value)9U, Format = (UInt32Value)15U, Series = true };
PivotArea pivotArea19 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences19 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference19 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem41 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference19.Append(fieldItem41);
pivotAreaReferences19.Append(pivotAreaReference19);
pivotArea19.Append(pivotAreaReferences19);
chartFormat19.Append(pivotArea19);
ChartFormat chartFormat20 = new ChartFormat(){ Chart = (UInt32Value)10U, Format = (UInt32Value)2U, Series = true };
PivotArea pivotArea20 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences20 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference20 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem42 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference20.Append(fieldItem42);
pivotAreaReferences20.Append(pivotAreaReference20);
pivotArea20.Append(pivotAreaReferences20);
chartFormat20.Append(pivotArea20);
ChartFormat chartFormat21 = new ChartFormat(){ Chart = (UInt32Value)11U, Format = (UInt32Value)16U, Series = true };
PivotArea pivotArea21 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences21 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference21 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem43 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference21.Append(fieldItem43);
pivotAreaReferences21.Append(pivotAreaReference21);
pivotArea21.Append(pivotAreaReferences21);
chartFormat21.Append(pivotArea21);
ChartFormat chartFormat22 = new ChartFormat(){ Chart = (UInt32Value)12U, Format = (UInt32Value)3U, Series = true };
PivotArea pivotArea22 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences22 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference22 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem44 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference22.Append(fieldItem44);
pivotAreaReferences22.Append(pivotAreaReference22);
pivotArea22.Append(pivotAreaReferences22);
chartFormat22.Append(pivotArea22);
chartFormats3.Append(chartFormat14);
chartFormats3.Append(chartFormat15);
chartFormats3.Append(chartFormat16);
chartFormats3.Append(chartFormat17);
chartFormats3.Append(chartFormat18);
chartFormats3.Append(chartFormat19);
chartFormats3.Append(chartFormat20);
chartFormats3.Append(chartFormat21);
chartFormats3.Append(chartFormat22);
PivotTableStyle pivotTableStyle3 = new PivotTableStyle(){ Name = "PivotStyleLight16", ShowRowHeaders = true, ShowColumnHeaders = true, ShowRowStripes = false, ShowColumnStripes = false, ShowLastColumn = true };
PivotTableDefinitionExtensionList pivotTableDefinitionExtensionList3 = new PivotTableDefinitionExtensionList();
PivotTableDefinitionExtension pivotTableDefinitionExtension3 = new PivotTableDefinitionExtension(){ Uri = "{962EF5D1-5CA2-4c93-8EF4-DBF5C05439D2}" };
pivotTableDefinitionExtension3.AddNamespaceDeclaration("x14", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/main");
X14.PivotTableDefinition pivotTableDefinition6 = new X14.PivotTableDefinition(){ HideValuesRow = true };
pivotTableDefinition6.AddNamespaceDeclaration("xm", "http://schemas.microsoft.com/office/excel/2006/main");
pivotTableDefinitionExtension3.Append(pivotTableDefinition6);
pivotTableDefinitionExtensionList3.Append(pivotTableDefinitionExtension3);
pivotTableDefinition5.Append(location3);
pivotTableDefinition5.Append(pivotFields3);
pivotTableDefinition5.Append(rowFields3);
pivotTableDefinition5.Append(rowItems3);
pivotTableDefinition5.Append(columnItems3);
pivotTableDefinition5.Append(dataFields3);
pivotTableDefinition5.Append(chartFormats3);
pivotTableDefinition5.Append(pivotTableStyle3);
pivotTableDefinition5.Append(pivotTableDefinitionExtensionList3);
pivotTablePart3.PivotTableDefinition = pivotTableDefinition5;
}
// Generates content of pivotTablePart1.
private void GeneratePivotTablePart1Content(PivotTablePart pivotTablePart1)
{
PivotTableDefinition pivotTableDefinition1 = new PivotTableDefinition() { Name = "PivotTable1", CacheId = (UInt32Value)2U, ApplyNumberFormats = false, ApplyBorderFormats = false, ApplyFontFormats = false, ApplyPatternFormats = false, ApplyAlignmentFormats = false, ApplyWidthHeightFormats = true, DataCaption = "Values", UpdatedVersion = 4, MinRefreshableVersion = 3, UseAutoFormatting = true, ItemPrintTitles = true, CreatedVersion = 4, Indent = (UInt32Value)0U, Outline = true, OutlineData = true, MultipleFieldFilters = false };
Location location1 = new Location() { Reference = "A1:B5", FirstHeaderRow = (UInt32Value)1U, FirstDataRow = (UInt32Value)1U, FirstDataColumn = (UInt32Value)1U };
PivotFields pivotFields1 = new PivotFields() { Count = (UInt32Value)2U };
PivotField pivotField1 = new PivotField() { Axis = PivotTableAxisValues.AxisRow, ShowAll = false };
Items items1 = new Items() { Count = (UInt32Value)4U };
Item item1 = new Item() { Index = (UInt32Value)0U };
Item item2 = new Item() { Index = (UInt32Value)1U };
Item item3 = new Item() { Index = (UInt32Value)2U };
Item item4 = new Item() { ItemType = ItemValues.Default };
items1.Append(item1);
items1.Append(item2);
items1.Append(item3);
items1.Append(item4);
pivotField1.Append(items1);
PivotField pivotField2 = new PivotField() { DataField = true, ShowAll = false };
pivotFields1.Append(pivotField1);
pivotFields1.Append(pivotField2);
RowFields rowFields1 = new RowFields() { Count = (UInt32Value)1U };
Field field1 = new Field() { Index = 0 };
rowFields1.Append(field1);
RowItems rowItems1 = new RowItems() { Count = (UInt32Value)4U };
RowItem rowItem1 = new RowItem();
MemberPropertyIndex memberPropertyIndex1 = new MemberPropertyIndex();
rowItem1.Append(memberPropertyIndex1);
RowItem rowItem2 = new RowItem();
MemberPropertyIndex memberPropertyIndex2 = new MemberPropertyIndex() { Val = 1 };
rowItem2.Append(memberPropertyIndex2);
RowItem rowItem3 = new RowItem();
MemberPropertyIndex memberPropertyIndex3 = new MemberPropertyIndex() { Val = 2 };
rowItem3.Append(memberPropertyIndex3);
RowItem rowItem4 = new RowItem() { ItemType = ItemValues.Grand };
MemberPropertyIndex memberPropertyIndex4 = new MemberPropertyIndex();
rowItem4.Append(memberPropertyIndex4);
rowItems1.Append(rowItem1);
rowItems1.Append(rowItem2);
rowItems1.Append(rowItem3);
rowItems1.Append(rowItem4);
ColumnItems columnItems1 = new ColumnItems() { Count = (UInt32Value)1U };
RowItem rowItem5 = new RowItem();
columnItems1.Append(rowItem5);
DataFields dataFields1 = new DataFields() { Count = (UInt32Value)1U };
DataField dataField1 = new DataField() { Name = "Sum of score", Field = (UInt32Value)1U, BaseField = 0, BaseItem = (UInt32Value)0U };
dataFields1.Append(dataField1);
PivotTableStyle pivotTableStyle1 = new PivotTableStyle() { Name = "PivotStyleMedium9", ShowRowHeaders = true, ShowColumnHeaders = true, ShowRowStripes = false, ShowColumnStripes = false, ShowLastColumn = true };
PivotTableDefinitionExtensionList pivotTableDefinitionExtensionList1 = new PivotTableDefinitionExtensionList();
pivotTableDefinition1.Append(location1);
pivotTableDefinition1.Append(pivotFields1);
pivotTableDefinition1.Append(rowFields1);
pivotTableDefinition1.Append(rowItems1);
pivotTableDefinition1.Append(columnItems1);
pivotTableDefinition1.Append(dataFields1);
pivotTableDefinition1.Append(pivotTableStyle1);
pivotTableDefinition1.Append(pivotTableDefinitionExtensionList1);
pivotTablePart1.PivotTableDefinition = pivotTableDefinition1;
}
private QueryResults()
{
Parameters = QueryParameters.Empty;
PivotedRows = FilteredRows = SortedRows = new RowItem[0];
ItemProperties = null;
}
// Generates content of pivotTablePart1.
private void GeneratePivotTablePart1Content(PivotTablePart pivotTablePart1)
{
PivotTableDefinition pivotTableDefinition1 = new PivotTableDefinition(){ Name = "PivotTable1", CacheId = (UInt32Value)1U, ApplyNumberFormats = false, ApplyBorderFormats = false, ApplyFontFormats = false, ApplyPatternFormats = false, ApplyAlignmentFormats = false, ApplyWidthHeightFormats = true, DataCaption = "Values", UpdatedVersion = 5, MinRefreshableVersion = 5, UseAutoFormatting = true, ItemPrintTitles = true, CreatedVersion = 4, Indent = (UInt32Value)0U, Outline = true, OutlineData = true, MultipleFieldFilters = false, ChartFormat = (UInt32Value)15U };
Location location1 = new Location(){ Reference = "A1:B5", FirstHeaderRow = (UInt32Value)1U, FirstDataRow = (UInt32Value)1U, FirstDataColumn = (UInt32Value)1U };
PivotFields pivotFields1 = new PivotFields(){ Count = (UInt32Value)7U };
PivotField pivotField1 = new PivotField(){ NumberFormatId = (UInt32Value)14U, ShowAll = false };
Items items1 = new Items(){ Count = (UInt32Value)15U };
Item item1 = new Item(){ Index = (UInt32Value)0U };
Item item2 = new Item(){ Index = (UInt32Value)1U };
Item item3 = new Item(){ Index = (UInt32Value)2U };
Item item4 = new Item(){ Index = (UInt32Value)3U };
Item item5 = new Item(){ Index = (UInt32Value)4U };
Item item6 = new Item(){ Index = (UInt32Value)5U };
Item item7 = new Item(){ Index = (UInt32Value)6U };
Item item8 = new Item(){ Index = (UInt32Value)7U };
Item item9 = new Item(){ Index = (UInt32Value)8U };
Item item10 = new Item(){ Index = (UInt32Value)9U };
Item item11 = new Item(){ Index = (UInt32Value)10U };
Item item12 = new Item(){ Index = (UInt32Value)11U };
Item item13 = new Item(){ Index = (UInt32Value)12U };
Item item14 = new Item(){ Index = (UInt32Value)13U };
Item item15 = new Item(){ ItemType = ItemValues.Default };
items1.Append(item1);
items1.Append(item2);
items1.Append(item3);
items1.Append(item4);
items1.Append(item5);
items1.Append(item6);
items1.Append(item7);
items1.Append(item8);
items1.Append(item9);
items1.Append(item10);
items1.Append(item11);
items1.Append(item12);
items1.Append(item13);
items1.Append(item14);
items1.Append(item15);
pivotField1.Append(items1);
PivotField pivotField2 = new PivotField(){ Axis = PivotTableAxisValues.AxisRow, ShowAll = false };
Items items2 = new Items(){ Count = (UInt32Value)11U };
Item item16 = new Item(){ Index = (UInt32Value)0U };
Item item17 = new Item(){ Missing = true, Index = (UInt32Value)4U };
Item item18 = new Item(){ Missing = true, Index = (UInt32Value)3U };
Item item19 = new Item(){ Index = (UInt32Value)1U };
Item item20 = new Item(){ Index = (UInt32Value)2U };
Item item21 = new Item(){ Missing = true, Index = (UInt32Value)9U };
Item item22 = new Item(){ Missing = true, Index = (UInt32Value)8U };
Item item23 = new Item(){ Missing = true, Index = (UInt32Value)7U };
Item item24 = new Item(){ Missing = true, Index = (UInt32Value)6U };
Item item25 = new Item(){ Missing = true, Index = (UInt32Value)5U };
Item item26 = new Item(){ ItemType = ItemValues.Default };
items2.Append(item16);
items2.Append(item17);
items2.Append(item18);
items2.Append(item19);
items2.Append(item20);
items2.Append(item21);
items2.Append(item22);
items2.Append(item23);
items2.Append(item24);
items2.Append(item25);
items2.Append(item26);
pivotField2.Append(items2);
PivotField pivotField3 = new PivotField(){ DataField = true, ShowAll = false };
PivotField pivotField4 = new PivotField(){ ShowAll = false };
PivotField pivotField5 = new PivotField(){ NumberFormatId = (UInt32Value)14U, ShowAll = false };
Items items3 = new Items(){ Count = (UInt32Value)5U };
Item item27 = new Item(){ Index = (UInt32Value)0U };
Item item28 = new Item(){ Index = (UInt32Value)1U };
Item item29 = new Item(){ Index = (UInt32Value)3U };
Item item30 = new Item(){ Index = (UInt32Value)2U };
Item item31 = new Item(){ ItemType = ItemValues.Default };
items3.Append(item27);
items3.Append(item28);
items3.Append(item29);
items3.Append(item30);
items3.Append(item31);
pivotField5.Append(items3);
PivotField pivotField6 = new PivotField(){ ShowAll = false };
PivotField pivotField7 = new PivotField(){ ShowAll = false, DefaultSubtotal = false };
Items items4 = new Items(){ Count = (UInt32Value)5U };
Item item32 = new Item(){ Index = (UInt32Value)0U };
Item item33 = new Item(){ Index = (UInt32Value)1U };
Item item34 = new Item(){ Index = (UInt32Value)2U };
Item item35 = new Item(){ Index = (UInt32Value)3U };
Item item36 = new Item(){ Index = (UInt32Value)4U };
items4.Append(item32);
items4.Append(item33);
items4.Append(item34);
items4.Append(item35);
items4.Append(item36);
pivotField7.Append(items4);
pivotFields1.Append(pivotField1);
pivotFields1.Append(pivotField2);
pivotFields1.Append(pivotField3);
pivotFields1.Append(pivotField4);
pivotFields1.Append(pivotField5);
pivotFields1.Append(pivotField6);
pivotFields1.Append(pivotField7);
RowFields rowFields1 = new RowFields(){ Count = (UInt32Value)1U };
Field field1 = new Field(){ Index = 1 };
rowFields1.Append(field1);
RowItems rowItems1 = new RowItems(){ Count = (UInt32Value)4U };
RowItem rowItem1 = new RowItem();
MemberPropertyIndex memberPropertyIndex1 = new MemberPropertyIndex();
rowItem1.Append(memberPropertyIndex1);
RowItem rowItem2 = new RowItem();
MemberPropertyIndex memberPropertyIndex2 = new MemberPropertyIndex(){ Val = 3 };
rowItem2.Append(memberPropertyIndex2);
RowItem rowItem3 = new RowItem();
MemberPropertyIndex memberPropertyIndex3 = new MemberPropertyIndex(){ Val = 4 };
rowItem3.Append(memberPropertyIndex3);
RowItem rowItem4 = new RowItem(){ ItemType = ItemValues.Grand };
MemberPropertyIndex memberPropertyIndex4 = new MemberPropertyIndex();
rowItem4.Append(memberPropertyIndex4);
rowItems1.Append(rowItem1);
rowItems1.Append(rowItem2);
rowItems1.Append(rowItem3);
rowItems1.Append(rowItem4);
ColumnItems columnItems1 = new ColumnItems(){ Count = (UInt32Value)1U };
RowItem rowItem5 = new RowItem();
columnItems1.Append(rowItem5);
DataFields dataFields1 = new DataFields(){ Count = (UInt32Value)1U };
DataField dataField1 = new DataField(){ Name = "Sum of Quantity", Field = (UInt32Value)2U, BaseField = 0, BaseItem = (UInt32Value)0U };
dataFields1.Append(dataField1);
ChartFormats chartFormats1 = new ChartFormats(){ Count = (UInt32Value)11U };
ChartFormat chartFormat1 = new ChartFormat(){ Chart = (UInt32Value)4U, Format = (UInt32Value)0U, Series = true };
PivotArea pivotArea1 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences1 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference1 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem1 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference1.Append(fieldItem1);
pivotAreaReferences1.Append(pivotAreaReference1);
pivotArea1.Append(pivotAreaReferences1);
chartFormat1.Append(pivotArea1);
ChartFormat chartFormat2 = new ChartFormat(){ Chart = (UInt32Value)5U, Format = (UInt32Value)2U, Series = true };
PivotArea pivotArea2 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences2 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference2 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem2 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference2.Append(fieldItem2);
pivotAreaReferences2.Append(pivotAreaReference2);
pivotArea2.Append(pivotAreaReferences2);
chartFormat2.Append(pivotArea2);
ChartFormat chartFormat3 = new ChartFormat(){ Chart = (UInt32Value)6U, Format = (UInt32Value)0U, Series = true };
PivotArea pivotArea3 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences3 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference3 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem3 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference3.Append(fieldItem3);
pivotAreaReferences3.Append(pivotAreaReference3);
pivotArea3.Append(pivotAreaReferences3);
chartFormat3.Append(pivotArea3);
ChartFormat chartFormat4 = new ChartFormat(){ Chart = (UInt32Value)7U, Format = (UInt32Value)14U, Series = true };
PivotArea pivotArea4 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences4 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference4 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem4 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference4.Append(fieldItem4);
pivotAreaReferences4.Append(pivotAreaReference4);
pivotArea4.Append(pivotAreaReferences4);
chartFormat4.Append(pivotArea4);
ChartFormat chartFormat5 = new ChartFormat(){ Chart = (UInt32Value)8U, Format = (UInt32Value)1U, Series = true };
PivotArea pivotArea5 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences5 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference5 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem5 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference5.Append(fieldItem5);
pivotAreaReferences5.Append(pivotAreaReference5);
pivotArea5.Append(pivotAreaReferences5);
chartFormat5.Append(pivotArea5);
ChartFormat chartFormat6 = new ChartFormat(){ Chart = (UInt32Value)9U, Format = (UInt32Value)15U, Series = true };
PivotArea pivotArea6 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences6 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference6 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem6 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference6.Append(fieldItem6);
pivotAreaReferences6.Append(pivotAreaReference6);
pivotArea6.Append(pivotAreaReferences6);
chartFormat6.Append(pivotArea6);
ChartFormat chartFormat7 = new ChartFormat(){ Chart = (UInt32Value)10U, Format = (UInt32Value)2U, Series = true };
PivotArea pivotArea7 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences7 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference7 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem7 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference7.Append(fieldItem7);
pivotAreaReferences7.Append(pivotAreaReference7);
pivotArea7.Append(pivotAreaReferences7);
chartFormat7.Append(pivotArea7);
ChartFormat chartFormat8 = new ChartFormat(){ Chart = (UInt32Value)11U, Format = (UInt32Value)16U, Series = true };
PivotArea pivotArea8 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences8 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference8 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem8 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference8.Append(fieldItem8);
pivotAreaReferences8.Append(pivotAreaReference8);
pivotArea8.Append(pivotAreaReferences8);
chartFormat8.Append(pivotArea8);
ChartFormat chartFormat9 = new ChartFormat(){ Chart = (UInt32Value)12U, Format = (UInt32Value)3U, Series = true };
PivotArea pivotArea9 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences9 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference9 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem9 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference9.Append(fieldItem9);
pivotAreaReferences9.Append(pivotAreaReference9);
pivotArea9.Append(pivotAreaReferences9);
chartFormat9.Append(pivotArea9);
ChartFormat chartFormat10 = new ChartFormat(){ Chart = (UInt32Value)13U, Format = (UInt32Value)17U, Series = true };
PivotArea pivotArea10 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences10 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference10 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem10 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference10.Append(fieldItem10);
pivotAreaReferences10.Append(pivotAreaReference10);
pivotArea10.Append(pivotAreaReferences10);
chartFormat10.Append(pivotArea10);
ChartFormat chartFormat11 = new ChartFormat(){ Chart = (UInt32Value)14U, Format = (UInt32Value)4U, Series = true };
PivotArea pivotArea11 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences11 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference11 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem11 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference11.Append(fieldItem11);
pivotAreaReferences11.Append(pivotAreaReference11);
pivotArea11.Append(pivotAreaReferences11);
chartFormat11.Append(pivotArea11);
chartFormats1.Append(chartFormat1);
chartFormats1.Append(chartFormat2);
chartFormats1.Append(chartFormat3);
chartFormats1.Append(chartFormat4);
chartFormats1.Append(chartFormat5);
chartFormats1.Append(chartFormat6);
chartFormats1.Append(chartFormat7);
chartFormats1.Append(chartFormat8);
chartFormats1.Append(chartFormat9);
chartFormats1.Append(chartFormat10);
chartFormats1.Append(chartFormat11);
PivotTableStyle pivotTableStyle1 = new PivotTableStyle(){ Name = "PivotStyleLight16", ShowRowHeaders = true, ShowColumnHeaders = true, ShowRowStripes = false, ShowColumnStripes = false, ShowLastColumn = true };
PivotTableDefinitionExtensionList pivotTableDefinitionExtensionList1 = new PivotTableDefinitionExtensionList();
PivotTableDefinitionExtension pivotTableDefinitionExtension1 = new PivotTableDefinitionExtension(){ Uri = "{962EF5D1-5CA2-4c93-8EF4-DBF5C05439D2}" };
pivotTableDefinitionExtension1.AddNamespaceDeclaration("x14", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/main");
X14.PivotTableDefinition pivotTableDefinition2 = new X14.PivotTableDefinition(){ HideValuesRow = true };
pivotTableDefinition2.AddNamespaceDeclaration("xm", "http://schemas.microsoft.com/office/excel/2006/main");
pivotTableDefinitionExtension1.Append(pivotTableDefinition2);
pivotTableDefinitionExtensionList1.Append(pivotTableDefinitionExtension1);
pivotTableDefinition1.Append(location1);
pivotTableDefinition1.Append(pivotFields1);
pivotTableDefinition1.Append(rowFields1);
pivotTableDefinition1.Append(rowItems1);
pivotTableDefinition1.Append(columnItems1);
pivotTableDefinition1.Append(dataFields1);
pivotTableDefinition1.Append(chartFormats1);
pivotTableDefinition1.Append(pivotTableStyle1);
pivotTableDefinition1.Append(pivotTableDefinitionExtensionList1);
pivotTablePart1.PivotTableDefinition = pivotTableDefinition1;
}
// Generates content of pivotTablePart4.
private void GeneratePivotTablePart4Content(PivotTablePart pivotTablePart4)
{
PivotTableDefinition pivotTableDefinition7 = new PivotTableDefinition(){ Name = "PivotTable1", CacheId = (UInt32Value)1U, ApplyNumberFormats = false, ApplyBorderFormats = false, ApplyFontFormats = false, ApplyPatternFormats = false, ApplyAlignmentFormats = false, ApplyWidthHeightFormats = true, DataCaption = "Values", UpdatedVersion = 5, MinRefreshableVersion = 5, UseAutoFormatting = true, ItemPrintTitles = true, CreatedVersion = 4, Indent = (UInt32Value)0U, Outline = true, OutlineData = true, MultipleFieldFilters = false, ChartFormat = (UInt32Value)11U };
Location location4 = new Location(){ Reference = "A1:B5", FirstHeaderRow = (UInt32Value)1U, FirstDataRow = (UInt32Value)1U, FirstDataColumn = (UInt32Value)1U };
PivotFields pivotFields4 = new PivotFields(){ Count = (UInt32Value)7U };
PivotField pivotField21 = new PivotField(){ NumberFormatId = (UInt32Value)14U, ShowAll = false };
Items items11 = new Items(){ Count = (UInt32Value)15U };
Item item90 = new Item(){ Index = (UInt32Value)0U };
Item item91 = new Item(){ Index = (UInt32Value)1U };
Item item92 = new Item(){ Index = (UInt32Value)2U };
Item item93 = new Item(){ Index = (UInt32Value)3U };
Item item94 = new Item(){ Index = (UInt32Value)4U };
Item item95 = new Item(){ Index = (UInt32Value)5U };
Item item96 = new Item(){ Index = (UInt32Value)6U };
Item item97 = new Item(){ Index = (UInt32Value)7U };
Item item98 = new Item(){ Index = (UInt32Value)8U };
Item item99 = new Item(){ Index = (UInt32Value)9U };
Item item100 = new Item(){ Index = (UInt32Value)10U };
Item item101 = new Item(){ Index = (UInt32Value)11U };
Item item102 = new Item(){ Index = (UInt32Value)12U };
Item item103 = new Item(){ Index = (UInt32Value)13U };
Item item104 = new Item(){ ItemType = ItemValues.Default };
items11.Append(item90);
items11.Append(item91);
items11.Append(item92);
items11.Append(item93);
items11.Append(item94);
items11.Append(item95);
items11.Append(item96);
items11.Append(item97);
items11.Append(item98);
items11.Append(item99);
items11.Append(item100);
items11.Append(item101);
items11.Append(item102);
items11.Append(item103);
items11.Append(item104);
pivotField21.Append(items11);
PivotField pivotField22 = new PivotField(){ Axis = PivotTableAxisValues.AxisRow, ShowAll = false };
Items items12 = new Items(){ Count = (UInt32Value)11U };
Item item105 = new Item(){ Index = (UInt32Value)0U };
Item item106 = new Item(){ Missing = true, Index = (UInt32Value)4U };
Item item107 = new Item(){ Missing = true, Index = (UInt32Value)3U };
Item item108 = new Item(){ Index = (UInt32Value)1U };
Item item109 = new Item(){ Index = (UInt32Value)2U };
Item item110 = new Item(){ Missing = true, Index = (UInt32Value)9U };
Item item111 = new Item(){ Missing = true, Index = (UInt32Value)8U };
Item item112 = new Item(){ Missing = true, Index = (UInt32Value)7U };
Item item113 = new Item(){ Missing = true, Index = (UInt32Value)6U };
Item item114 = new Item(){ Missing = true, Index = (UInt32Value)5U };
Item item115 = new Item(){ ItemType = ItemValues.Default };
items12.Append(item105);
items12.Append(item106);
items12.Append(item107);
items12.Append(item108);
items12.Append(item109);
items12.Append(item110);
items12.Append(item111);
items12.Append(item112);
items12.Append(item113);
items12.Append(item114);
items12.Append(item115);
pivotField22.Append(items12);
PivotField pivotField23 = new PivotField(){ DataField = true, ShowAll = false };
PivotField pivotField24 = new PivotField(){ ShowAll = false };
PivotField pivotField25 = new PivotField(){ NumberFormatId = (UInt32Value)14U, ShowAll = false };
Items items13 = new Items(){ Count = (UInt32Value)5U };
Item item116 = new Item(){ Index = (UInt32Value)0U };
Item item117 = new Item(){ Index = (UInt32Value)1U };
Item item118 = new Item(){ Index = (UInt32Value)3U };
Item item119 = new Item(){ Index = (UInt32Value)2U };
Item item120 = new Item(){ ItemType = ItemValues.Default };
items13.Append(item116);
items13.Append(item117);
items13.Append(item118);
items13.Append(item119);
items13.Append(item120);
pivotField25.Append(items13);
PivotField pivotField26 = new PivotField(){ ShowAll = false };
PivotField pivotField27 = new PivotField(){ ShowAll = false, DefaultSubtotal = false };
Items items14 = new Items(){ Count = (UInt32Value)5U };
Item item121 = new Item(){ Index = (UInt32Value)0U };
Item item122 = new Item(){ Index = (UInt32Value)1U };
Item item123 = new Item(){ Index = (UInt32Value)2U };
Item item124 = new Item(){ Index = (UInt32Value)3U };
Item item125 = new Item(){ Index = (UInt32Value)4U };
items14.Append(item121);
items14.Append(item122);
items14.Append(item123);
items14.Append(item124);
items14.Append(item125);
pivotField27.Append(items14);
pivotFields4.Append(pivotField21);
pivotFields4.Append(pivotField22);
pivotFields4.Append(pivotField23);
pivotFields4.Append(pivotField24);
pivotFields4.Append(pivotField25);
pivotFields4.Append(pivotField26);
pivotFields4.Append(pivotField27);
RowFields rowFields4 = new RowFields(){ Count = (UInt32Value)1U };
Field field4 = new Field(){ Index = 1 };
rowFields4.Append(field4);
RowItems rowItems4 = new RowItems(){ Count = (UInt32Value)4U };
RowItem rowItem16 = new RowItem();
MemberPropertyIndex memberPropertyIndex13 = new MemberPropertyIndex();
rowItem16.Append(memberPropertyIndex13);
RowItem rowItem17 = new RowItem();
MemberPropertyIndex memberPropertyIndex14 = new MemberPropertyIndex(){ Val = 3 };
rowItem17.Append(memberPropertyIndex14);
RowItem rowItem18 = new RowItem();
MemberPropertyIndex memberPropertyIndex15 = new MemberPropertyIndex(){ Val = 4 };
rowItem18.Append(memberPropertyIndex15);
RowItem rowItem19 = new RowItem(){ ItemType = ItemValues.Grand };
MemberPropertyIndex memberPropertyIndex16 = new MemberPropertyIndex();
rowItem19.Append(memberPropertyIndex16);
rowItems4.Append(rowItem16);
rowItems4.Append(rowItem17);
rowItems4.Append(rowItem18);
rowItems4.Append(rowItem19);
ColumnItems columnItems4 = new ColumnItems(){ Count = (UInt32Value)1U };
RowItem rowItem20 = new RowItem();
columnItems4.Append(rowItem20);
DataFields dataFields4 = new DataFields(){ Count = (UInt32Value)1U };
DataField dataField4 = new DataField(){ Name = "Sum of Quantity", Field = (UInt32Value)2U, BaseField = 0, BaseItem = (UInt32Value)0U };
dataFields4.Append(dataField4);
ChartFormats chartFormats4 = new ChartFormats(){ Count = (UInt32Value)7U };
ChartFormat chartFormat23 = new ChartFormat(){ Chart = (UInt32Value)4U, Format = (UInt32Value)0U, Series = true };
PivotArea pivotArea23 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences23 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference23 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem45 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference23.Append(fieldItem45);
pivotAreaReferences23.Append(pivotAreaReference23);
pivotArea23.Append(pivotAreaReferences23);
chartFormat23.Append(pivotArea23);
ChartFormat chartFormat24 = new ChartFormat(){ Chart = (UInt32Value)5U, Format = (UInt32Value)2U, Series = true };
PivotArea pivotArea24 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences24 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference24 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem46 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference24.Append(fieldItem46);
pivotAreaReferences24.Append(pivotAreaReference24);
pivotArea24.Append(pivotAreaReferences24);
chartFormat24.Append(pivotArea24);
ChartFormat chartFormat25 = new ChartFormat(){ Chart = (UInt32Value)6U, Format = (UInt32Value)0U, Series = true };
PivotArea pivotArea25 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences25 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference25 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem47 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference25.Append(fieldItem47);
pivotAreaReferences25.Append(pivotAreaReference25);
pivotArea25.Append(pivotAreaReferences25);
chartFormat25.Append(pivotArea25);
ChartFormat chartFormat26 = new ChartFormat(){ Chart = (UInt32Value)7U, Format = (UInt32Value)14U, Series = true };
PivotArea pivotArea26 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences26 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference26 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem48 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference26.Append(fieldItem48);
pivotAreaReferences26.Append(pivotAreaReference26);
pivotArea26.Append(pivotAreaReferences26);
chartFormat26.Append(pivotArea26);
ChartFormat chartFormat27 = new ChartFormat(){ Chart = (UInt32Value)8U, Format = (UInt32Value)1U, Series = true };
PivotArea pivotArea27 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences27 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference27 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem49 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference27.Append(fieldItem49);
pivotAreaReferences27.Append(pivotAreaReference27);
pivotArea27.Append(pivotAreaReferences27);
chartFormat27.Append(pivotArea27);
ChartFormat chartFormat28 = new ChartFormat(){ Chart = (UInt32Value)9U, Format = (UInt32Value)15U, Series = true };
PivotArea pivotArea28 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences28 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference28 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem50 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference28.Append(fieldItem50);
pivotAreaReferences28.Append(pivotAreaReference28);
pivotArea28.Append(pivotAreaReferences28);
chartFormat28.Append(pivotArea28);
ChartFormat chartFormat29 = new ChartFormat(){ Chart = (UInt32Value)10U, Format = (UInt32Value)2U, Series = true };
PivotArea pivotArea29 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences29 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference29 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem51 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference29.Append(fieldItem51);
pivotAreaReferences29.Append(pivotAreaReference29);
pivotArea29.Append(pivotAreaReferences29);
chartFormat29.Append(pivotArea29);
chartFormats4.Append(chartFormat23);
chartFormats4.Append(chartFormat24);
chartFormats4.Append(chartFormat25);
chartFormats4.Append(chartFormat26);
chartFormats4.Append(chartFormat27);
chartFormats4.Append(chartFormat28);
chartFormats4.Append(chartFormat29);
PivotTableStyle pivotTableStyle4 = new PivotTableStyle(){ Name = "PivotStyleLight16", ShowRowHeaders = true, ShowColumnHeaders = true, ShowRowStripes = false, ShowColumnStripes = false, ShowLastColumn = true };
PivotTableDefinitionExtensionList pivotTableDefinitionExtensionList4 = new PivotTableDefinitionExtensionList();
PivotTableDefinitionExtension pivotTableDefinitionExtension4 = new PivotTableDefinitionExtension(){ Uri = "{962EF5D1-5CA2-4c93-8EF4-DBF5C05439D2}" };
pivotTableDefinitionExtension4.AddNamespaceDeclaration("x14", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/main");
X14.PivotTableDefinition pivotTableDefinition8 = new X14.PivotTableDefinition(){ HideValuesRow = true };
pivotTableDefinition8.AddNamespaceDeclaration("xm", "http://schemas.microsoft.com/office/excel/2006/main");
pivotTableDefinitionExtension4.Append(pivotTableDefinition8);
pivotTableDefinitionExtensionList4.Append(pivotTableDefinitionExtension4);
pivotTableDefinition7.Append(location4);
pivotTableDefinition7.Append(pivotFields4);
pivotTableDefinition7.Append(rowFields4);
pivotTableDefinition7.Append(rowItems4);
pivotTableDefinition7.Append(columnItems4);
pivotTableDefinition7.Append(dataFields4);
pivotTableDefinition7.Append(chartFormats4);
pivotTableDefinition7.Append(pivotTableStyle4);
pivotTableDefinition7.Append(pivotTableDefinitionExtensionList4);
pivotTablePart4.PivotTableDefinition = pivotTableDefinition7;
}
// Generates content of pivotTablePart9.
private void GeneratePivotTablePart9Content(PivotTablePart pivotTablePart9)
{
PivotTableDefinition pivotTableDefinition17 = new PivotTableDefinition(){ Name = "PivotTable1", CacheId = (UInt32Value)1U, ApplyNumberFormats = false, ApplyBorderFormats = false, ApplyFontFormats = false, ApplyPatternFormats = false, ApplyAlignmentFormats = false, ApplyWidthHeightFormats = true, DataCaption = "Values", UpdatedVersion = 5, MinRefreshableVersion = 5, UseAutoFormatting = true, ItemPrintTitles = true, CreatedVersion = 4, Indent = (UInt32Value)0U, Outline = true, OutlineData = true, MultipleFieldFilters = false, ChartFormat = (UInt32Value)17U };
Location location9 = new Location(){ Reference = "A1:B5", FirstHeaderRow = (UInt32Value)1U, FirstDataRow = (UInt32Value)1U, FirstDataColumn = (UInt32Value)1U };
PivotFields pivotFields9 = new PivotFields(){ Count = (UInt32Value)7U };
PivotField pivotField56 = new PivotField(){ NumberFormatId = (UInt32Value)14U, ShowAll = false };
Items items31 = new Items(){ Count = (UInt32Value)15U };
Item item270 = new Item(){ Index = (UInt32Value)0U };
Item item271 = new Item(){ Index = (UInt32Value)1U };
Item item272 = new Item(){ Index = (UInt32Value)2U };
Item item273 = new Item(){ Index = (UInt32Value)3U };
Item item274 = new Item(){ Index = (UInt32Value)4U };
Item item275 = new Item(){ Index = (UInt32Value)5U };
Item item276 = new Item(){ Index = (UInt32Value)6U };
Item item277 = new Item(){ Index = (UInt32Value)7U };
Item item278 = new Item(){ Index = (UInt32Value)8U };
Item item279 = new Item(){ Index = (UInt32Value)9U };
Item item280 = new Item(){ Index = (UInt32Value)10U };
Item item281 = new Item(){ Index = (UInt32Value)11U };
Item item282 = new Item(){ Index = (UInt32Value)12U };
Item item283 = new Item(){ Index = (UInt32Value)13U };
Item item284 = new Item(){ ItemType = ItemValues.Default };
items31.Append(item270);
items31.Append(item271);
items31.Append(item272);
items31.Append(item273);
items31.Append(item274);
items31.Append(item275);
items31.Append(item276);
items31.Append(item277);
items31.Append(item278);
items31.Append(item279);
items31.Append(item280);
items31.Append(item281);
items31.Append(item282);
items31.Append(item283);
items31.Append(item284);
pivotField56.Append(items31);
PivotField pivotField57 = new PivotField(){ Axis = PivotTableAxisValues.AxisRow, ShowAll = false };
Items items32 = new Items(){ Count = (UInt32Value)11U };
Item item285 = new Item(){ Index = (UInt32Value)0U };
Item item286 = new Item(){ Missing = true, Index = (UInt32Value)4U };
Item item287 = new Item(){ Missing = true, Index = (UInt32Value)3U };
Item item288 = new Item(){ Index = (UInt32Value)1U };
Item item289 = new Item(){ Index = (UInt32Value)2U };
Item item290 = new Item(){ Missing = true, Index = (UInt32Value)9U };
Item item291 = new Item(){ Missing = true, Index = (UInt32Value)8U };
Item item292 = new Item(){ Missing = true, Index = (UInt32Value)7U };
Item item293 = new Item(){ Missing = true, Index = (UInt32Value)6U };
Item item294 = new Item(){ Missing = true, Index = (UInt32Value)5U };
Item item295 = new Item(){ ItemType = ItemValues.Default };
items32.Append(item285);
items32.Append(item286);
items32.Append(item287);
items32.Append(item288);
items32.Append(item289);
items32.Append(item290);
items32.Append(item291);
items32.Append(item292);
items32.Append(item293);
items32.Append(item294);
items32.Append(item295);
pivotField57.Append(items32);
PivotField pivotField58 = new PivotField(){ DataField = true, ShowAll = false };
PivotField pivotField59 = new PivotField(){ ShowAll = false };
PivotField pivotField60 = new PivotField(){ NumberFormatId = (UInt32Value)14U, ShowAll = false };
Items items33 = new Items(){ Count = (UInt32Value)5U };
Item item296 = new Item(){ Index = (UInt32Value)0U };
Item item297 = new Item(){ Index = (UInt32Value)1U };
Item item298 = new Item(){ Index = (UInt32Value)3U };
Item item299 = new Item(){ Index = (UInt32Value)2U };
Item item300 = new Item(){ ItemType = ItemValues.Default };
items33.Append(item296);
items33.Append(item297);
items33.Append(item298);
items33.Append(item299);
items33.Append(item300);
pivotField60.Append(items33);
PivotField pivotField61 = new PivotField(){ ShowAll = false };
PivotField pivotField62 = new PivotField(){ ShowAll = false, DefaultSubtotal = false };
Items items34 = new Items(){ Count = (UInt32Value)5U };
Item item301 = new Item(){ Index = (UInt32Value)0U };
Item item302 = new Item(){ Index = (UInt32Value)1U };
Item item303 = new Item(){ Index = (UInt32Value)2U };
Item item304 = new Item(){ Index = (UInt32Value)3U };
Item item305 = new Item(){ Index = (UInt32Value)4U };
items34.Append(item301);
items34.Append(item302);
items34.Append(item303);
items34.Append(item304);
items34.Append(item305);
pivotField62.Append(items34);
pivotFields9.Append(pivotField56);
pivotFields9.Append(pivotField57);
pivotFields9.Append(pivotField58);
pivotFields9.Append(pivotField59);
pivotFields9.Append(pivotField60);
pivotFields9.Append(pivotField61);
pivotFields9.Append(pivotField62);
RowFields rowFields9 = new RowFields(){ Count = (UInt32Value)1U };
Field field9 = new Field(){ Index = 1 };
rowFields9.Append(field9);
RowItems rowItems9 = new RowItems(){ Count = (UInt32Value)4U };
RowItem rowItem41 = new RowItem();
MemberPropertyIndex memberPropertyIndex33 = new MemberPropertyIndex();
rowItem41.Append(memberPropertyIndex33);
RowItem rowItem42 = new RowItem();
MemberPropertyIndex memberPropertyIndex34 = new MemberPropertyIndex(){ Val = 3 };
rowItem42.Append(memberPropertyIndex34);
RowItem rowItem43 = new RowItem();
MemberPropertyIndex memberPropertyIndex35 = new MemberPropertyIndex(){ Val = 4 };
rowItem43.Append(memberPropertyIndex35);
RowItem rowItem44 = new RowItem(){ ItemType = ItemValues.Grand };
MemberPropertyIndex memberPropertyIndex36 = new MemberPropertyIndex();
rowItem44.Append(memberPropertyIndex36);
rowItems9.Append(rowItem41);
rowItems9.Append(rowItem42);
rowItems9.Append(rowItem43);
rowItems9.Append(rowItem44);
ColumnItems columnItems9 = new ColumnItems(){ Count = (UInt32Value)1U };
RowItem rowItem45 = new RowItem();
columnItems9.Append(rowItem45);
DataFields dataFields9 = new DataFields(){ Count = (UInt32Value)1U };
DataField dataField9 = new DataField(){ Name = "Sum of Quantity", Field = (UInt32Value)2U, BaseField = 0, BaseItem = (UInt32Value)0U };
dataFields9.Append(dataField9);
ChartFormats chartFormats9 = new ChartFormats(){ Count = (UInt32Value)13U };
ChartFormat chartFormat70 = new ChartFormat(){ Chart = (UInt32Value)4U, Format = (UInt32Value)0U, Series = true };
PivotArea pivotArea70 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences70 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference70 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem92 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference70.Append(fieldItem92);
pivotAreaReferences70.Append(pivotAreaReference70);
pivotArea70.Append(pivotAreaReferences70);
chartFormat70.Append(pivotArea70);
ChartFormat chartFormat71 = new ChartFormat(){ Chart = (UInt32Value)5U, Format = (UInt32Value)2U, Series = true };
PivotArea pivotArea71 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences71 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference71 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem93 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference71.Append(fieldItem93);
pivotAreaReferences71.Append(pivotAreaReference71);
pivotArea71.Append(pivotAreaReferences71);
chartFormat71.Append(pivotArea71);
ChartFormat chartFormat72 = new ChartFormat(){ Chart = (UInt32Value)6U, Format = (UInt32Value)0U, Series = true };
PivotArea pivotArea72 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences72 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference72 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem94 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference72.Append(fieldItem94);
pivotAreaReferences72.Append(pivotAreaReference72);
pivotArea72.Append(pivotAreaReferences72);
chartFormat72.Append(pivotArea72);
ChartFormat chartFormat73 = new ChartFormat(){ Chart = (UInt32Value)7U, Format = (UInt32Value)14U, Series = true };
PivotArea pivotArea73 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences73 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference73 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem95 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference73.Append(fieldItem95);
pivotAreaReferences73.Append(pivotAreaReference73);
pivotArea73.Append(pivotAreaReferences73);
chartFormat73.Append(pivotArea73);
ChartFormat chartFormat74 = new ChartFormat(){ Chart = (UInt32Value)8U, Format = (UInt32Value)1U, Series = true };
PivotArea pivotArea74 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences74 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference74 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem96 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference74.Append(fieldItem96);
pivotAreaReferences74.Append(pivotAreaReference74);
pivotArea74.Append(pivotAreaReferences74);
chartFormat74.Append(pivotArea74);
ChartFormat chartFormat75 = new ChartFormat(){ Chart = (UInt32Value)9U, Format = (UInt32Value)15U, Series = true };
PivotArea pivotArea75 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences75 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference75 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem97 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference75.Append(fieldItem97);
pivotAreaReferences75.Append(pivotAreaReference75);
pivotArea75.Append(pivotAreaReferences75);
chartFormat75.Append(pivotArea75);
ChartFormat chartFormat76 = new ChartFormat(){ Chart = (UInt32Value)10U, Format = (UInt32Value)2U, Series = true };
PivotArea pivotArea76 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences76 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference76 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem98 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference76.Append(fieldItem98);
pivotAreaReferences76.Append(pivotAreaReference76);
pivotArea76.Append(pivotAreaReferences76);
chartFormat76.Append(pivotArea76);
ChartFormat chartFormat77 = new ChartFormat(){ Chart = (UInt32Value)11U, Format = (UInt32Value)16U, Series = true };
PivotArea pivotArea77 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences77 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference77 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem99 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference77.Append(fieldItem99);
pivotAreaReferences77.Append(pivotAreaReference77);
pivotArea77.Append(pivotAreaReferences77);
chartFormat77.Append(pivotArea77);
ChartFormat chartFormat78 = new ChartFormat(){ Chart = (UInt32Value)12U, Format = (UInt32Value)3U, Series = true };
PivotArea pivotArea78 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences78 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference78 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem100 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference78.Append(fieldItem100);
pivotAreaReferences78.Append(pivotAreaReference78);
pivotArea78.Append(pivotAreaReferences78);
chartFormat78.Append(pivotArea78);
ChartFormat chartFormat79 = new ChartFormat(){ Chart = (UInt32Value)13U, Format = (UInt32Value)17U, Series = true };
PivotArea pivotArea79 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences79 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference79 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem101 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference79.Append(fieldItem101);
pivotAreaReferences79.Append(pivotAreaReference79);
pivotArea79.Append(pivotAreaReferences79);
chartFormat79.Append(pivotArea79);
ChartFormat chartFormat80 = new ChartFormat(){ Chart = (UInt32Value)14U, Format = (UInt32Value)4U, Series = true };
PivotArea pivotArea80 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences80 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference80 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem102 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference80.Append(fieldItem102);
pivotAreaReferences80.Append(pivotAreaReference80);
pivotArea80.Append(pivotAreaReferences80);
chartFormat80.Append(pivotArea80);
ChartFormat chartFormat81 = new ChartFormat(){ Chart = (UInt32Value)15U, Format = (UInt32Value)18U, Series = true };
PivotArea pivotArea81 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences81 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference81 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem103 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference81.Append(fieldItem103);
pivotAreaReferences81.Append(pivotAreaReference81);
pivotArea81.Append(pivotAreaReferences81);
chartFormat81.Append(pivotArea81);
ChartFormat chartFormat82 = new ChartFormat(){ Chart = (UInt32Value)16U, Format = (UInt32Value)5U, Series = true };
PivotArea pivotArea82 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences82 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference82 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem104 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference82.Append(fieldItem104);
pivotAreaReferences82.Append(pivotAreaReference82);
pivotArea82.Append(pivotAreaReferences82);
chartFormat82.Append(pivotArea82);
chartFormats9.Append(chartFormat70);
chartFormats9.Append(chartFormat71);
chartFormats9.Append(chartFormat72);
chartFormats9.Append(chartFormat73);
chartFormats9.Append(chartFormat74);
chartFormats9.Append(chartFormat75);
chartFormats9.Append(chartFormat76);
chartFormats9.Append(chartFormat77);
chartFormats9.Append(chartFormat78);
chartFormats9.Append(chartFormat79);
chartFormats9.Append(chartFormat80);
chartFormats9.Append(chartFormat81);
chartFormats9.Append(chartFormat82);
PivotTableStyle pivotTableStyle9 = new PivotTableStyle(){ Name = "PivotStyleLight16", ShowRowHeaders = true, ShowColumnHeaders = true, ShowRowStripes = false, ShowColumnStripes = false, ShowLastColumn = true };
PivotFilters pivotFilters1 = new PivotFilters(){ Count = (UInt32Value)1U };
PivotFilter pivotFilter1 = new PivotFilter(){ Field = (UInt32Value)4U, Type = PivotFilterValues.DateBetween, EvaluationOrder = -1, Id = (UInt32Value)6U, Name = "DeliveryDate" };
AutoFilter autoFilter7 = new AutoFilter(){ Reference = "A1" };
FilterColumn filterColumn1 = new FilterColumn(){ ColumnId = (UInt32Value)0U };
CustomFilters customFilters1 = new CustomFilters(){ And = true };
CustomFilter customFilter1 = new CustomFilter(){ Operator = FilterOperatorValues.GreaterThanOrEqual, Val = "36526" };
CustomFilter customFilter2 = new CustomFilter(){ Operator = FilterOperatorValues.LessThanOrEqual, Val = "37986" };
customFilters1.Append(customFilter1);
customFilters1.Append(customFilter2);
filterColumn1.Append(customFilters1);
autoFilter7.Append(filterColumn1);
PivotFilterExtensionList pivotFilterExtensionList1 = new PivotFilterExtensionList();
PivotFilterExtension pivotFilterExtension1 = new PivotFilterExtension(){ Uri = "{0605FD5F-26C8-4aeb-8148-2DB25E43C511}" };
pivotFilterExtension1.AddNamespaceDeclaration("x15", "http://schemas.microsoft.com/office/spreadsheetml/2010/11/main");
X15.PivotFilter pivotFilter2 = new X15.PivotFilter(){ UseWholeDay = true };
pivotFilterExtension1.Append(pivotFilter2);
pivotFilterExtensionList1.Append(pivotFilterExtension1);
pivotFilter1.Append(autoFilter7);
pivotFilter1.Append(pivotFilterExtensionList1);
pivotFilters1.Append(pivotFilter1);
PivotTableDefinitionExtensionList pivotTableDefinitionExtensionList9 = new PivotTableDefinitionExtensionList();
PivotTableDefinitionExtension pivotTableDefinitionExtension9 = new PivotTableDefinitionExtension(){ Uri = "{962EF5D1-5CA2-4c93-8EF4-DBF5C05439D2}" };
pivotTableDefinitionExtension9.AddNamespaceDeclaration("x14", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/main");
X14.PivotTableDefinition pivotTableDefinition18 = new X14.PivotTableDefinition(){ HideValuesRow = true };
pivotTableDefinition18.AddNamespaceDeclaration("xm", "http://schemas.microsoft.com/office/excel/2006/main");
pivotTableDefinitionExtension9.Append(pivotTableDefinition18);
pivotTableDefinitionExtensionList9.Append(pivotTableDefinitionExtension9);
pivotTableDefinition17.Append(location9);
pivotTableDefinition17.Append(pivotFields9);
pivotTableDefinition17.Append(rowFields9);
pivotTableDefinition17.Append(rowItems9);
pivotTableDefinition17.Append(columnItems9);
pivotTableDefinition17.Append(dataFields9);
pivotTableDefinition17.Append(chartFormats9);
pivotTableDefinition17.Append(pivotTableStyle9);
pivotTableDefinition17.Append(pivotFilters1);
pivotTableDefinition17.Append(pivotTableDefinitionExtensionList9);
pivotTablePart9.PivotTableDefinition = pivotTableDefinition17;
}
// Generates content of pivotTablePart8.
private void GeneratePivotTablePart8Content(PivotTablePart pivotTablePart8)
{
PivotTableDefinition pivotTableDefinition15 = new PivotTableDefinition(){ Name = "PivotTable1", CacheId = (UInt32Value)1U, ApplyNumberFormats = false, ApplyBorderFormats = false, ApplyFontFormats = false, ApplyPatternFormats = false, ApplyAlignmentFormats = false, ApplyWidthHeightFormats = true, DataCaption = "Values", UpdatedVersion = 5, MinRefreshableVersion = 5, UseAutoFormatting = true, ItemPrintTitles = true, CreatedVersion = 4, Indent = (UInt32Value)0U, Outline = true, OutlineData = true, MultipleFieldFilters = false, ChartFormat = (UInt32Value)7U };
Location location8 = new Location(){ Reference = "A1:B5", FirstHeaderRow = (UInt32Value)1U, FirstDataRow = (UInt32Value)1U, FirstDataColumn = (UInt32Value)1U };
PivotFields pivotFields8 = new PivotFields(){ Count = (UInt32Value)7U };
PivotField pivotField49 = new PivotField(){ NumberFormatId = (UInt32Value)14U, ShowAll = false };
Items items27 = new Items(){ Count = (UInt32Value)15U };
Item item234 = new Item(){ Index = (UInt32Value)0U };
Item item235 = new Item(){ Index = (UInt32Value)1U };
Item item236 = new Item(){ Index = (UInt32Value)2U };
Item item237 = new Item(){ Index = (UInt32Value)3U };
Item item238 = new Item(){ Index = (UInt32Value)4U };
Item item239 = new Item(){ Index = (UInt32Value)5U };
Item item240 = new Item(){ Index = (UInt32Value)6U };
Item item241 = new Item(){ Index = (UInt32Value)7U };
Item item242 = new Item(){ Index = (UInt32Value)8U };
Item item243 = new Item(){ Index = (UInt32Value)9U };
Item item244 = new Item(){ Index = (UInt32Value)10U };
Item item245 = new Item(){ Index = (UInt32Value)11U };
Item item246 = new Item(){ Index = (UInt32Value)12U };
Item item247 = new Item(){ Index = (UInt32Value)13U };
Item item248 = new Item(){ ItemType = ItemValues.Default };
items27.Append(item234);
items27.Append(item235);
items27.Append(item236);
items27.Append(item237);
items27.Append(item238);
items27.Append(item239);
items27.Append(item240);
items27.Append(item241);
items27.Append(item242);
items27.Append(item243);
items27.Append(item244);
items27.Append(item245);
items27.Append(item246);
items27.Append(item247);
items27.Append(item248);
pivotField49.Append(items27);
PivotField pivotField50 = new PivotField(){ Axis = PivotTableAxisValues.AxisRow, ShowAll = false };
Items items28 = new Items(){ Count = (UInt32Value)11U };
Item item249 = new Item(){ Index = (UInt32Value)0U };
Item item250 = new Item(){ Missing = true, Index = (UInt32Value)4U };
Item item251 = new Item(){ Missing = true, Index = (UInt32Value)3U };
Item item252 = new Item(){ Index = (UInt32Value)1U };
Item item253 = new Item(){ Index = (UInt32Value)2U };
Item item254 = new Item(){ Missing = true, Index = (UInt32Value)9U };
Item item255 = new Item(){ Missing = true, Index = (UInt32Value)8U };
Item item256 = new Item(){ Missing = true, Index = (UInt32Value)7U };
Item item257 = new Item(){ Missing = true, Index = (UInt32Value)6U };
Item item258 = new Item(){ Missing = true, Index = (UInt32Value)5U };
Item item259 = new Item(){ ItemType = ItemValues.Default };
items28.Append(item249);
items28.Append(item250);
items28.Append(item251);
items28.Append(item252);
items28.Append(item253);
items28.Append(item254);
items28.Append(item255);
items28.Append(item256);
items28.Append(item257);
items28.Append(item258);
items28.Append(item259);
pivotField50.Append(items28);
PivotField pivotField51 = new PivotField(){ DataField = true, ShowAll = false };
PivotField pivotField52 = new PivotField(){ ShowAll = false };
PivotField pivotField53 = new PivotField(){ NumberFormatId = (UInt32Value)14U, ShowAll = false };
Items items29 = new Items(){ Count = (UInt32Value)5U };
Item item260 = new Item(){ Index = (UInt32Value)0U };
Item item261 = new Item(){ Index = (UInt32Value)1U };
Item item262 = new Item(){ Index = (UInt32Value)3U };
Item item263 = new Item(){ Index = (UInt32Value)2U };
Item item264 = new Item(){ ItemType = ItemValues.Default };
items29.Append(item260);
items29.Append(item261);
items29.Append(item262);
items29.Append(item263);
items29.Append(item264);
pivotField53.Append(items29);
PivotField pivotField54 = new PivotField(){ ShowAll = false };
PivotField pivotField55 = new PivotField(){ ShowAll = false, DefaultSubtotal = false };
Items items30 = new Items(){ Count = (UInt32Value)5U };
Item item265 = new Item(){ Index = (UInt32Value)0U };
Item item266 = new Item(){ Index = (UInt32Value)1U };
Item item267 = new Item(){ Index = (UInt32Value)2U };
Item item268 = new Item(){ Index = (UInt32Value)3U };
Item item269 = new Item(){ Index = (UInt32Value)4U };
items30.Append(item265);
items30.Append(item266);
items30.Append(item267);
items30.Append(item268);
items30.Append(item269);
pivotField55.Append(items30);
pivotFields8.Append(pivotField49);
pivotFields8.Append(pivotField50);
pivotFields8.Append(pivotField51);
pivotFields8.Append(pivotField52);
pivotFields8.Append(pivotField53);
pivotFields8.Append(pivotField54);
pivotFields8.Append(pivotField55);
RowFields rowFields8 = new RowFields(){ Count = (UInt32Value)1U };
Field field8 = new Field(){ Index = 1 };
rowFields8.Append(field8);
RowItems rowItems8 = new RowItems(){ Count = (UInt32Value)4U };
RowItem rowItem36 = new RowItem();
MemberPropertyIndex memberPropertyIndex29 = new MemberPropertyIndex();
rowItem36.Append(memberPropertyIndex29);
RowItem rowItem37 = new RowItem();
MemberPropertyIndex memberPropertyIndex30 = new MemberPropertyIndex(){ Val = 3 };
rowItem37.Append(memberPropertyIndex30);
RowItem rowItem38 = new RowItem();
MemberPropertyIndex memberPropertyIndex31 = new MemberPropertyIndex(){ Val = 4 };
rowItem38.Append(memberPropertyIndex31);
RowItem rowItem39 = new RowItem(){ ItemType = ItemValues.Grand };
MemberPropertyIndex memberPropertyIndex32 = new MemberPropertyIndex();
rowItem39.Append(memberPropertyIndex32);
rowItems8.Append(rowItem36);
rowItems8.Append(rowItem37);
rowItems8.Append(rowItem38);
rowItems8.Append(rowItem39);
ColumnItems columnItems8 = new ColumnItems(){ Count = (UInt32Value)1U };
RowItem rowItem40 = new RowItem();
columnItems8.Append(rowItem40);
DataFields dataFields8 = new DataFields(){ Count = (UInt32Value)1U };
DataField dataField8 = new DataField(){ Name = "Sum of Quantity", Field = (UInt32Value)2U, BaseField = 0, BaseItem = (UInt32Value)0U };
dataFields8.Append(dataField8);
ChartFormats chartFormats8 = new ChartFormats(){ Count = (UInt32Value)3U };
ChartFormat chartFormat67 = new ChartFormat(){ Chart = (UInt32Value)4U, Format = (UInt32Value)0U, Series = true };
PivotArea pivotArea67 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences67 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference67 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem89 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference67.Append(fieldItem89);
pivotAreaReferences67.Append(pivotAreaReference67);
pivotArea67.Append(pivotAreaReferences67);
chartFormat67.Append(pivotArea67);
ChartFormat chartFormat68 = new ChartFormat(){ Chart = (UInt32Value)5U, Format = (UInt32Value)2U, Series = true };
PivotArea pivotArea68 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences68 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference68 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem90 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference68.Append(fieldItem90);
pivotAreaReferences68.Append(pivotAreaReference68);
pivotArea68.Append(pivotAreaReferences68);
chartFormat68.Append(pivotArea68);
ChartFormat chartFormat69 = new ChartFormat(){ Chart = (UInt32Value)6U, Format = (UInt32Value)0U, Series = true };
PivotArea pivotArea69 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences69 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference69 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem91 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference69.Append(fieldItem91);
pivotAreaReferences69.Append(pivotAreaReference69);
pivotArea69.Append(pivotAreaReferences69);
chartFormat69.Append(pivotArea69);
chartFormats8.Append(chartFormat67);
chartFormats8.Append(chartFormat68);
chartFormats8.Append(chartFormat69);
PivotTableStyle pivotTableStyle8 = new PivotTableStyle(){ Name = "PivotStyleLight16", ShowRowHeaders = true, ShowColumnHeaders = true, ShowRowStripes = false, ShowColumnStripes = false, ShowLastColumn = true };
PivotTableDefinitionExtensionList pivotTableDefinitionExtensionList8 = new PivotTableDefinitionExtensionList();
PivotTableDefinitionExtension pivotTableDefinitionExtension8 = new PivotTableDefinitionExtension(){ Uri = "{962EF5D1-5CA2-4c93-8EF4-DBF5C05439D2}" };
pivotTableDefinitionExtension8.AddNamespaceDeclaration("x14", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/main");
X14.PivotTableDefinition pivotTableDefinition16 = new X14.PivotTableDefinition(){ HideValuesRow = true };
pivotTableDefinition16.AddNamespaceDeclaration("xm", "http://schemas.microsoft.com/office/excel/2006/main");
pivotTableDefinitionExtension8.Append(pivotTableDefinition16);
pivotTableDefinitionExtensionList8.Append(pivotTableDefinitionExtension8);
pivotTableDefinition15.Append(location8);
pivotTableDefinition15.Append(pivotFields8);
pivotTableDefinition15.Append(rowFields8);
pivotTableDefinition15.Append(rowItems8);
pivotTableDefinition15.Append(columnItems8);
pivotTableDefinition15.Append(dataFields8);
pivotTableDefinition15.Append(chartFormats8);
pivotTableDefinition15.Append(pivotTableStyle8);
pivotTableDefinition15.Append(pivotTableDefinitionExtensionList8);
pivotTablePart8.PivotTableDefinition = pivotTableDefinition15;
}
// Generates content of pivotTablePart7.
private void GeneratePivotTablePart7Content(PivotTablePart pivotTablePart7)
{
PivotTableDefinition pivotTableDefinition13 = new PivotTableDefinition(){ Name = "PivotTable1", CacheId = (UInt32Value)1U, ApplyNumberFormats = false, ApplyBorderFormats = false, ApplyFontFormats = false, ApplyPatternFormats = false, ApplyAlignmentFormats = false, ApplyWidthHeightFormats = true, DataCaption = "Values", UpdatedVersion = 5, MinRefreshableVersion = 5, UseAutoFormatting = true, ItemPrintTitles = true, CreatedVersion = 4, Indent = (UInt32Value)0U, Outline = true, OutlineData = true, MultipleFieldFilters = false, ChartFormat = (UInt32Value)19U };
Location location7 = new Location(){ Reference = "A1:B5", FirstHeaderRow = (UInt32Value)1U, FirstDataRow = (UInt32Value)1U, FirstDataColumn = (UInt32Value)1U };
PivotFields pivotFields7 = new PivotFields(){ Count = (UInt32Value)7U };
PivotField pivotField42 = new PivotField(){ NumberFormatId = (UInt32Value)14U, ShowAll = false };
Items items23 = new Items(){ Count = (UInt32Value)15U };
Item item198 = new Item(){ Index = (UInt32Value)0U };
Item item199 = new Item(){ Index = (UInt32Value)1U };
Item item200 = new Item(){ Index = (UInt32Value)2U };
Item item201 = new Item(){ Index = (UInt32Value)3U };
Item item202 = new Item(){ Index = (UInt32Value)4U };
Item item203 = new Item(){ Index = (UInt32Value)5U };
Item item204 = new Item(){ Index = (UInt32Value)6U };
Item item205 = new Item(){ Index = (UInt32Value)7U };
Item item206 = new Item(){ Index = (UInt32Value)8U };
Item item207 = new Item(){ Index = (UInt32Value)9U };
Item item208 = new Item(){ Index = (UInt32Value)10U };
Item item209 = new Item(){ Index = (UInt32Value)11U };
Item item210 = new Item(){ Index = (UInt32Value)12U };
Item item211 = new Item(){ Index = (UInt32Value)13U };
Item item212 = new Item(){ ItemType = ItemValues.Default };
items23.Append(item198);
items23.Append(item199);
items23.Append(item200);
items23.Append(item201);
items23.Append(item202);
items23.Append(item203);
items23.Append(item204);
items23.Append(item205);
items23.Append(item206);
items23.Append(item207);
items23.Append(item208);
items23.Append(item209);
items23.Append(item210);
items23.Append(item211);
items23.Append(item212);
pivotField42.Append(items23);
PivotField pivotField43 = new PivotField(){ Axis = PivotTableAxisValues.AxisRow, ShowAll = false };
Items items24 = new Items(){ Count = (UInt32Value)11U };
Item item213 = new Item(){ Index = (UInt32Value)0U };
Item item214 = new Item(){ Missing = true, Index = (UInt32Value)4U };
Item item215 = new Item(){ Missing = true, Index = (UInt32Value)3U };
Item item216 = new Item(){ Index = (UInt32Value)1U };
Item item217 = new Item(){ Index = (UInt32Value)2U };
Item item218 = new Item(){ Missing = true, Index = (UInt32Value)9U };
Item item219 = new Item(){ Missing = true, Index = (UInt32Value)8U };
Item item220 = new Item(){ Missing = true, Index = (UInt32Value)7U };
Item item221 = new Item(){ Missing = true, Index = (UInt32Value)6U };
Item item222 = new Item(){ Missing = true, Index = (UInt32Value)5U };
Item item223 = new Item(){ ItemType = ItemValues.Default };
items24.Append(item213);
items24.Append(item214);
items24.Append(item215);
items24.Append(item216);
items24.Append(item217);
items24.Append(item218);
items24.Append(item219);
items24.Append(item220);
items24.Append(item221);
items24.Append(item222);
items24.Append(item223);
pivotField43.Append(items24);
PivotField pivotField44 = new PivotField(){ DataField = true, ShowAll = false };
PivotField pivotField45 = new PivotField(){ ShowAll = false };
PivotField pivotField46 = new PivotField(){ NumberFormatId = (UInt32Value)14U, ShowAll = false };
Items items25 = new Items(){ Count = (UInt32Value)5U };
Item item224 = new Item(){ Index = (UInt32Value)0U };
Item item225 = new Item(){ Index = (UInt32Value)1U };
Item item226 = new Item(){ Index = (UInt32Value)3U };
Item item227 = new Item(){ Index = (UInt32Value)2U };
Item item228 = new Item(){ ItemType = ItemValues.Default };
items25.Append(item224);
items25.Append(item225);
items25.Append(item226);
items25.Append(item227);
items25.Append(item228);
pivotField46.Append(items25);
PivotField pivotField47 = new PivotField(){ ShowAll = false };
PivotField pivotField48 = new PivotField(){ ShowAll = false, DefaultSubtotal = false };
Items items26 = new Items(){ Count = (UInt32Value)5U };
Item item229 = new Item(){ Index = (UInt32Value)0U };
Item item230 = new Item(){ Index = (UInt32Value)1U };
Item item231 = new Item(){ Index = (UInt32Value)2U };
Item item232 = new Item(){ Index = (UInt32Value)3U };
Item item233 = new Item(){ Index = (UInt32Value)4U };
items26.Append(item229);
items26.Append(item230);
items26.Append(item231);
items26.Append(item232);
items26.Append(item233);
pivotField48.Append(items26);
pivotFields7.Append(pivotField42);
pivotFields7.Append(pivotField43);
pivotFields7.Append(pivotField44);
pivotFields7.Append(pivotField45);
pivotFields7.Append(pivotField46);
pivotFields7.Append(pivotField47);
pivotFields7.Append(pivotField48);
RowFields rowFields7 = new RowFields(){ Count = (UInt32Value)1U };
Field field7 = new Field(){ Index = 1 };
rowFields7.Append(field7);
RowItems rowItems7 = new RowItems(){ Count = (UInt32Value)4U };
RowItem rowItem31 = new RowItem();
MemberPropertyIndex memberPropertyIndex25 = new MemberPropertyIndex();
rowItem31.Append(memberPropertyIndex25);
RowItem rowItem32 = new RowItem();
MemberPropertyIndex memberPropertyIndex26 = new MemberPropertyIndex(){ Val = 3 };
rowItem32.Append(memberPropertyIndex26);
RowItem rowItem33 = new RowItem();
MemberPropertyIndex memberPropertyIndex27 = new MemberPropertyIndex(){ Val = 4 };
rowItem33.Append(memberPropertyIndex27);
RowItem rowItem34 = new RowItem(){ ItemType = ItemValues.Grand };
MemberPropertyIndex memberPropertyIndex28 = new MemberPropertyIndex();
rowItem34.Append(memberPropertyIndex28);
rowItems7.Append(rowItem31);
rowItems7.Append(rowItem32);
rowItems7.Append(rowItem33);
rowItems7.Append(rowItem34);
ColumnItems columnItems7 = new ColumnItems(){ Count = (UInt32Value)1U };
RowItem rowItem35 = new RowItem();
columnItems7.Append(rowItem35);
DataFields dataFields7 = new DataFields(){ Count = (UInt32Value)1U };
DataField dataField7 = new DataField(){ Name = "Sum of Quantity", Field = (UInt32Value)2U, BaseField = 0, BaseItem = (UInt32Value)0U };
dataFields7.Append(dataField7);
ChartFormats chartFormats7 = new ChartFormats(){ Count = (UInt32Value)15U };
ChartFormat chartFormat52 = new ChartFormat(){ Chart = (UInt32Value)4U, Format = (UInt32Value)0U, Series = true };
PivotArea pivotArea52 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences52 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference52 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem74 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference52.Append(fieldItem74);
pivotAreaReferences52.Append(pivotAreaReference52);
pivotArea52.Append(pivotAreaReferences52);
chartFormat52.Append(pivotArea52);
ChartFormat chartFormat53 = new ChartFormat(){ Chart = (UInt32Value)5U, Format = (UInt32Value)2U, Series = true };
PivotArea pivotArea53 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences53 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference53 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem75 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference53.Append(fieldItem75);
pivotAreaReferences53.Append(pivotAreaReference53);
pivotArea53.Append(pivotAreaReferences53);
chartFormat53.Append(pivotArea53);
ChartFormat chartFormat54 = new ChartFormat(){ Chart = (UInt32Value)6U, Format = (UInt32Value)0U, Series = true };
PivotArea pivotArea54 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences54 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference54 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem76 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference54.Append(fieldItem76);
pivotAreaReferences54.Append(pivotAreaReference54);
pivotArea54.Append(pivotAreaReferences54);
chartFormat54.Append(pivotArea54);
ChartFormat chartFormat55 = new ChartFormat(){ Chart = (UInt32Value)7U, Format = (UInt32Value)14U, Series = true };
PivotArea pivotArea55 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences55 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference55 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem77 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference55.Append(fieldItem77);
pivotAreaReferences55.Append(pivotAreaReference55);
pivotArea55.Append(pivotAreaReferences55);
chartFormat55.Append(pivotArea55);
ChartFormat chartFormat56 = new ChartFormat(){ Chart = (UInt32Value)8U, Format = (UInt32Value)1U, Series = true };
PivotArea pivotArea56 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences56 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference56 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem78 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference56.Append(fieldItem78);
pivotAreaReferences56.Append(pivotAreaReference56);
pivotArea56.Append(pivotAreaReferences56);
chartFormat56.Append(pivotArea56);
ChartFormat chartFormat57 = new ChartFormat(){ Chart = (UInt32Value)9U, Format = (UInt32Value)15U, Series = true };
PivotArea pivotArea57 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences57 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference57 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem79 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference57.Append(fieldItem79);
pivotAreaReferences57.Append(pivotAreaReference57);
pivotArea57.Append(pivotAreaReferences57);
chartFormat57.Append(pivotArea57);
ChartFormat chartFormat58 = new ChartFormat(){ Chart = (UInt32Value)10U, Format = (UInt32Value)2U, Series = true };
PivotArea pivotArea58 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences58 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference58 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem80 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference58.Append(fieldItem80);
pivotAreaReferences58.Append(pivotAreaReference58);
pivotArea58.Append(pivotAreaReferences58);
chartFormat58.Append(pivotArea58);
ChartFormat chartFormat59 = new ChartFormat(){ Chart = (UInt32Value)11U, Format = (UInt32Value)16U, Series = true };
PivotArea pivotArea59 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences59 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference59 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem81 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference59.Append(fieldItem81);
pivotAreaReferences59.Append(pivotAreaReference59);
pivotArea59.Append(pivotAreaReferences59);
chartFormat59.Append(pivotArea59);
ChartFormat chartFormat60 = new ChartFormat(){ Chart = (UInt32Value)12U, Format = (UInt32Value)3U, Series = true };
PivotArea pivotArea60 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences60 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference60 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem82 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference60.Append(fieldItem82);
pivotAreaReferences60.Append(pivotAreaReference60);
pivotArea60.Append(pivotAreaReferences60);
chartFormat60.Append(pivotArea60);
ChartFormat chartFormat61 = new ChartFormat(){ Chart = (UInt32Value)13U, Format = (UInt32Value)17U, Series = true };
PivotArea pivotArea61 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences61 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference61 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem83 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference61.Append(fieldItem83);
pivotAreaReferences61.Append(pivotAreaReference61);
pivotArea61.Append(pivotAreaReferences61);
chartFormat61.Append(pivotArea61);
ChartFormat chartFormat62 = new ChartFormat(){ Chart = (UInt32Value)14U, Format = (UInt32Value)4U, Series = true };
PivotArea pivotArea62 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences62 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference62 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem84 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference62.Append(fieldItem84);
pivotAreaReferences62.Append(pivotAreaReference62);
pivotArea62.Append(pivotAreaReferences62);
chartFormat62.Append(pivotArea62);
ChartFormat chartFormat63 = new ChartFormat(){ Chart = (UInt32Value)15U, Format = (UInt32Value)18U, Series = true };
PivotArea pivotArea63 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences63 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference63 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem85 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference63.Append(fieldItem85);
pivotAreaReferences63.Append(pivotAreaReference63);
pivotArea63.Append(pivotAreaReferences63);
chartFormat63.Append(pivotArea63);
ChartFormat chartFormat64 = new ChartFormat(){ Chart = (UInt32Value)16U, Format = (UInt32Value)5U, Series = true };
PivotArea pivotArea64 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences64 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference64 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem86 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference64.Append(fieldItem86);
pivotAreaReferences64.Append(pivotAreaReference64);
pivotArea64.Append(pivotAreaReferences64);
chartFormat64.Append(pivotArea64);
ChartFormat chartFormat65 = new ChartFormat(){ Chart = (UInt32Value)17U, Format = (UInt32Value)19U, Series = true };
PivotArea pivotArea65 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences65 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference65 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem87 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference65.Append(fieldItem87);
pivotAreaReferences65.Append(pivotAreaReference65);
pivotArea65.Append(pivotAreaReferences65);
chartFormat65.Append(pivotArea65);
ChartFormat chartFormat66 = new ChartFormat(){ Chart = (UInt32Value)18U, Format = (UInt32Value)6U, Series = true };
PivotArea pivotArea66 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences66 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference66 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem88 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference66.Append(fieldItem88);
pivotAreaReferences66.Append(pivotAreaReference66);
pivotArea66.Append(pivotAreaReferences66);
chartFormat66.Append(pivotArea66);
chartFormats7.Append(chartFormat52);
chartFormats7.Append(chartFormat53);
chartFormats7.Append(chartFormat54);
chartFormats7.Append(chartFormat55);
chartFormats7.Append(chartFormat56);
chartFormats7.Append(chartFormat57);
chartFormats7.Append(chartFormat58);
chartFormats7.Append(chartFormat59);
chartFormats7.Append(chartFormat60);
chartFormats7.Append(chartFormat61);
chartFormats7.Append(chartFormat62);
chartFormats7.Append(chartFormat63);
chartFormats7.Append(chartFormat64);
chartFormats7.Append(chartFormat65);
chartFormats7.Append(chartFormat66);
PivotTableStyle pivotTableStyle7 = new PivotTableStyle(){ Name = "PivotStyleLight16", ShowRowHeaders = true, ShowColumnHeaders = true, ShowRowStripes = false, ShowColumnStripes = false, ShowLastColumn = true };
PivotTableDefinitionExtensionList pivotTableDefinitionExtensionList7 = new PivotTableDefinitionExtensionList();
PivotTableDefinitionExtension pivotTableDefinitionExtension7 = new PivotTableDefinitionExtension(){ Uri = "{962EF5D1-5CA2-4c93-8EF4-DBF5C05439D2}" };
pivotTableDefinitionExtension7.AddNamespaceDeclaration("x14", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/main");
X14.PivotTableDefinition pivotTableDefinition14 = new X14.PivotTableDefinition(){ HideValuesRow = true };
pivotTableDefinition14.AddNamespaceDeclaration("xm", "http://schemas.microsoft.com/office/excel/2006/main");
pivotTableDefinitionExtension7.Append(pivotTableDefinition14);
pivotTableDefinitionExtensionList7.Append(pivotTableDefinitionExtension7);
pivotTableDefinition13.Append(location7);
pivotTableDefinition13.Append(pivotFields7);
pivotTableDefinition13.Append(rowFields7);
pivotTableDefinition13.Append(rowItems7);
pivotTableDefinition13.Append(columnItems7);
pivotTableDefinition13.Append(dataFields7);
pivotTableDefinition13.Append(chartFormats7);
pivotTableDefinition13.Append(pivotTableStyle7);
pivotTableDefinition13.Append(pivotTableDefinitionExtensionList7);
pivotTablePart7.PivotTableDefinition = pivotTableDefinition13;
}
/// <summary>
/// Рассчет параметров графика
/// </summary>
/// <param name="OriginalItems">Коллекция элементов для отображения</param>
/// <param name="MinDate">Начальная дата для масштабирования</param>
/// <param name="MaxDate">Конечная дата для масштабирования</param>
public void CalcCutRect(Rows OriginalItems, DateTime MinDate, DateTime MaxDate)
{
RegionItem = null;
// устанавливаем масштаб
minTime = MinDate;
maxTime = MaxDate;
if (OriginalItems == null)
return;
// определяем высоту для данного шрифта
{
Graphics gr = CreateGraphics();
strSize = gr.MeasureString(GetBiggerString(OriginalItems), base.Font);
SizeF DateString = gr.MeasureString("sometext\r\nsometext", DateFont);
GraphHeight = rowHeight * OriginalItems.Count + DateString.Height + 2 * rowIndentVer;
}
if (GraphHeight > Height) // если график не вмещается изменяем размер холста
{
this.Height = (int)Math.Round(GraphHeight);
}
else
{
// если график вмещается, то устанавливаем размер холста, как у родительского контейнера
this.Height = base.Height;
}
float GraphBeginY = (Height - GraphHeight) / 2;
// определяем длину расписания в минутах
double ScheduleLen = (maxTime - minTime).TotalMinutes;
// определяем масштаб
double PixelByMinute = (Width - strSize.Width - 3 * rowIndentHor) / ScheduleLen;
// определяем позиции верхнего левого угла для координат
AxesXZeroPoint = (int)Math.Round(strSize.Width + 2 * rowIndentHor);
AxesYZeroPoint = (int)Math.Round(GraphBeginY + rowHeight);
if (items != null)
items.Clear();
else
items = new Rows();
for (int i = 0; i < OriginalItems.Count; i++)
{
Row new_row = new Row(OriginalItems[i].Text);
for (int j = 0; j < OriginalItems[i].Count; j++)
{
DateTime t1 = OriginalItems[i][j].BeginDate;
DateTime t2 = OriginalItems[i][j].EndDate;
// если время обработки пересекает линию начала
if (OriginalItems[i][j].BeginDate < minTime)
t1 = minTime;
// если время обработки пересекает линию начала
if (OriginalItems[i][j].EndDate > maxTime)
t2 = maxTime;
double MinuteBegin = (t1 - minTime).TotalMinutes;
double MinuteEnd = (t2 - minTime).TotalMinutes;
if (MinuteEnd - MinuteBegin > 0)
{
RowItem rowitem = new RowItem(OriginalItems[i][j].Text, OriginalItems[i][j].Index, OriginalItems[i][j].OrderIndex, t1, t2);
rowitem.RealBeginDate = OriginalItems[i][j].BeginDate;
rowitem.RealEndDate = OriginalItems[i][j].EndDate;
rowitem.IsAlert = OriginalItems[i][j].IsAlert;
rowitem.DrawRegion = new Rectangle(
(int)(AxesXZeroPoint + MinuteBegin * PixelByMinute),
(int)(AxesYZeroPoint + rowHeight * i + rowIndentVer),
(int)((MinuteEnd - MinuteBegin) * PixelByMinute),
(int)(rowHeight - 2 * rowIndentVer));
new_row.Add(rowitem);
}
}
items.Add(new_row);
}
if (RegionItem != null)
SetSelected(RegionItem.Index);
items.Gluing();
}
public void SetSelected(int Index)
{
if (Index == -1)
{
RegionItem = null;
Refresh();
return;
}
foreach (Row row_item in items)
{
foreach (RowItem item in row_item)
{
if (item.Index == Index)
{
RegionItem = item;
Refresh();
if (SelectItem != null)
{
SelectItem(this, new GantChangedEvent(RegionItem));
}
return;
}
}
}
}
// Generates content of pivotTablePart6.
private void GeneratePivotTablePart6Content(PivotTablePart pivotTablePart6)
{
PivotTableDefinition pivotTableDefinition11 = new PivotTableDefinition(){ Name = "PivotTable1", CacheId = (UInt32Value)1U, ApplyNumberFormats = false, ApplyBorderFormats = false, ApplyFontFormats = false, ApplyPatternFormats = false, ApplyAlignmentFormats = false, ApplyWidthHeightFormats = true, DataCaption = "Values", UpdatedVersion = 5, MinRefreshableVersion = 5, UseAutoFormatting = true, ItemPrintTitles = true, CreatedVersion = 4, Indent = (UInt32Value)0U, Outline = true, OutlineData = true, MultipleFieldFilters = false, ChartFormat = (UInt32Value)9U };
Location location6 = new Location(){ Reference = "A1:B5", FirstHeaderRow = (UInt32Value)1U, FirstDataRow = (UInt32Value)1U, FirstDataColumn = (UInt32Value)1U };
PivotFields pivotFields6 = new PivotFields(){ Count = (UInt32Value)7U };
PivotField pivotField35 = new PivotField(){ NumberFormatId = (UInt32Value)14U, ShowAll = false };
Items items19 = new Items(){ Count = (UInt32Value)15U };
Item item162 = new Item(){ Index = (UInt32Value)0U };
Item item163 = new Item(){ Index = (UInt32Value)1U };
Item item164 = new Item(){ Index = (UInt32Value)2U };
Item item165 = new Item(){ Index = (UInt32Value)3U };
Item item166 = new Item(){ Index = (UInt32Value)4U };
Item item167 = new Item(){ Index = (UInt32Value)5U };
Item item168 = new Item(){ Index = (UInt32Value)6U };
Item item169 = new Item(){ Index = (UInt32Value)7U };
Item item170 = new Item(){ Index = (UInt32Value)8U };
Item item171 = new Item(){ Index = (UInt32Value)9U };
Item item172 = new Item(){ Index = (UInt32Value)10U };
Item item173 = new Item(){ Index = (UInt32Value)11U };
Item item174 = new Item(){ Index = (UInt32Value)12U };
Item item175 = new Item(){ Index = (UInt32Value)13U };
Item item176 = new Item(){ ItemType = ItemValues.Default };
items19.Append(item162);
items19.Append(item163);
items19.Append(item164);
items19.Append(item165);
items19.Append(item166);
items19.Append(item167);
items19.Append(item168);
items19.Append(item169);
items19.Append(item170);
items19.Append(item171);
items19.Append(item172);
items19.Append(item173);
items19.Append(item174);
items19.Append(item175);
items19.Append(item176);
pivotField35.Append(items19);
PivotField pivotField36 = new PivotField(){ Axis = PivotTableAxisValues.AxisRow, ShowAll = false };
Items items20 = new Items(){ Count = (UInt32Value)11U };
Item item177 = new Item(){ Index = (UInt32Value)0U };
Item item178 = new Item(){ Missing = true, Index = (UInt32Value)4U };
Item item179 = new Item(){ Missing = true, Index = (UInt32Value)3U };
Item item180 = new Item(){ Index = (UInt32Value)1U };
Item item181 = new Item(){ Index = (UInt32Value)2U };
Item item182 = new Item(){ Missing = true, Index = (UInt32Value)9U };
Item item183 = new Item(){ Missing = true, Index = (UInt32Value)8U };
Item item184 = new Item(){ Missing = true, Index = (UInt32Value)7U };
Item item185 = new Item(){ Missing = true, Index = (UInt32Value)6U };
Item item186 = new Item(){ Missing = true, Index = (UInt32Value)5U };
Item item187 = new Item(){ ItemType = ItemValues.Default };
items20.Append(item177);
items20.Append(item178);
items20.Append(item179);
items20.Append(item180);
items20.Append(item181);
items20.Append(item182);
items20.Append(item183);
items20.Append(item184);
items20.Append(item185);
items20.Append(item186);
items20.Append(item187);
pivotField36.Append(items20);
PivotField pivotField37 = new PivotField(){ DataField = true, ShowAll = false };
PivotField pivotField38 = new PivotField(){ ShowAll = false };
PivotField pivotField39 = new PivotField(){ NumberFormatId = (UInt32Value)14U, ShowAll = false };
Items items21 = new Items(){ Count = (UInt32Value)5U };
Item item188 = new Item(){ Index = (UInt32Value)0U };
Item item189 = new Item(){ Index = (UInt32Value)1U };
Item item190 = new Item(){ Index = (UInt32Value)3U };
Item item191 = new Item(){ Index = (UInt32Value)2U };
Item item192 = new Item(){ ItemType = ItemValues.Default };
items21.Append(item188);
items21.Append(item189);
items21.Append(item190);
items21.Append(item191);
items21.Append(item192);
pivotField39.Append(items21);
PivotField pivotField40 = new PivotField(){ ShowAll = false };
PivotField pivotField41 = new PivotField(){ ShowAll = false, DefaultSubtotal = false };
Items items22 = new Items(){ Count = (UInt32Value)5U };
Item item193 = new Item(){ Index = (UInt32Value)0U };
Item item194 = new Item(){ Index = (UInt32Value)1U };
Item item195 = new Item(){ Index = (UInt32Value)2U };
Item item196 = new Item(){ Index = (UInt32Value)3U };
Item item197 = new Item(){ Index = (UInt32Value)4U };
items22.Append(item193);
items22.Append(item194);
items22.Append(item195);
items22.Append(item196);
items22.Append(item197);
pivotField41.Append(items22);
pivotFields6.Append(pivotField35);
pivotFields6.Append(pivotField36);
pivotFields6.Append(pivotField37);
pivotFields6.Append(pivotField38);
pivotFields6.Append(pivotField39);
pivotFields6.Append(pivotField40);
pivotFields6.Append(pivotField41);
RowFields rowFields6 = new RowFields(){ Count = (UInt32Value)1U };
Field field6 = new Field(){ Index = 1 };
rowFields6.Append(field6);
RowItems rowItems6 = new RowItems(){ Count = (UInt32Value)4U };
RowItem rowItem26 = new RowItem();
MemberPropertyIndex memberPropertyIndex21 = new MemberPropertyIndex();
rowItem26.Append(memberPropertyIndex21);
RowItem rowItem27 = new RowItem();
MemberPropertyIndex memberPropertyIndex22 = new MemberPropertyIndex(){ Val = 3 };
rowItem27.Append(memberPropertyIndex22);
RowItem rowItem28 = new RowItem();
MemberPropertyIndex memberPropertyIndex23 = new MemberPropertyIndex(){ Val = 4 };
rowItem28.Append(memberPropertyIndex23);
RowItem rowItem29 = new RowItem(){ ItemType = ItemValues.Grand };
MemberPropertyIndex memberPropertyIndex24 = new MemberPropertyIndex();
rowItem29.Append(memberPropertyIndex24);
rowItems6.Append(rowItem26);
rowItems6.Append(rowItem27);
rowItems6.Append(rowItem28);
rowItems6.Append(rowItem29);
ColumnItems columnItems6 = new ColumnItems(){ Count = (UInt32Value)1U };
RowItem rowItem30 = new RowItem();
columnItems6.Append(rowItem30);
DataFields dataFields6 = new DataFields(){ Count = (UInt32Value)1U };
DataField dataField6 = new DataField(){ Name = "Sum of Quantity", Field = (UInt32Value)2U, BaseField = 0, BaseItem = (UInt32Value)0U };
dataFields6.Append(dataField6);
ChartFormats chartFormats6 = new ChartFormats(){ Count = (UInt32Value)5U };
ChartFormat chartFormat47 = new ChartFormat(){ Chart = (UInt32Value)4U, Format = (UInt32Value)0U, Series = true };
PivotArea pivotArea47 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences47 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference47 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem69 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference47.Append(fieldItem69);
pivotAreaReferences47.Append(pivotAreaReference47);
pivotArea47.Append(pivotAreaReferences47);
chartFormat47.Append(pivotArea47);
ChartFormat chartFormat48 = new ChartFormat(){ Chart = (UInt32Value)5U, Format = (UInt32Value)2U, Series = true };
PivotArea pivotArea48 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences48 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference48 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem70 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference48.Append(fieldItem70);
pivotAreaReferences48.Append(pivotAreaReference48);
pivotArea48.Append(pivotAreaReferences48);
chartFormat48.Append(pivotArea48);
ChartFormat chartFormat49 = new ChartFormat(){ Chart = (UInt32Value)6U, Format = (UInt32Value)0U, Series = true };
PivotArea pivotArea49 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences49 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference49 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem71 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference49.Append(fieldItem71);
pivotAreaReferences49.Append(pivotAreaReference49);
pivotArea49.Append(pivotAreaReferences49);
chartFormat49.Append(pivotArea49);
ChartFormat chartFormat50 = new ChartFormat(){ Chart = (UInt32Value)7U, Format = (UInt32Value)14U, Series = true };
PivotArea pivotArea50 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences50 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference50 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem72 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference50.Append(fieldItem72);
pivotAreaReferences50.Append(pivotAreaReference50);
pivotArea50.Append(pivotAreaReferences50);
chartFormat50.Append(pivotArea50);
ChartFormat chartFormat51 = new ChartFormat(){ Chart = (UInt32Value)8U, Format = (UInt32Value)1U, Series = true };
PivotArea pivotArea51 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences51 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference51 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem73 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference51.Append(fieldItem73);
pivotAreaReferences51.Append(pivotAreaReference51);
pivotArea51.Append(pivotAreaReferences51);
chartFormat51.Append(pivotArea51);
chartFormats6.Append(chartFormat47);
chartFormats6.Append(chartFormat48);
chartFormats6.Append(chartFormat49);
chartFormats6.Append(chartFormat50);
chartFormats6.Append(chartFormat51);
PivotTableStyle pivotTableStyle6 = new PivotTableStyle(){ Name = "PivotStyleLight16", ShowRowHeaders = true, ShowColumnHeaders = true, ShowRowStripes = false, ShowColumnStripes = false, ShowLastColumn = true };
PivotTableDefinitionExtensionList pivotTableDefinitionExtensionList6 = new PivotTableDefinitionExtensionList();
PivotTableDefinitionExtension pivotTableDefinitionExtension6 = new PivotTableDefinitionExtension(){ Uri = "{962EF5D1-5CA2-4c93-8EF4-DBF5C05439D2}" };
pivotTableDefinitionExtension6.AddNamespaceDeclaration("x14", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/main");
X14.PivotTableDefinition pivotTableDefinition12 = new X14.PivotTableDefinition(){ HideValuesRow = true };
pivotTableDefinition12.AddNamespaceDeclaration("xm", "http://schemas.microsoft.com/office/excel/2006/main");
pivotTableDefinitionExtension6.Append(pivotTableDefinition12);
pivotTableDefinitionExtensionList6.Append(pivotTableDefinitionExtension6);
pivotTableDefinition11.Append(location6);
pivotTableDefinition11.Append(pivotFields6);
pivotTableDefinition11.Append(rowFields6);
pivotTableDefinition11.Append(rowItems6);
pivotTableDefinition11.Append(columnItems6);
pivotTableDefinition11.Append(dataFields6);
pivotTableDefinition11.Append(chartFormats6);
pivotTableDefinition11.Append(pivotTableStyle6);
pivotTableDefinition11.Append(pivotTableDefinitionExtensionList6);
pivotTablePart6.PivotTableDefinition = pivotTableDefinition11;
}
/// <summary>
/// Инициализация объекта по умолчанию.
/// </summary>
/// <param name="SelectedItem">Выделенный элемент.</param>
public GantChangedEvent(RowItem SelectedItem)
: base()
{
this.SelectedItem = SelectedItem;
}
// Generates content of pivotTablePart2.
private void GeneratePivotTablePart2Content(PivotTablePart pivotTablePart2)
{
PivotTableDefinition pivotTableDefinition3 = new PivotTableDefinition(){ Name = "PivotTable1", CacheId = (UInt32Value)0U, ApplyNumberFormats = false, ApplyBorderFormats = false, ApplyFontFormats = false, ApplyPatternFormats = false, ApplyAlignmentFormats = false, ApplyWidthHeightFormats = true, DataCaption = "値", UpdatedVersion = 5, MinRefreshableVersion = 5, UseAutoFormatting = true, ItemPrintTitles = true, CreatedVersion = 4, Indent = (UInt32Value)0U, Outline = true, OutlineData = true, MultipleFieldFilters = false, ChartFormat = (UInt32Value)2U };
Location location2 = new Location(){ Reference = "A1:B5", FirstHeaderRow = (UInt32Value)1U, FirstDataRow = (UInt32Value)1U, FirstDataColumn = (UInt32Value)1U };
PivotFields pivotFields2 = new PivotFields(){ Count = (UInt32Value)6U };
PivotField pivotField8 = new PivotField(){ NumberFormatId = (UInt32Value)14U, ShowAll = false };
Items items5 = new Items(){ Count = (UInt32Value)6U };
Item item37 = new Item(){ Index = (UInt32Value)0U };
Item item38 = new Item(){ Index = (UInt32Value)1U };
Item item39 = new Item(){ Index = (UInt32Value)2U };
Item item40 = new Item(){ Index = (UInt32Value)3U };
Item item41 = new Item(){ Index = (UInt32Value)4U };
Item item42 = new Item(){ ItemType = ItemValues.Default };
items5.Append(item37);
items5.Append(item38);
items5.Append(item39);
items5.Append(item40);
items5.Append(item41);
items5.Append(item42);
pivotField8.Append(items5);
PivotField pivotField9 = new PivotField(){ Axis = PivotTableAxisValues.AxisRow, ShowAll = false };
Items items6 = new Items(){ Count = (UInt32Value)11U };
Item item43 = new Item(){ Missing = true, Index = (UInt32Value)6U };
Item item44 = new Item(){ Missing = true, Index = (UInt32Value)5U };
Item item45 = new Item(){ Index = (UInt32Value)2U };
Item item46 = new Item(){ Missing = true, Index = (UInt32Value)4U };
Item item47 = new Item(){ Missing = true, Index = (UInt32Value)3U };
Item item48 = new Item(){ Index = (UInt32Value)0U };
Item item49 = new Item(){ Index = (UInt32Value)1U };
Item item50 = new Item(){ Missing = true, Index = (UInt32Value)9U };
Item item51 = new Item(){ Missing = true, Index = (UInt32Value)8U };
Item item52 = new Item(){ Missing = true, Index = (UInt32Value)7U };
Item item53 = new Item(){ ItemType = ItemValues.Default };
items6.Append(item43);
items6.Append(item44);
items6.Append(item45);
items6.Append(item46);
items6.Append(item47);
items6.Append(item48);
items6.Append(item49);
items6.Append(item50);
items6.Append(item51);
items6.Append(item52);
items6.Append(item53);
pivotField9.Append(items6);
PivotField pivotField10 = new PivotField(){ ShowAll = false };
PivotField pivotField11 = new PivotField(){ DataField = true, ShowAll = false };
PivotField pivotField12 = new PivotField(){ NumberFormatId = (UInt32Value)14U, ShowAll = false };
PivotField pivotField13 = new PivotField(){ ShowAll = false };
pivotFields2.Append(pivotField8);
pivotFields2.Append(pivotField9);
pivotFields2.Append(pivotField10);
pivotFields2.Append(pivotField11);
pivotFields2.Append(pivotField12);
pivotFields2.Append(pivotField13);
RowFields rowFields2 = new RowFields(){ Count = (UInt32Value)1U };
Field field2 = new Field(){ Index = 1 };
rowFields2.Append(field2);
RowItems rowItems2 = new RowItems(){ Count = (UInt32Value)4U };
RowItem rowItem6 = new RowItem();
MemberPropertyIndex memberPropertyIndex5 = new MemberPropertyIndex(){ Val = 2 };
rowItem6.Append(memberPropertyIndex5);
RowItem rowItem7 = new RowItem();
MemberPropertyIndex memberPropertyIndex6 = new MemberPropertyIndex(){ Val = 5 };
rowItem7.Append(memberPropertyIndex6);
RowItem rowItem8 = new RowItem();
MemberPropertyIndex memberPropertyIndex7 = new MemberPropertyIndex(){ Val = 6 };
rowItem8.Append(memberPropertyIndex7);
RowItem rowItem9 = new RowItem(){ ItemType = ItemValues.Grand };
MemberPropertyIndex memberPropertyIndex8 = new MemberPropertyIndex();
rowItem9.Append(memberPropertyIndex8);
rowItems2.Append(rowItem6);
rowItems2.Append(rowItem7);
rowItems2.Append(rowItem8);
rowItems2.Append(rowItem9);
ColumnItems columnItems2 = new ColumnItems(){ Count = (UInt32Value)1U };
RowItem rowItem10 = new RowItem();
columnItems2.Append(rowItem10);
DataFields dataFields2 = new DataFields(){ Count = (UInt32Value)1U };
DataField dataField2 = new DataField(){ Name = "Toral / Price", Field = (UInt32Value)3U, BaseField = 0, BaseItem = (UInt32Value)0U };
dataFields2.Append(dataField2);
ChartFormats chartFormats2 = new ChartFormats(){ Count = (UInt32Value)2U };
ChartFormat chartFormat12 = new ChartFormat(){ Chart = (UInt32Value)0U, Format = (UInt32Value)0U, Series = true };
PivotArea pivotArea12 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences12 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference12 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem24 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference12.Append(fieldItem24);
pivotAreaReferences12.Append(pivotAreaReference12);
pivotArea12.Append(pivotAreaReferences12);
chartFormat12.Append(pivotArea12);
ChartFormat chartFormat13 = new ChartFormat(){ Chart = (UInt32Value)1U, Format = (UInt32Value)0U, Series = true };
PivotArea pivotArea13 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences13 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference13 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem25 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference13.Append(fieldItem25);
pivotAreaReferences13.Append(pivotAreaReference13);
pivotArea13.Append(pivotAreaReferences13);
chartFormat13.Append(pivotArea13);
chartFormats2.Append(chartFormat12);
chartFormats2.Append(chartFormat13);
PivotTableStyle pivotTableStyle2 = new PivotTableStyle(){ Name = "PivotStyleLight16", ShowRowHeaders = true, ShowColumnHeaders = true, ShowRowStripes = false, ShowColumnStripes = false, ShowLastColumn = true };
PivotTableDefinitionExtensionList pivotTableDefinitionExtensionList2 = new PivotTableDefinitionExtensionList();
PivotTableDefinitionExtension pivotTableDefinitionExtension2 = new PivotTableDefinitionExtension(){ Uri = "{962EF5D1-5CA2-4c93-8EF4-DBF5C05439D2}" };
pivotTableDefinitionExtension2.AddNamespaceDeclaration("x14", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/main");
X14.PivotTableDefinition pivotTableDefinition4 = new X14.PivotTableDefinition(){ HideValuesRow = true };
pivotTableDefinition4.AddNamespaceDeclaration("xm", "http://schemas.microsoft.com/office/excel/2006/main");
pivotTableDefinitionExtension2.Append(pivotTableDefinition4);
pivotTableDefinitionExtensionList2.Append(pivotTableDefinitionExtension2);
pivotTableDefinition3.Append(location2);
pivotTableDefinition3.Append(pivotFields2);
pivotTableDefinition3.Append(rowFields2);
pivotTableDefinition3.Append(rowItems2);
pivotTableDefinition3.Append(columnItems2);
pivotTableDefinition3.Append(dataFields2);
pivotTableDefinition3.Append(chartFormats2);
pivotTableDefinition3.Append(pivotTableStyle2);
pivotTableDefinition3.Append(pivotTableDefinitionExtensionList2);
pivotTablePart2.PivotTableDefinition = pivotTableDefinition3;
}
// Generates content of pivotTablePart5.
private void GeneratePivotTablePart5Content(PivotTablePart pivotTablePart5)
{
PivotTableDefinition pivotTableDefinition9 = new PivotTableDefinition(){ Name = "PivotTable1", CacheId = (UInt32Value)1U, ApplyNumberFormats = false, ApplyBorderFormats = false, ApplyFontFormats = false, ApplyPatternFormats = false, ApplyAlignmentFormats = false, ApplyWidthHeightFormats = true, DataCaption = "Values", UpdatedVersion = 5, MinRefreshableVersion = 5, UseAutoFormatting = true, ItemPrintTitles = true, CreatedVersion = 4, Indent = (UInt32Value)0U, Outline = true, OutlineData = true, MultipleFieldFilters = false, ChartFormat = (UInt32Value)21U };
Location location5 = new Location(){ Reference = "A1:B5", FirstHeaderRow = (UInt32Value)1U, FirstDataRow = (UInt32Value)1U, FirstDataColumn = (UInt32Value)1U };
PivotFields pivotFields5 = new PivotFields(){ Count = (UInt32Value)7U };
PivotField pivotField28 = new PivotField(){ NumberFormatId = (UInt32Value)14U, ShowAll = false };
Items items15 = new Items(){ Count = (UInt32Value)15U };
Item item126 = new Item(){ Index = (UInt32Value)0U };
Item item127 = new Item(){ Index = (UInt32Value)1U };
Item item128 = new Item(){ Index = (UInt32Value)2U };
Item item129 = new Item(){ Index = (UInt32Value)3U };
Item item130 = new Item(){ Index = (UInt32Value)4U };
Item item131 = new Item(){ Index = (UInt32Value)5U };
Item item132 = new Item(){ Index = (UInt32Value)6U };
Item item133 = new Item(){ Index = (UInt32Value)7U };
Item item134 = new Item(){ Index = (UInt32Value)8U };
Item item135 = new Item(){ Index = (UInt32Value)9U };
Item item136 = new Item(){ Index = (UInt32Value)10U };
Item item137 = new Item(){ Index = (UInt32Value)11U };
Item item138 = new Item(){ Index = (UInt32Value)12U };
Item item139 = new Item(){ Index = (UInt32Value)13U };
Item item140 = new Item(){ ItemType = ItemValues.Default };
items15.Append(item126);
items15.Append(item127);
items15.Append(item128);
items15.Append(item129);
items15.Append(item130);
items15.Append(item131);
items15.Append(item132);
items15.Append(item133);
items15.Append(item134);
items15.Append(item135);
items15.Append(item136);
items15.Append(item137);
items15.Append(item138);
items15.Append(item139);
items15.Append(item140);
pivotField28.Append(items15);
PivotField pivotField29 = new PivotField(){ Axis = PivotTableAxisValues.AxisRow, ShowAll = false };
Items items16 = new Items(){ Count = (UInt32Value)11U };
Item item141 = new Item(){ Index = (UInt32Value)0U };
Item item142 = new Item(){ Missing = true, Index = (UInt32Value)4U };
Item item143 = new Item(){ Missing = true, Index = (UInt32Value)3U };
Item item144 = new Item(){ Index = (UInt32Value)1U };
Item item145 = new Item(){ Index = (UInt32Value)2U };
Item item146 = new Item(){ Missing = true, Index = (UInt32Value)9U };
Item item147 = new Item(){ Missing = true, Index = (UInt32Value)8U };
Item item148 = new Item(){ Missing = true, Index = (UInt32Value)7U };
Item item149 = new Item(){ Missing = true, Index = (UInt32Value)6U };
Item item150 = new Item(){ Missing = true, Index = (UInt32Value)5U };
Item item151 = new Item(){ ItemType = ItemValues.Default };
items16.Append(item141);
items16.Append(item142);
items16.Append(item143);
items16.Append(item144);
items16.Append(item145);
items16.Append(item146);
items16.Append(item147);
items16.Append(item148);
items16.Append(item149);
items16.Append(item150);
items16.Append(item151);
pivotField29.Append(items16);
PivotField pivotField30 = new PivotField(){ DataField = true, ShowAll = false };
PivotField pivotField31 = new PivotField(){ ShowAll = false };
PivotField pivotField32 = new PivotField(){ NumberFormatId = (UInt32Value)14U, ShowAll = false };
Items items17 = new Items(){ Count = (UInt32Value)5U };
Item item152 = new Item(){ Index = (UInt32Value)0U };
Item item153 = new Item(){ Index = (UInt32Value)1U };
Item item154 = new Item(){ Index = (UInt32Value)3U };
Item item155 = new Item(){ Index = (UInt32Value)2U };
Item item156 = new Item(){ ItemType = ItemValues.Default };
items17.Append(item152);
items17.Append(item153);
items17.Append(item154);
items17.Append(item155);
items17.Append(item156);
pivotField32.Append(items17);
PivotField pivotField33 = new PivotField(){ ShowAll = false };
PivotField pivotField34 = new PivotField(){ ShowAll = false, DefaultSubtotal = false };
Items items18 = new Items(){ Count = (UInt32Value)5U };
Item item157 = new Item(){ Index = (UInt32Value)0U };
Item item158 = new Item(){ Index = (UInt32Value)1U };
Item item159 = new Item(){ Index = (UInt32Value)2U };
Item item160 = new Item(){ Index = (UInt32Value)3U };
Item item161 = new Item(){ Index = (UInt32Value)4U };
items18.Append(item157);
items18.Append(item158);
items18.Append(item159);
items18.Append(item160);
items18.Append(item161);
pivotField34.Append(items18);
pivotFields5.Append(pivotField28);
pivotFields5.Append(pivotField29);
pivotFields5.Append(pivotField30);
pivotFields5.Append(pivotField31);
pivotFields5.Append(pivotField32);
pivotFields5.Append(pivotField33);
pivotFields5.Append(pivotField34);
RowFields rowFields5 = new RowFields(){ Count = (UInt32Value)1U };
Field field5 = new Field(){ Index = 1 };
rowFields5.Append(field5);
RowItems rowItems5 = new RowItems(){ Count = (UInt32Value)4U };
RowItem rowItem21 = new RowItem();
MemberPropertyIndex memberPropertyIndex17 = new MemberPropertyIndex();
rowItem21.Append(memberPropertyIndex17);
RowItem rowItem22 = new RowItem();
MemberPropertyIndex memberPropertyIndex18 = new MemberPropertyIndex(){ Val = 3 };
rowItem22.Append(memberPropertyIndex18);
RowItem rowItem23 = new RowItem();
MemberPropertyIndex memberPropertyIndex19 = new MemberPropertyIndex(){ Val = 4 };
rowItem23.Append(memberPropertyIndex19);
RowItem rowItem24 = new RowItem(){ ItemType = ItemValues.Grand };
MemberPropertyIndex memberPropertyIndex20 = new MemberPropertyIndex();
rowItem24.Append(memberPropertyIndex20);
rowItems5.Append(rowItem21);
rowItems5.Append(rowItem22);
rowItems5.Append(rowItem23);
rowItems5.Append(rowItem24);
ColumnItems columnItems5 = new ColumnItems(){ Count = (UInt32Value)1U };
RowItem rowItem25 = new RowItem();
columnItems5.Append(rowItem25);
DataFields dataFields5 = new DataFields(){ Count = (UInt32Value)1U };
DataField dataField5 = new DataField(){ Name = "Sum of Quantity", Field = (UInt32Value)2U, BaseField = 0, BaseItem = (UInt32Value)0U };
dataFields5.Append(dataField5);
ChartFormats chartFormats5 = new ChartFormats(){ Count = (UInt32Value)17U };
ChartFormat chartFormat30 = new ChartFormat(){ Chart = (UInt32Value)4U, Format = (UInt32Value)0U, Series = true };
PivotArea pivotArea30 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences30 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference30 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem52 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference30.Append(fieldItem52);
pivotAreaReferences30.Append(pivotAreaReference30);
pivotArea30.Append(pivotAreaReferences30);
chartFormat30.Append(pivotArea30);
ChartFormat chartFormat31 = new ChartFormat(){ Chart = (UInt32Value)5U, Format = (UInt32Value)2U, Series = true };
PivotArea pivotArea31 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences31 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference31 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem53 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference31.Append(fieldItem53);
pivotAreaReferences31.Append(pivotAreaReference31);
pivotArea31.Append(pivotAreaReferences31);
chartFormat31.Append(pivotArea31);
ChartFormat chartFormat32 = new ChartFormat(){ Chart = (UInt32Value)6U, Format = (UInt32Value)0U, Series = true };
PivotArea pivotArea32 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences32 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference32 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem54 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference32.Append(fieldItem54);
pivotAreaReferences32.Append(pivotAreaReference32);
pivotArea32.Append(pivotAreaReferences32);
chartFormat32.Append(pivotArea32);
ChartFormat chartFormat33 = new ChartFormat(){ Chart = (UInt32Value)7U, Format = (UInt32Value)14U, Series = true };
PivotArea pivotArea33 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences33 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference33 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem55 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference33.Append(fieldItem55);
pivotAreaReferences33.Append(pivotAreaReference33);
pivotArea33.Append(pivotAreaReferences33);
chartFormat33.Append(pivotArea33);
ChartFormat chartFormat34 = new ChartFormat(){ Chart = (UInt32Value)8U, Format = (UInt32Value)1U, Series = true };
PivotArea pivotArea34 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences34 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference34 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem56 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference34.Append(fieldItem56);
pivotAreaReferences34.Append(pivotAreaReference34);
pivotArea34.Append(pivotAreaReferences34);
chartFormat34.Append(pivotArea34);
ChartFormat chartFormat35 = new ChartFormat(){ Chart = (UInt32Value)9U, Format = (UInt32Value)15U, Series = true };
PivotArea pivotArea35 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences35 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference35 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem57 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference35.Append(fieldItem57);
pivotAreaReferences35.Append(pivotAreaReference35);
pivotArea35.Append(pivotAreaReferences35);
chartFormat35.Append(pivotArea35);
ChartFormat chartFormat36 = new ChartFormat(){ Chart = (UInt32Value)10U, Format = (UInt32Value)2U, Series = true };
PivotArea pivotArea36 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences36 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference36 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem58 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference36.Append(fieldItem58);
pivotAreaReferences36.Append(pivotAreaReference36);
pivotArea36.Append(pivotAreaReferences36);
chartFormat36.Append(pivotArea36);
ChartFormat chartFormat37 = new ChartFormat(){ Chart = (UInt32Value)11U, Format = (UInt32Value)16U, Series = true };
PivotArea pivotArea37 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences37 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference37 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem59 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference37.Append(fieldItem59);
pivotAreaReferences37.Append(pivotAreaReference37);
pivotArea37.Append(pivotAreaReferences37);
chartFormat37.Append(pivotArea37);
ChartFormat chartFormat38 = new ChartFormat(){ Chart = (UInt32Value)12U, Format = (UInt32Value)3U, Series = true };
PivotArea pivotArea38 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences38 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference38 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem60 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference38.Append(fieldItem60);
pivotAreaReferences38.Append(pivotAreaReference38);
pivotArea38.Append(pivotAreaReferences38);
chartFormat38.Append(pivotArea38);
ChartFormat chartFormat39 = new ChartFormat(){ Chart = (UInt32Value)13U, Format = (UInt32Value)17U, Series = true };
PivotArea pivotArea39 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences39 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference39 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem61 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference39.Append(fieldItem61);
pivotAreaReferences39.Append(pivotAreaReference39);
pivotArea39.Append(pivotAreaReferences39);
chartFormat39.Append(pivotArea39);
ChartFormat chartFormat40 = new ChartFormat(){ Chart = (UInt32Value)14U, Format = (UInt32Value)4U, Series = true };
PivotArea pivotArea40 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences40 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference40 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem62 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference40.Append(fieldItem62);
pivotAreaReferences40.Append(pivotAreaReference40);
pivotArea40.Append(pivotAreaReferences40);
chartFormat40.Append(pivotArea40);
ChartFormat chartFormat41 = new ChartFormat(){ Chart = (UInt32Value)15U, Format = (UInt32Value)18U, Series = true };
PivotArea pivotArea41 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences41 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference41 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem63 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference41.Append(fieldItem63);
pivotAreaReferences41.Append(pivotAreaReference41);
pivotArea41.Append(pivotAreaReferences41);
chartFormat41.Append(pivotArea41);
ChartFormat chartFormat42 = new ChartFormat(){ Chart = (UInt32Value)16U, Format = (UInt32Value)5U, Series = true };
PivotArea pivotArea42 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences42 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference42 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem64 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference42.Append(fieldItem64);
pivotAreaReferences42.Append(pivotAreaReference42);
pivotArea42.Append(pivotAreaReferences42);
chartFormat42.Append(pivotArea42);
ChartFormat chartFormat43 = new ChartFormat(){ Chart = (UInt32Value)17U, Format = (UInt32Value)19U, Series = true };
PivotArea pivotArea43 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences43 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference43 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem65 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference43.Append(fieldItem65);
pivotAreaReferences43.Append(pivotAreaReference43);
pivotArea43.Append(pivotAreaReferences43);
chartFormat43.Append(pivotArea43);
ChartFormat chartFormat44 = new ChartFormat(){ Chart = (UInt32Value)18U, Format = (UInt32Value)6U, Series = true };
PivotArea pivotArea44 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences44 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference44 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem66 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference44.Append(fieldItem66);
pivotAreaReferences44.Append(pivotAreaReference44);
pivotArea44.Append(pivotAreaReferences44);
chartFormat44.Append(pivotArea44);
ChartFormat chartFormat45 = new ChartFormat(){ Chart = (UInt32Value)19U, Format = (UInt32Value)20U, Series = true };
PivotArea pivotArea45 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences45 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference45 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem67 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference45.Append(fieldItem67);
pivotAreaReferences45.Append(pivotAreaReference45);
pivotArea45.Append(pivotAreaReferences45);
chartFormat45.Append(pivotArea45);
ChartFormat chartFormat46 = new ChartFormat(){ Chart = (UInt32Value)20U, Format = (UInt32Value)7U, Series = true };
PivotArea pivotArea46 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };
PivotAreaReferences pivotAreaReferences46 = new PivotAreaReferences(){ Count = (UInt32Value)1U };
PivotAreaReference pivotAreaReference46 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
FieldItem fieldItem68 = new FieldItem(){ Val = (UInt32Value)0U };
pivotAreaReference46.Append(fieldItem68);
pivotAreaReferences46.Append(pivotAreaReference46);
pivotArea46.Append(pivotAreaReferences46);
chartFormat46.Append(pivotArea46);
chartFormats5.Append(chartFormat30);
chartFormats5.Append(chartFormat31);
chartFormats5.Append(chartFormat32);
chartFormats5.Append(chartFormat33);
chartFormats5.Append(chartFormat34);
chartFormats5.Append(chartFormat35);
chartFormats5.Append(chartFormat36);
chartFormats5.Append(chartFormat37);
chartFormats5.Append(chartFormat38);
chartFormats5.Append(chartFormat39);
chartFormats5.Append(chartFormat40);
chartFormats5.Append(chartFormat41);
chartFormats5.Append(chartFormat42);
chartFormats5.Append(chartFormat43);
chartFormats5.Append(chartFormat44);
chartFormats5.Append(chartFormat45);
chartFormats5.Append(chartFormat46);
PivotTableStyle pivotTableStyle5 = new PivotTableStyle(){ Name = "PivotStyleLight16", ShowRowHeaders = true, ShowColumnHeaders = true, ShowRowStripes = false, ShowColumnStripes = false, ShowLastColumn = true };
PivotTableDefinitionExtensionList pivotTableDefinitionExtensionList5 = new PivotTableDefinitionExtensionList();
PivotTableDefinitionExtension pivotTableDefinitionExtension5 = new PivotTableDefinitionExtension(){ Uri = "{962EF5D1-5CA2-4c93-8EF4-DBF5C05439D2}" };
pivotTableDefinitionExtension5.AddNamespaceDeclaration("x14", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/main");
X14.PivotTableDefinition pivotTableDefinition10 = new X14.PivotTableDefinition(){ HideValuesRow = true };
pivotTableDefinition10.AddNamespaceDeclaration("xm", "http://schemas.microsoft.com/office/excel/2006/main");
pivotTableDefinitionExtension5.Append(pivotTableDefinition10);
pivotTableDefinitionExtensionList5.Append(pivotTableDefinitionExtension5);
pivotTableDefinition9.Append(location5);
pivotTableDefinition9.Append(pivotFields5);
pivotTableDefinition9.Append(rowFields5);
pivotTableDefinition9.Append(rowItems5);
pivotTableDefinition9.Append(columnItems5);
pivotTableDefinition9.Append(dataFields5);
pivotTableDefinition9.Append(chartFormats5);
pivotTableDefinition9.Append(pivotTableStyle5);
pivotTableDefinition9.Append(pivotTableDefinitionExtensionList5);
pivotTablePart5.PivotTableDefinition = pivotTableDefinition9;
}
private void GraphField_MouseDown(object sender, MouseEventArgs e)
{
if (items == null)
return;
if (RegionItem != null)
{
if (e.X > RegionItem.DrawRegion.X &&
e.Y > RegionItem.DrawRegion.Y &&
e.X < RegionItem.DrawRegion.Right &&
e.Y < RegionItem.DrawRegion.Bottom)
{
// если указатель находится в том же регионе, то не нужно ничего пересчитывать
return;
}
}
foreach (Row row_items in items)
{
if (row_items.Count != 0) // находим строку в которой содержится искомый элемент
{
if (e.Y > row_items[0].DrawRegion.Y &&
e.Y < row_items[0].DrawRegion.Bottom)
{
foreach (RowItem item in row_items)
{
if (e.X > item.DrawRegion.X &&
e.X < item.DrawRegion.Right)
{
RegionItem = item;
Refresh();
if (SelectItem != null)
SelectItem(this, new GantChangedEvent(RegionItem));
return;
}
}
}
}
}
// если дошли до этого места, то, очевидно, регион не выбран
if (RegionItem != null)
{
RegionItem = null;
Refresh();
if (SelectLostItem != null)
SelectLostItem(this, new GantChangedEvent());
}
}
public IEnumerable<RowItem> Expand(TickCounter tickCounter, RowItem rowItem, int sublistColumnIndex)
{
if (sublistColumnIndex >= SublistColumns.Count)
{
return new[] {rowItem};
}
var sublistColumn = SublistColumns[sublistColumnIndex];
object parentValue = sublistColumn.Parent.GetPropertyValue(rowItem, null);
if (null == parentValue)
{
return new[] {rowItem};
}
var items = sublistColumn.CollectionInfo.GetItems(parentValue).Cast<object>().ToArray();
if (items.Length == 0)
{
return new[] {rowItem};
}
IList<object> keys = null;
if (sublistColumn.CollectionInfo.IsDictionary)
{
keys = sublistColumn.CollectionInfo.GetKeys(parentValue).Cast<object>().ToArray();
}
var expandedItems = new List<RowItem>();
for (int index = 0; index < items.Length; index++)
{
object key = keys == null ? index : keys[index];
var child = rowItem.SetRowKey(rowItem.RowKey.AppendValue(sublistColumn.PropertyPath, key));
expandedItems.AddRange(Expand(tickCounter, child, sublistColumnIndex + 1));
}
return expandedItems;
}
// Returns a string representing the categories in which a student has improved.
private static string ImprovementLabel(RowItem s)
{
string label = "";
if (s.Improvement.Attend) label += "A ";
if (s.Improvement.Deten && s.Improvement.OfficeRefs && s.Improvement.Suspend) label += "B ";
if (s.Improvement.Acad) label += "C";
return label;
}
public RowItem Pivot(TickCounter tickCounter, RowItem rowItem)
{
foreach (var pivotColumn in PivotColumns)
{
var parent = pivotColumn.Parent.CollectionAncestor();
IList<PivotKey> pivotKeys;
if (null == parent)
{
pivotKeys = new PivotKey[] { null };
}
else
{
pivotKeys = rowItem.PivotKeys.Where(key => key.Last.Key.Equals(parent.PropertyPath)).ToArray();
}
foreach (var pivotKey in pivotKeys)
{
var parentValue = pivotColumn.Parent.GetPropertyValue(rowItem, pivotKey);
if (null != parentValue)
{
var keys = pivotColumn.CollectionInfo.GetKeys(parentValue).Cast<object>().ToArray();
if (keys.Length > 0)
{
var newPivotKeys = rowItem.PivotKeys.Except(new[] {pivotKey}).ToList();
var pivotKeyLocal = pivotKey ?? PivotKey.EMPTY;
var propertyPath = pivotColumn.PropertyPath;
newPivotKeys.AddRange(keys.Select(key => pivotKeyLocal.AppendValue(propertyPath, key)));
rowItem = rowItem.SetPivotKeys(new HashSet<PivotKey>(newPivotKeys));
}
}
}
}
return rowItem;
}
// Generates content of pivotTablePart
private static void GeneratePivotTablePartContent(PivotTablePart pivotTablePart1, IXLPivotTable pt)
{
var pivotTableDefinition = new PivotTableDefinition
{
Name = pt.Name,
CacheId = 0U,
DataCaption = "Values",
MergeItem = GetBooleanValue(pt.MergeAndCenterWithLabels, true),
Indent = Convert.ToUInt32(pt.RowLabelIndent),
PageOverThenDown = (pt.FilterAreaOrder == XLFilterAreaOrder.OverThenDown),
PageWrap = Convert.ToUInt32(pt.FilterFieldsPageWrap),
ShowError = String.IsNullOrEmpty(pt.ErrorValueReplacement),
UseAutoFormatting = GetBooleanValue(pt.AutofitColumns, true),
PreserveFormatting = GetBooleanValue(pt.PreserveCellFormatting, true),
RowGrandTotals = GetBooleanValue(pt.ShowGrandTotalsRows, true),
ColumnGrandTotals = GetBooleanValue(pt.ShowGrandTotalsColumns, true),
SubtotalHiddenItems = GetBooleanValue(pt.FilteredItemsInSubtotals, true),
MultipleFieldFilters = GetBooleanValue(pt.AllowMultipleFilters, true),
CustomListSort = GetBooleanValue(pt.UseCustomListsForSorting, true),
ShowDrill = GetBooleanValue(pt.ShowExpandCollapseButtons, true),
ShowDataTips = GetBooleanValue(pt.ShowContextualTooltips, true),
ShowMemberPropertyTips = GetBooleanValue(pt.ShowPropertiesInTooltips, true),
ShowHeaders = GetBooleanValue(pt.DisplayCaptionsAndDropdowns, true),
GridDropZones = GetBooleanValue(pt.ClassicPivotTableLayout, true),
ShowEmptyRow = GetBooleanValue(pt.ShowEmptyItemsOnRows, true),
ShowEmptyColumn = GetBooleanValue(pt.ShowEmptyItemsOnColumns, true),
ShowItems = GetBooleanValue(pt.DisplayItemLabels, true),
FieldListSortAscending = GetBooleanValue(pt.SortFieldsAtoZ, true),
PrintDrill = GetBooleanValue(pt.PrintExpandCollapsedButtons, true),
ItemPrintTitles = GetBooleanValue(pt.RepeatRowLabels, true),
FieldPrintTitles = GetBooleanValue(pt.PrintTitles, true),
EnableDrill = GetBooleanValue(pt.EnableShowDetails, true)
};
if (pt.EmptyCellReplacement != null)
{
pivotTableDefinition.ShowMissing = true;
pivotTableDefinition.MissingCaption = pt.EmptyCellReplacement;
}
else
{
pivotTableDefinition.ShowMissing = false;
}
if (pt.ErrorValueReplacement != null)
{
pivotTableDefinition.ShowError = true;
pivotTableDefinition.ErrorCaption = pt.ErrorValueReplacement;
}
else
{
pivotTableDefinition.ShowError = false;
}
var location = new Location
{
Reference = pt.TargetCell.Address.ToString(),
FirstHeaderRow = 1U,
FirstDataRow = 1U,
FirstDataColumn = 1U
};
var rowFields = new RowFields();
var columnFields = new ColumnFields();
var rowItems = new RowItems();
var columnItems = new ColumnItems();
var pageFields = new PageFields {Count = (uint)pt.ReportFilters.Count()};
var pivotFields = new PivotFields {Count = Convert.ToUInt32(pt.SourceRange.ColumnCount())};
foreach (var xlpf in pt.Fields)
{
var pf = new PivotField {ShowAll = false, Name = xlpf.CustomName};
if (pt.RowLabels.FirstOrDefault(p => p.SourceName == xlpf.SourceName) != null)
{
pf.Axis = PivotTableAxisValues.AxisRow;
var f = new Field {Index = pt.Fields.IndexOf(xlpf)};
rowFields.AppendChild(f);
for (var i = 0; i < xlpf.SharedStrings.Count; i++)
{
var rowItem = new RowItem();
rowItem.AppendChild(new MemberPropertyIndex {Val = i});
rowItems.AppendChild(rowItem);
}
var rowItemTotal = new RowItem {ItemType = ItemValues.Grand};
rowItemTotal.AppendChild(new MemberPropertyIndex());
rowItems.AppendChild(rowItemTotal);
}
else if (pt.ColumnLabels.FirstOrDefault(p => p.SourceName == xlpf.SourceName) != null)
{
pf.Axis = PivotTableAxisValues.AxisColumn;
var f = new Field {Index = pt.Fields.IndexOf(xlpf)};
columnFields.AppendChild(f);
for (var i = 0; i < xlpf.SharedStrings.Count; i++)
{
var rowItem = new RowItem();
rowItem.AppendChild(new MemberPropertyIndex {Val = i});
columnItems.AppendChild(rowItem);
}
var rowItemTotal = new RowItem {ItemType = ItemValues.Grand};
rowItemTotal.AppendChild(new MemberPropertyIndex());
columnItems.AppendChild(rowItemTotal);
}
else if (pt.ReportFilters.FirstOrDefault(p => p.SourceName == xlpf.SourceName) != null)
{
location.ColumnsPerPage = 1;
location.RowPageCount = 1;
pf.Axis = PivotTableAxisValues.AxisPage;
pageFields.AppendChild(new PageField {Hierarchy = -1, Field = pt.Fields.IndexOf(xlpf)});
}
else if (pt.Values.FirstOrDefault(p => p.CustomName == xlpf.SourceName) != null)
{
pf.DataField = true;
}
var fieldItems = new Items();
if (xlpf.SharedStrings.Count > 0)
{
for (uint i = 0; i < xlpf.SharedStrings.Count; i++)
{
fieldItems.AppendChild(new Item {Index = i});
}
}
if (xlpf.Subtotals.Count > 0)
{
foreach (var subtotal in xlpf.Subtotals)
{
var itemSubtotal = new Item();
switch (subtotal)
{
case XLSubtotalFunction.Average:
pf.AverageSubTotal = true;
itemSubtotal.ItemType = ItemValues.Average;
break;
case XLSubtotalFunction.Count:
pf.CountASubtotal = true;
itemSubtotal.ItemType = ItemValues.CountA;
break;
case XLSubtotalFunction.CountNumbers:
pf.CountSubtotal = true;
itemSubtotal.ItemType = ItemValues.Count;
break;
case XLSubtotalFunction.Maximum:
pf.MaxSubtotal = true;
itemSubtotal.ItemType = ItemValues.Maximum;
break;
case XLSubtotalFunction.Minimum:
pf.MinSubtotal = true;
itemSubtotal.ItemType = ItemValues.Minimum;
break;
case XLSubtotalFunction.PopulationStandardDeviation:
pf.ApplyStandardDeviationPInSubtotal = true;
itemSubtotal.ItemType = ItemValues.StandardDeviationP;
break;
case XLSubtotalFunction.PopulationVariance:
pf.ApplyVariancePInSubtotal = true;
itemSubtotal.ItemType = ItemValues.VarianceP;
break;
case XLSubtotalFunction.Product:
pf.ApplyProductInSubtotal = true;
itemSubtotal.ItemType = ItemValues.Product;
break;
case XLSubtotalFunction.StandardDeviation:
pf.ApplyStandardDeviationInSubtotal = true;
itemSubtotal.ItemType = ItemValues.StandardDeviation;
break;
case XLSubtotalFunction.Sum:
pf.SumSubtotal = true;
itemSubtotal.ItemType = ItemValues.Sum;
break;
case XLSubtotalFunction.Variance:
pf.ApplyVarianceInSubtotal = true;
itemSubtotal.ItemType = ItemValues.Variance;
break;
}
fieldItems.AppendChild(itemSubtotal);
}
}
else
{
fieldItems.AppendChild(new Item {ItemType = ItemValues.Default});
}
pf.AppendChild(fieldItems);
pivotFields.AppendChild(pf);
}
pivotTableDefinition.AppendChild(location);
pivotTableDefinition.AppendChild(pivotFields);
if (pt.RowLabels.Any())
{
pivotTableDefinition.AppendChild(rowFields);
}
else
{
rowItems.AppendChild(new RowItem());
}
pivotTableDefinition.AppendChild(rowItems);
if (!pt.ColumnLabels.Any())
{
columnItems.AppendChild(new RowItem());
pivotTableDefinition.AppendChild(columnItems);
}
else
{
pivotTableDefinition.AppendChild(columnFields);
pivotTableDefinition.AppendChild(columnItems);
}
if (pt.ReportFilters.Any())
{
pivotTableDefinition.AppendChild(pageFields);
}
var dataFields = new DataFields();
foreach (var value in pt.Values)
{
var sourceColumn =
pt.SourceRange.Columns().FirstOrDefault(c => c.Cell(1).Value.ToString() == value.SourceName);
if (sourceColumn == null) continue;
var df = new DataField
{
Name = value.SourceName,
Field = (UInt32)sourceColumn.ColumnNumber() - 1,
Subtotal = value.SummaryFormula.ToOpenXml(),
ShowDataAs = value.Calculation.ToOpenXml(),
NumberFormatId = (UInt32)value.NumberFormat.NumberFormatId
};
if (!String.IsNullOrEmpty(value.BaseField))
{
var baseField =
pt.SourceRange.Columns().FirstOrDefault(c => c.Cell(1).Value.ToString() == value.BaseField);
if (baseField != null)
df.BaseField = baseField.ColumnNumber() - 1;
}
else
{
df.BaseField = 0;
}
if (value.CalculationItem == XLPivotCalculationItem.Previous)
df.BaseItem = 1048828U;
else if (value.CalculationItem == XLPivotCalculationItem.Next)
df.BaseItem = 1048829U;
else
df.BaseItem = 0U;
dataFields.AppendChild(df);
}
pivotTableDefinition.AppendChild(dataFields);
pivotTableDefinition.AppendChild(new PivotTableStyle
{
Name = Enum.GetName(typeof (XLPivotTableTheme), pt.Theme),
ShowRowHeaders = pt.ShowRowHeaders,
ShowColumnHeaders = pt.ShowColumnHeaders,
ShowRowStripes = pt.ShowRowStripes,
ShowColumnStripes = pt.ShowColumnStripes
});
#region Excel 2010 Features
var pivotTableDefinitionExtensionList = new PivotTableDefinitionExtensionList();
var pivotTableDefinitionExtension = new PivotTableDefinitionExtension
{Uri = "{962EF5D1-5CA2-4c93-8EF4-DBF5C05439D2}"};
pivotTableDefinitionExtension.AddNamespaceDeclaration("x14",
"http://schemas.microsoft.com/office/spreadsheetml/2009/9/main");
var pivotTableDefinition2 = new DocumentFormat.OpenXml.Office2010.Excel.PivotTableDefinition
{EnableEdit = pt.EnableCellEditing, HideValuesRow = !pt.ShowValuesRow};
pivotTableDefinition2.AddNamespaceDeclaration("xm", "http://schemas.microsoft.com/office/excel/2006/main");
pivotTableDefinitionExtension.AppendChild(pivotTableDefinition2);
pivotTableDefinitionExtensionList.AppendChild(pivotTableDefinitionExtension);
pivotTableDefinition.AppendChild(pivotTableDefinitionExtensionList);
#endregion
pivotTablePart1.PivotTableDefinition = pivotTableDefinition;
}
public bool TryGetInnerRow(PivotKey key, out RowItem row)
{
return _innerRows.TryGetValue(key, out row);
}
public void AddInnerRow(PivotKey key, RowItem innerRow)
{
_innerRows.Add(key, innerRow);
}
public ApplyRowFilterTask(RowItem[] rows, PropertyDescriptor[] properties, string filterText, bool matchCase)
{
_rows = rows;
_properties = properties;
FilterText = filterText;
MatchCase = matchCase;
}
