/// <summary> /// Create an instance of OpenXmlPart according to the given relationship type. /// </summary> /// <param name="openXmlPackage">The container OpenXmlPackage.</param> /// <param name="relationshipType">The relationship type of the target part.</param> /// <param name="openXmlPart">The created instance of OpenXmlPart.</param> /// <remarks>This partial method will be generated by code generaotr.</remarks> static partial void CreatePartCore(OpenXmlPackage openXmlPackage, string relationshipType, ref OpenXmlPart openXmlPart) { if (openXmlPackage == null) { throw new ArgumentNullException("openXmlPackage"); } if (relationshipType == null) { throw new ArgumentNullException("relationshipType"); } if (openXmlPackage is WordprocessingDocument) { switch (relationshipType) { case MainDocumentPart.RelationshipTypeConstant: openXmlPart = new MainDocumentPart(); return; case CustomXmlPart.RelationshipTypeConstant: openXmlPart = new CustomXmlPart(); return; case CustomXmlPropertiesPart.RelationshipTypeConstant: openXmlPart = new CustomXmlPropertiesPart(); return; case GlossaryDocumentPart.RelationshipTypeConstant: openXmlPart = new GlossaryDocumentPart(); return; case WordprocessingCommentsPart.RelationshipTypeConstant: openXmlPart = new WordprocessingCommentsPart(); return; case AlternativeFormatImportPart.RelationshipTypeConstant: openXmlPart = new AlternativeFormatImportPart(); return; case ChartPart.RelationshipTypeConstant: openXmlPart = new ChartPart(); return; case ChartDrawingPart.RelationshipTypeConstant: openXmlPart = new ChartDrawingPart(); return; case ImagePart.RelationshipTypeConstant: openXmlPart = new ImagePart(); return; case EmbeddedPackagePart.RelationshipTypeConstant: openXmlPart = new EmbeddedPackagePart(); return; case ThemeOverridePart.RelationshipTypeConstant: openXmlPart = new ThemeOverridePart(); return; case ChartStylePart.RelationshipTypeConstant: openXmlPart = new ChartStylePart(); return; case ChartColorStylePart.RelationshipTypeConstant: openXmlPart = new ChartColorStylePart(); return; case DiagramColorsPart.RelationshipTypeConstant: openXmlPart = new DiagramColorsPart(); return; case DiagramDataPart.RelationshipTypeConstant: openXmlPart = new DiagramDataPart(); return; case SlidePart.RelationshipTypeConstant: openXmlPart = new SlidePart(); return; case DiagramPersistLayoutPart.RelationshipTypeConstant: openXmlPart = new DiagramPersistLayoutPart(); return; case DiagramLayoutDefinitionPart.RelationshipTypeConstant: openXmlPart = new DiagramLayoutDefinitionPart(); return; case DiagramStylePart.RelationshipTypeConstant: openXmlPart = new DiagramStylePart(); return; case EmbeddedObjectPart.RelationshipTypeConstant: openXmlPart = new EmbeddedObjectPart(); return; case VmlDrawingPart.RelationshipTypeConstant: openXmlPart = new VmlDrawingPart(); return; case LegacyDiagramTextPart.RelationshipTypeConstant: openXmlPart = new LegacyDiagramTextPart(); return; case EmbeddedControlPersistenceBinaryDataPart.RelationshipTypeConstant: openXmlPart = new EmbeddedControlPersistenceBinaryDataPart(); return; case NotesSlidePart.RelationshipTypeConstant: openXmlPart = new NotesSlidePart(); return; case NotesMasterPart.RelationshipTypeConstant: openXmlPart = new NotesMasterPart(); return; case ThemePart.RelationshipTypeConstant: openXmlPart = new ThemePart(); return; case UserDefinedTagsPart.RelationshipTypeConstant: openXmlPart = new UserDefinedTagsPart(); return; case SlideLayoutPart.RelationshipTypeConstant: openXmlPart = new SlideLayoutPart(); return; case SlideMasterPart.RelationshipTypeConstant: openXmlPart = new SlideMasterPart(); return; case EmbeddedControlPersistencePart.RelationshipTypeConstant: openXmlPart = new EmbeddedControlPersistencePart(); return; case SlideSyncDataPart.RelationshipTypeConstant: openXmlPart = new SlideSyncDataPart(); return; case WorksheetPart.RelationshipTypeConstant: openXmlPart = new WorksheetPart(); return; case DrawingsPart.RelationshipTypeConstant: openXmlPart = new DrawingsPart(); return; case WebExtensionPart.RelationshipTypeConstant: openXmlPart = new WebExtensionPart(); return; case PivotTablePart.RelationshipTypeConstant: openXmlPart = new PivotTablePart(); return; case PivotTableCacheDefinitionPart.RelationshipTypeConstant: openXmlPart = new PivotTableCacheDefinitionPart(); return; case PivotTableCacheRecordsPart.RelationshipTypeConstant: openXmlPart = new PivotTableCacheRecordsPart(); return; case SingleCellTablePart.RelationshipTypeConstant: openXmlPart = new SingleCellTablePart(); return; case TableDefinitionPart.RelationshipTypeConstant: openXmlPart = new TableDefinitionPart(); return; case QueryTablePart.RelationshipTypeConstant: openXmlPart = new QueryTablePart(); return; case ControlPropertiesPart.RelationshipTypeConstant: openXmlPart = new ControlPropertiesPart(); return; case CustomPropertyPart.RelationshipTypeConstant: openXmlPart = new CustomPropertyPart(); return; case WorksheetSortMapPart.RelationshipTypeConstant: openXmlPart = new WorksheetSortMapPart(); return; case SlicersPart.RelationshipTypeConstant: openXmlPart = new SlicersPart(); return; case TimeLinePart.RelationshipTypeConstant: openXmlPart = new TimeLinePart(); return; case DocumentSettingsPart.RelationshipTypeConstant: openXmlPart = new DocumentSettingsPart(); return; case MailMergeRecipientDataPart.RelationshipTypeConstant: openXmlPart = new MailMergeRecipientDataPart(); return; case EndnotesPart.RelationshipTypeConstant: openXmlPart = new EndnotesPart(); return; case FontTablePart.RelationshipTypeConstant: openXmlPart = new FontTablePart(); return; case FontPart.RelationshipTypeConstant: openXmlPart = new FontPart(); return; case FootnotesPart.RelationshipTypeConstant: openXmlPart = new FootnotesPart(); return; case NumberingDefinitionsPart.RelationshipTypeConstant: openXmlPart = new NumberingDefinitionsPart(); return; case StyleDefinitionsPart.RelationshipTypeConstant: openXmlPart = new StyleDefinitionsPart(); return; case StylesWithEffectsPart.RelationshipTypeConstant: openXmlPart = new StylesWithEffectsPart(); return; case WebSettingsPart.RelationshipTypeConstant: openXmlPart = new WebSettingsPart(); return; case FooterPart.RelationshipTypeConstant: openXmlPart = new FooterPart(); return; case HeaderPart.RelationshipTypeConstant: openXmlPart = new HeaderPart(); return; case WordprocessingPrinterSettingsPart.RelationshipTypeConstant: openXmlPart = new WordprocessingPrinterSettingsPart(); return; case CustomizationPart.RelationshipTypeConstant: openXmlPart = new CustomizationPart(); return; case WordAttachedToolbarsPart.RelationshipTypeConstant: openXmlPart = new WordAttachedToolbarsPart(); return; case VbaProjectPart.RelationshipTypeConstant: openXmlPart = new VbaProjectPart(); return; case VbaDataPart.RelationshipTypeConstant: openXmlPart = new VbaDataPart(); return; case WordprocessingCommentsExPart.RelationshipTypeConstant: openXmlPart = new WordprocessingCommentsExPart(); return; case WordprocessingPeoplePart.RelationshipTypeConstant: openXmlPart = new WordprocessingPeoplePart(); return; case ThumbnailPart.RelationshipTypeConstant: openXmlPart = new ThumbnailPart(); return; case CoreFilePropertiesPart.RelationshipTypeConstant: openXmlPart = new CoreFilePropertiesPart(); return; case ExtendedFilePropertiesPart.RelationshipTypeConstant: openXmlPart = new ExtendedFilePropertiesPart(); return; case CustomFilePropertiesPart.RelationshipTypeConstant: openXmlPart = new CustomFilePropertiesPart(); return; case DigitalSignatureOriginPart.RelationshipTypeConstant: openXmlPart = new DigitalSignatureOriginPart(); return; case XmlSignaturePart.RelationshipTypeConstant: openXmlPart = new XmlSignaturePart(); return; case QuickAccessToolbarCustomizationsPart.RelationshipTypeConstant: openXmlPart = new QuickAccessToolbarCustomizationsPart(); return; case RibbonExtensibilityPart.RelationshipTypeConstant: openXmlPart = new RibbonExtensibilityPart(); return; case RibbonAndBackstageCustomizationsPart.RelationshipTypeConstant: openXmlPart = new RibbonAndBackstageCustomizationsPart(); return; case WebExTaskpanesPart.RelationshipTypeConstant: openXmlPart = new WebExTaskpanesPart(); return; } } else if (openXmlPackage is SpreadsheetDocument) { switch (relationshipType) { case WorkbookPart.RelationshipTypeConstant: openXmlPart = new WorkbookPart(); return; case CustomXmlPart.RelationshipTypeConstant: openXmlPart = new CustomXmlPart(); return; case CustomXmlPropertiesPart.RelationshipTypeConstant: openXmlPart = new CustomXmlPropertiesPart(); return; case CalculationChainPart.RelationshipTypeConstant: openXmlPart = new CalculationChainPart(); return; case CellMetadataPart.RelationshipTypeConstant: openXmlPart = new CellMetadataPart(); return; case ConnectionsPart.RelationshipTypeConstant: openXmlPart = new ConnectionsPart(); return; case CustomXmlMappingsPart.RelationshipTypeConstant: openXmlPart = new CustomXmlMappingsPart(); return; case SharedStringTablePart.RelationshipTypeConstant: openXmlPart = new SharedStringTablePart(); return; case WorkbookRevisionHeaderPart.RelationshipTypeConstant: openXmlPart = new WorkbookRevisionHeaderPart(); return; case WorkbookRevisionLogPart.RelationshipTypeConstant: openXmlPart = new WorkbookRevisionLogPart(); return; case WorkbookUserDataPart.RelationshipTypeConstant: openXmlPart = new WorkbookUserDataPart(); return; case WorkbookStylesPart.RelationshipTypeConstant: openXmlPart = new WorkbookStylesPart(); return; case ThemePart.RelationshipTypeConstant: openXmlPart = new ThemePart(); return; case ImagePart.RelationshipTypeConstant: openXmlPart = new ImagePart(); return; case ThumbnailPart.RelationshipTypeConstant: openXmlPart = new ThumbnailPart(); return; case VolatileDependenciesPart.RelationshipTypeConstant: openXmlPart = new VolatileDependenciesPart(); return; case ChartsheetPart.RelationshipTypeConstant: openXmlPart = new ChartsheetPart(); return; case SpreadsheetPrinterSettingsPart.RelationshipTypeConstant: openXmlPart = new SpreadsheetPrinterSettingsPart(); return; case DrawingsPart.RelationshipTypeConstant: openXmlPart = new DrawingsPart(); return; case ChartPart.RelationshipTypeConstant: openXmlPart = new ChartPart(); return; case ChartDrawingPart.RelationshipTypeConstant: openXmlPart = new ChartDrawingPart(); return; case EmbeddedPackagePart.RelationshipTypeConstant: openXmlPart = new EmbeddedPackagePart(); return; case ThemeOverridePart.RelationshipTypeConstant: openXmlPart = new ThemeOverridePart(); return; case ChartStylePart.RelationshipTypeConstant: openXmlPart = new ChartStylePart(); return; case ChartColorStylePart.RelationshipTypeConstant: openXmlPart = new ChartColorStylePart(); return; case DiagramColorsPart.RelationshipTypeConstant: openXmlPart = new DiagramColorsPart(); return; case DiagramDataPart.RelationshipTypeConstant: openXmlPart = new DiagramDataPart(); return; case SlidePart.RelationshipTypeConstant: openXmlPart = new SlidePart(); return; case DiagramPersistLayoutPart.RelationshipTypeConstant: openXmlPart = new DiagramPersistLayoutPart(); return; case DiagramLayoutDefinitionPart.RelationshipTypeConstant: openXmlPart = new DiagramLayoutDefinitionPart(); return; case DiagramStylePart.RelationshipTypeConstant: openXmlPart = new DiagramStylePart(); return; case EmbeddedObjectPart.RelationshipTypeConstant: openXmlPart = new EmbeddedObjectPart(); return; case VmlDrawingPart.RelationshipTypeConstant: openXmlPart = new VmlDrawingPart(); return; case LegacyDiagramTextPart.RelationshipTypeConstant: openXmlPart = new LegacyDiagramTextPart(); return; case EmbeddedControlPersistenceBinaryDataPart.RelationshipTypeConstant: openXmlPart = new EmbeddedControlPersistenceBinaryDataPart(); return; case NotesSlidePart.RelationshipTypeConstant: openXmlPart = new NotesSlidePart(); return; case NotesMasterPart.RelationshipTypeConstant: openXmlPart = new NotesMasterPart(); return; case UserDefinedTagsPart.RelationshipTypeConstant: openXmlPart = new UserDefinedTagsPart(); return; case SlideLayoutPart.RelationshipTypeConstant: openXmlPart = new SlideLayoutPart(); return; case SlideMasterPart.RelationshipTypeConstant: openXmlPart = new SlideMasterPart(); return; case EmbeddedControlPersistencePart.RelationshipTypeConstant: openXmlPart = new EmbeddedControlPersistencePart(); return; case SlideSyncDataPart.RelationshipTypeConstant: openXmlPart = new SlideSyncDataPart(); return; case WorksheetPart.RelationshipTypeConstant: openXmlPart = new WorksheetPart(); return; case WorksheetCommentsPart.RelationshipTypeConstant: openXmlPart = new WorksheetCommentsPart(); return; case PivotTablePart.RelationshipTypeConstant: openXmlPart = new PivotTablePart(); return; case PivotTableCacheDefinitionPart.RelationshipTypeConstant: openXmlPart = new PivotTableCacheDefinitionPart(); return; case PivotTableCacheRecordsPart.RelationshipTypeConstant: openXmlPart = new PivotTableCacheRecordsPart(); return; case SingleCellTablePart.RelationshipTypeConstant: openXmlPart = new SingleCellTablePart(); return; case TableDefinitionPart.RelationshipTypeConstant: openXmlPart = new TableDefinitionPart(); return; case QueryTablePart.RelationshipTypeConstant: openXmlPart = new QueryTablePart(); return; case ControlPropertiesPart.RelationshipTypeConstant: openXmlPart = new ControlPropertiesPart(); return; case CustomPropertyPart.RelationshipTypeConstant: openXmlPart = new CustomPropertyPart(); return; case WorksheetSortMapPart.RelationshipTypeConstant: openXmlPart = new WorksheetSortMapPart(); return; case SlicersPart.RelationshipTypeConstant: openXmlPart = new SlicersPart(); return; case TimeLinePart.RelationshipTypeConstant: openXmlPart = new TimeLinePart(); return; case WebExtensionPart.RelationshipTypeConstant: openXmlPart = new WebExtensionPart(); return; case DialogsheetPart.RelationshipTypeConstant: openXmlPart = new DialogsheetPart(); return; case ExternalWorkbookPart.RelationshipTypeConstant: openXmlPart = new ExternalWorkbookPart(); return; case ExcelAttachedToolbarsPart.RelationshipTypeConstant: openXmlPart = new ExcelAttachedToolbarsPart(); return; case VbaProjectPart.RelationshipTypeConstant: openXmlPart = new VbaProjectPart(); return; case VbaDataPart.RelationshipTypeConstant: openXmlPart = new VbaDataPart(); return; case MacroSheetPart.RelationshipTypeConstant: openXmlPart = new MacroSheetPart(); return; case InternationalMacroSheetPart.RelationshipTypeConstant: openXmlPart = new InternationalMacroSheetPart(); return; case CustomDataPropertiesPart.RelationshipTypeConstant: openXmlPart = new CustomDataPropertiesPart(); return; case CustomDataPart.RelationshipTypeConstant: openXmlPart = new CustomDataPart(); return; case SlicerCachePart.RelationshipTypeConstant: openXmlPart = new SlicerCachePart(); return; case TimeLineCachePart.RelationshipTypeConstant: openXmlPart = new TimeLineCachePart(); return; case CoreFilePropertiesPart.RelationshipTypeConstant: openXmlPart = new CoreFilePropertiesPart(); return; case ExtendedFilePropertiesPart.RelationshipTypeConstant: openXmlPart = new ExtendedFilePropertiesPart(); return; case CustomFilePropertiesPart.RelationshipTypeConstant: openXmlPart = new CustomFilePropertiesPart(); return; case DigitalSignatureOriginPart.RelationshipTypeConstant: openXmlPart = new DigitalSignatureOriginPart(); return; case XmlSignaturePart.RelationshipTypeConstant: openXmlPart = new XmlSignaturePart(); return; case QuickAccessToolbarCustomizationsPart.RelationshipTypeConstant: openXmlPart = new QuickAccessToolbarCustomizationsPart(); return; case RibbonExtensibilityPart.RelationshipTypeConstant: openXmlPart = new RibbonExtensibilityPart(); return; case RibbonAndBackstageCustomizationsPart.RelationshipTypeConstant: openXmlPart = new RibbonAndBackstageCustomizationsPart(); return; case WebExTaskpanesPart.RelationshipTypeConstant: openXmlPart = new WebExTaskpanesPart(); return; } } else if (openXmlPackage is PresentationDocument) { switch (relationshipType) { case PresentationPart.RelationshipTypeConstant: openXmlPart = new PresentationPart(); return; case CustomXmlPart.RelationshipTypeConstant: openXmlPart = new CustomXmlPart(); return; case CustomXmlPropertiesPart.RelationshipTypeConstant: openXmlPart = new CustomXmlPropertiesPart(); return; case FontPart.RelationshipTypeConstant: openXmlPart = new FontPart(); return; case PresentationPropertiesPart.RelationshipTypeConstant: openXmlPart = new PresentationPropertiesPart(); return; case TableStylesPart.RelationshipTypeConstant: openXmlPart = new TableStylesPart(); return; case ThemePart.RelationshipTypeConstant: openXmlPart = new ThemePart(); return; case ImagePart.RelationshipTypeConstant: openXmlPart = new ImagePart(); return; case ViewPropertiesPart.RelationshipTypeConstant: openXmlPart = new ViewPropertiesPart(); return; case SlidePart.RelationshipTypeConstant: openXmlPart = new SlidePart(); return; case ChartPart.RelationshipTypeConstant: openXmlPart = new ChartPart(); return; case ChartDrawingPart.RelationshipTypeConstant: openXmlPart = new ChartDrawingPart(); return; case EmbeddedPackagePart.RelationshipTypeConstant: openXmlPart = new EmbeddedPackagePart(); return; case ThemeOverridePart.RelationshipTypeConstant: openXmlPart = new ThemeOverridePart(); return; case ChartStylePart.RelationshipTypeConstant: openXmlPart = new ChartStylePart(); return; case ChartColorStylePart.RelationshipTypeConstant: openXmlPart = new ChartColorStylePart(); return; case DiagramColorsPart.RelationshipTypeConstant: openXmlPart = new DiagramColorsPart(); return; case DiagramDataPart.RelationshipTypeConstant: openXmlPart = new DiagramDataPart(); return; case WorksheetPart.RelationshipTypeConstant: openXmlPart = new WorksheetPart(); return; case DrawingsPart.RelationshipTypeConstant: openXmlPart = new DrawingsPart(); return; case DiagramPersistLayoutPart.RelationshipTypeConstant: openXmlPart = new DiagramPersistLayoutPart(); return; case DiagramLayoutDefinitionPart.RelationshipTypeConstant: openXmlPart = new DiagramLayoutDefinitionPart(); return; case DiagramStylePart.RelationshipTypeConstant: openXmlPart = new DiagramStylePart(); return; case WebExtensionPart.RelationshipTypeConstant: openXmlPart = new WebExtensionPart(); return; case VmlDrawingPart.RelationshipTypeConstant: openXmlPart = new VmlDrawingPart(); return; case LegacyDiagramTextPart.RelationshipTypeConstant: openXmlPart = new LegacyDiagramTextPart(); return; case PivotTablePart.RelationshipTypeConstant: openXmlPart = new PivotTablePart(); return; case PivotTableCacheDefinitionPart.RelationshipTypeConstant: openXmlPart = new PivotTableCacheDefinitionPart(); return; case PivotTableCacheRecordsPart.RelationshipTypeConstant: openXmlPart = new PivotTableCacheRecordsPart(); return; case SingleCellTablePart.RelationshipTypeConstant: openXmlPart = new SingleCellTablePart(); return; case TableDefinitionPart.RelationshipTypeConstant: openXmlPart = new TableDefinitionPart(); return; case QueryTablePart.RelationshipTypeConstant: openXmlPart = new QueryTablePart(); return; case EmbeddedControlPersistencePart.RelationshipTypeConstant: openXmlPart = new EmbeddedControlPersistencePart(); return; case EmbeddedControlPersistenceBinaryDataPart.RelationshipTypeConstant: openXmlPart = new EmbeddedControlPersistenceBinaryDataPart(); return; case ControlPropertiesPart.RelationshipTypeConstant: openXmlPart = new ControlPropertiesPart(); return; case EmbeddedObjectPart.RelationshipTypeConstant: openXmlPart = new EmbeddedObjectPart(); return; case CustomPropertyPart.RelationshipTypeConstant: openXmlPart = new CustomPropertyPart(); return; case WorksheetSortMapPart.RelationshipTypeConstant: openXmlPart = new WorksheetSortMapPart(); return; case SlicersPart.RelationshipTypeConstant: openXmlPart = new SlicersPart(); return; case TimeLinePart.RelationshipTypeConstant: openXmlPart = new TimeLinePart(); return; case SlideCommentsPart.RelationshipTypeConstant: openXmlPart = new SlideCommentsPart(); return; case NotesSlidePart.RelationshipTypeConstant: openXmlPart = new NotesSlidePart(); return; case NotesMasterPart.RelationshipTypeConstant: openXmlPart = new NotesMasterPart(); return; case UserDefinedTagsPart.RelationshipTypeConstant: openXmlPart = new UserDefinedTagsPart(); return; case SlideLayoutPart.RelationshipTypeConstant: openXmlPart = new SlideLayoutPart(); return; case SlideMasterPart.RelationshipTypeConstant: openXmlPart = new SlideMasterPart(); return; case SlideSyncDataPart.RelationshipTypeConstant: openXmlPart = new SlideSyncDataPart(); return; case CommentAuthorsPart.RelationshipTypeConstant: openXmlPart = new CommentAuthorsPart(); return; case HandoutMasterPart.RelationshipTypeConstant: openXmlPart = new HandoutMasterPart(); return; case LegacyDiagramTextInfoPart.RelationshipTypeConstant: openXmlPart = new LegacyDiagramTextInfoPart(); return; case VbaProjectPart.RelationshipTypeConstant: openXmlPart = new VbaProjectPart(); return; case VbaDataPart.RelationshipTypeConstant: openXmlPart = new VbaDataPart(); return; case CoreFilePropertiesPart.RelationshipTypeConstant: openXmlPart = new CoreFilePropertiesPart(); return; case ExtendedFilePropertiesPart.RelationshipTypeConstant: openXmlPart = new ExtendedFilePropertiesPart(); return; case CustomFilePropertiesPart.RelationshipTypeConstant: openXmlPart = new CustomFilePropertiesPart(); return; case ThumbnailPart.RelationshipTypeConstant: openXmlPart = new ThumbnailPart(); return; case DigitalSignatureOriginPart.RelationshipTypeConstant: openXmlPart = new DigitalSignatureOriginPart(); return; case XmlSignaturePart.RelationshipTypeConstant: openXmlPart = new XmlSignaturePart(); return; case QuickAccessToolbarCustomizationsPart.RelationshipTypeConstant: openXmlPart = new QuickAccessToolbarCustomizationsPart(); return; case RibbonExtensibilityPart.RelationshipTypeConstant: openXmlPart = new RibbonExtensibilityPart(); return; case RibbonAndBackstageCustomizationsPart.RelationshipTypeConstant: openXmlPart = new RibbonAndBackstageCustomizationsPart(); return; case WebExTaskpanesPart.RelationshipTypeConstant: openXmlPart = new WebExTaskpanesPart(); return; } } else { System.Diagnostics.Debug.Assert(false); } return; }
// Generates content of calculationChainPart1. private void GenerateCalculationChainPart1Content(CalculationChainPart calculationChainPart1) { CalculationChain calculationChain1 = new CalculationChain(); CalculationCell calculationCell1 = new CalculationCell() { CellReference = "AN29", SheetId = 26 }; CalculationCell calculationCell2 = new CalculationCell() { CellReference = "AN26" }; CalculationCell calculationCell3 = new CalculationCell() { CellReference = "AM26" }; CalculationCell calculationCell4 = new CalculationCell() { CellReference = "G40" }; CalculationCell calculationCell5 = new CalculationCell() { CellReference = "AF26" }; CalculationCell calculationCell6 = new CalculationCell() { CellReference = "AL25" }; CalculationCell calculationCell7 = new CalculationCell() { CellReference = "AL24" }; CalculationCell calculationCell8 = new CalculationCell() { CellReference = "AL23" }; CalculationCell calculationCell9 = new CalculationCell() { CellReference = "AL22" }; CalculationCell calculationCell10 = new CalculationCell() { CellReference = "AL21" }; CalculationCell calculationCell11 = new CalculationCell() { CellReference = "G39" }; CalculationCell calculationCell12 = new CalculationCell() { CellReference = "G38" }; CalculationCell calculationCell13 = new CalculationCell() { CellReference = "G37" }; CalculationCell calculationCell14 = new CalculationCell() { CellReference = "G36" }; CalculationCell calculationCell15 = new CalculationCell() { CellReference = "G35" }; CalculationCell calculationCell16 = new CalculationCell() { CellReference = "AN25" }; CalculationCell calculationCell17 = new CalculationCell() { CellReference = "AN24" }; CalculationCell calculationCell18 = new CalculationCell() { CellReference = "AN23" }; CalculationCell calculationCell19 = new CalculationCell() { CellReference = "G18" }; CalculationCell calculationCell20 = new CalculationCell() { CellReference = "AN22" }; CalculationCell calculationCell21 = new CalculationCell() { CellReference = "G26" }; CalculationCell calculationCell22 = new CalculationCell() { CellReference = "H26" }; CalculationCell calculationCell23 = new CalculationCell() { CellReference = "I26" }; CalculationCell calculationCell24 = new CalculationCell() { CellReference = "J26" }; CalculationCell calculationCell25 = new CalculationCell() { CellReference = "K26" }; CalculationCell calculationCell26 = new CalculationCell() { CellReference = "L26" }; CalculationCell calculationCell27 = new CalculationCell() { CellReference = "M26" }; CalculationCell calculationCell28 = new CalculationCell() { CellReference = "N26" }; CalculationCell calculationCell29 = new CalculationCell() { CellReference = "O26" }; CalculationCell calculationCell30 = new CalculationCell() { CellReference = "P26" }; CalculationCell calculationCell31 = new CalculationCell() { CellReference = "Q26" }; CalculationCell calculationCell32 = new CalculationCell() { CellReference = "R26" }; CalculationCell calculationCell33 = new CalculationCell() { CellReference = "S26" }; CalculationCell calculationCell34 = new CalculationCell() { CellReference = "T26" }; CalculationCell calculationCell35 = new CalculationCell() { CellReference = "U26" }; CalculationCell calculationCell36 = new CalculationCell() { CellReference = "V26" }; CalculationCell calculationCell37 = new CalculationCell() { CellReference = "W26" }; CalculationCell calculationCell38 = new CalculationCell() { CellReference = "X26" }; CalculationCell calculationCell39 = new CalculationCell() { CellReference = "Y26" }; CalculationCell calculationCell40 = new CalculationCell() { CellReference = "Z26" }; CalculationCell calculationCell41 = new CalculationCell() { CellReference = "AA26" }; CalculationCell calculationCell42 = new CalculationCell() { CellReference = "AB26" }; CalculationCell calculationCell43 = new CalculationCell() { CellReference = "AC26" }; CalculationCell calculationCell44 = new CalculationCell() { CellReference = "AD26" }; CalculationCell calculationCell45 = new CalculationCell() { CellReference = "AE26" }; CalculationCell calculationCell46 = new CalculationCell() { CellReference = "AG26" }; CalculationCell calculationCell47 = new CalculationCell() { CellReference = "AH26" }; CalculationCell calculationCell48 = new CalculationCell() { CellReference = "AI26" }; CalculationCell calculationCell49 = new CalculationCell() { CellReference = "AJ26" }; CalculationCell calculationCell50 = new CalculationCell() { CellReference = "AK26" }; CalculationCell calculationCell51 = new CalculationCell() { CellReference = "AL26", NewLevel = true }; CalculationCell calculationCell52 = new CalculationCell() { CellReference = "AN21" }; CalculationCell calculationCell53 = new CalculationCell() { CellReference = "AN30", InChildChain = true }; CalculationCell calculationCell54 = new CalculationCell() { CellReference = "AN31", InChildChain = true }; CalculationCell calculationCell55 = new CalculationCell() { CellReference = "AN32", NewLevel = true }; CalculationCell calculationCell56 = new CalculationCell() { CellReference = "AN33" }; calculationChain1.Append(calculationCell1); calculationChain1.Append(calculationCell2); calculationChain1.Append(calculationCell3); calculationChain1.Append(calculationCell4); calculationChain1.Append(calculationCell5); calculationChain1.Append(calculationCell6); calculationChain1.Append(calculationCell7); calculationChain1.Append(calculationCell8); calculationChain1.Append(calculationCell9); calculationChain1.Append(calculationCell10); calculationChain1.Append(calculationCell11); calculationChain1.Append(calculationCell12); calculationChain1.Append(calculationCell13); calculationChain1.Append(calculationCell14); calculationChain1.Append(calculationCell15); calculationChain1.Append(calculationCell16); calculationChain1.Append(calculationCell17); calculationChain1.Append(calculationCell18); calculationChain1.Append(calculationCell19); calculationChain1.Append(calculationCell20); calculationChain1.Append(calculationCell21); calculationChain1.Append(calculationCell22); calculationChain1.Append(calculationCell23); calculationChain1.Append(calculationCell24); calculationChain1.Append(calculationCell25); calculationChain1.Append(calculationCell26); calculationChain1.Append(calculationCell27); calculationChain1.Append(calculationCell28); calculationChain1.Append(calculationCell29); calculationChain1.Append(calculationCell30); calculationChain1.Append(calculationCell31); calculationChain1.Append(calculationCell32); calculationChain1.Append(calculationCell33); calculationChain1.Append(calculationCell34); calculationChain1.Append(calculationCell35); calculationChain1.Append(calculationCell36); calculationChain1.Append(calculationCell37); calculationChain1.Append(calculationCell38); calculationChain1.Append(calculationCell39); calculationChain1.Append(calculationCell40); calculationChain1.Append(calculationCell41); calculationChain1.Append(calculationCell42); calculationChain1.Append(calculationCell43); calculationChain1.Append(calculationCell44); calculationChain1.Append(calculationCell45); calculationChain1.Append(calculationCell46); calculationChain1.Append(calculationCell47); calculationChain1.Append(calculationCell48); calculationChain1.Append(calculationCell49); calculationChain1.Append(calculationCell50); calculationChain1.Append(calculationCell51); calculationChain1.Append(calculationCell52); calculationChain1.Append(calculationCell53); calculationChain1.Append(calculationCell54); calculationChain1.Append(calculationCell55); calculationChain1.Append(calculationCell56); calculationChainPart1.CalculationChain = calculationChain1; }
// Generates content of calculationChainPart1. private void GenerateCalculationChainPart1Content(CalculationChainPart calculationChainPart1) { CalculationChain calculationChain1 = new CalculationChain(); CalculationCell calculationCell1 = new CalculationCell() { CellReference = "AG21", SheetId = 1 }; CalculationCell calculationCell2 = new CalculationCell() { CellReference = "AG23", InChildChain = true }; CalculationCell calculationCell3 = new CalculationCell() { CellReference = "AF21" }; CalculationCell calculationCell4 = new CalculationCell() { CellReference = "AF23", InChildChain = true }; CalculationCell calculationCell5 = new CalculationCell() { CellReference = "AI21" }; CalculationCell calculationCell6 = new CalculationCell() { CellReference = "AJ21" }; CalculationCell calculationCell7 = new CalculationCell() { CellReference = "AH20" }; CalculationCell calculationCell8 = new CalculationCell() { CellReference = "AH21", InChildChain = true }; CalculationCell calculationCell9 = new CalculationCell() { CellReference = "AH23", InChildChain = true }; CalculationCell calculationCell10 = new CalculationCell() { CellReference = "AJ23" }; CalculationCell calculationCell11 = new CalculationCell() { CellReference = "C21" }; CalculationCell calculationCell12 = new CalculationCell() { CellReference = "C23", InChildChain = true }; CalculationCell calculationCell13 = new CalculationCell() { CellReference = "D21" }; CalculationCell calculationCell14 = new CalculationCell() { CellReference = "D23", InChildChain = true }; CalculationCell calculationCell15 = new CalculationCell() { CellReference = "E21" }; CalculationCell calculationCell16 = new CalculationCell() { CellReference = "E23", InChildChain = true }; CalculationCell calculationCell17 = new CalculationCell() { CellReference = "F21" }; CalculationCell calculationCell18 = new CalculationCell() { CellReference = "F23", InChildChain = true }; CalculationCell calculationCell19 = new CalculationCell() { CellReference = "G21" }; CalculationCell calculationCell20 = new CalculationCell() { CellReference = "G23", InChildChain = true }; CalculationCell calculationCell21 = new CalculationCell() { CellReference = "H21" }; CalculationCell calculationCell22 = new CalculationCell() { CellReference = "H23", InChildChain = true }; CalculationCell calculationCell23 = new CalculationCell() { CellReference = "I21" }; CalculationCell calculationCell24 = new CalculationCell() { CellReference = "I23", InChildChain = true }; CalculationCell calculationCell25 = new CalculationCell() { CellReference = "J21" }; CalculationCell calculationCell26 = new CalculationCell() { CellReference = "J23", InChildChain = true }; CalculationCell calculationCell27 = new CalculationCell() { CellReference = "K21" }; CalculationCell calculationCell28 = new CalculationCell() { CellReference = "K23", InChildChain = true }; CalculationCell calculationCell29 = new CalculationCell() { CellReference = "L21" }; CalculationCell calculationCell30 = new CalculationCell() { CellReference = "L23", InChildChain = true }; CalculationCell calculationCell31 = new CalculationCell() { CellReference = "M21" }; CalculationCell calculationCell32 = new CalculationCell() { CellReference = "M23", InChildChain = true }; CalculationCell calculationCell33 = new CalculationCell() { CellReference = "N21" }; CalculationCell calculationCell34 = new CalculationCell() { CellReference = "N23", InChildChain = true }; CalculationCell calculationCell35 = new CalculationCell() { CellReference = "O21" }; CalculationCell calculationCell36 = new CalculationCell() { CellReference = "O23", InChildChain = true }; CalculationCell calculationCell37 = new CalculationCell() { CellReference = "P21" }; CalculationCell calculationCell38 = new CalculationCell() { CellReference = "P23", InChildChain = true }; CalculationCell calculationCell39 = new CalculationCell() { CellReference = "Q21" }; CalculationCell calculationCell40 = new CalculationCell() { CellReference = "Q23", InChildChain = true }; CalculationCell calculationCell41 = new CalculationCell() { CellReference = "R21" }; CalculationCell calculationCell42 = new CalculationCell() { CellReference = "R23", InChildChain = true }; CalculationCell calculationCell43 = new CalculationCell() { CellReference = "S21" }; CalculationCell calculationCell44 = new CalculationCell() { CellReference = "S23", InChildChain = true }; CalculationCell calculationCell45 = new CalculationCell() { CellReference = "T21" }; CalculationCell calculationCell46 = new CalculationCell() { CellReference = "T23", InChildChain = true }; CalculationCell calculationCell47 = new CalculationCell() { CellReference = "U21" }; CalculationCell calculationCell48 = new CalculationCell() { CellReference = "U23", InChildChain = true }; CalculationCell calculationCell49 = new CalculationCell() { CellReference = "V21" }; CalculationCell calculationCell50 = new CalculationCell() { CellReference = "V23", InChildChain = true }; CalculationCell calculationCell51 = new CalculationCell() { CellReference = "W21" }; CalculationCell calculationCell52 = new CalculationCell() { CellReference = "W23", InChildChain = true }; CalculationCell calculationCell53 = new CalculationCell() { CellReference = "X21" }; CalculationCell calculationCell54 = new CalculationCell() { CellReference = "X23", InChildChain = true }; CalculationCell calculationCell55 = new CalculationCell() { CellReference = "Y21" }; CalculationCell calculationCell56 = new CalculationCell() { CellReference = "Y23", InChildChain = true }; CalculationCell calculationCell57 = new CalculationCell() { CellReference = "Z21" }; CalculationCell calculationCell58 = new CalculationCell() { CellReference = "Z23", InChildChain = true }; CalculationCell calculationCell59 = new CalculationCell() { CellReference = "AA21" }; CalculationCell calculationCell60 = new CalculationCell() { CellReference = "AA23", InChildChain = true }; CalculationCell calculationCell61 = new CalculationCell() { CellReference = "AB21" }; CalculationCell calculationCell62 = new CalculationCell() { CellReference = "AB23", InChildChain = true }; CalculationCell calculationCell63 = new CalculationCell() { CellReference = "AC21" }; CalculationCell calculationCell64 = new CalculationCell() { CellReference = "AC23", InChildChain = true }; CalculationCell calculationCell65 = new CalculationCell() { CellReference = "AD21" }; CalculationCell calculationCell66 = new CalculationCell() { CellReference = "AD23", InChildChain = true }; CalculationCell calculationCell67 = new CalculationCell() { CellReference = "AE21" }; CalculationCell calculationCell68 = new CalculationCell() { CellReference = "AE23", InChildChain = true }; CalculationCell calculationCell69 = new CalculationCell() { CellReference = "AK20", NewLevel = true }; CalculationCell calculationCell70 = new CalculationCell() { CellReference = "AK21", InChildChain = true }; calculationChain1.Append(calculationCell1); calculationChain1.Append(calculationCell2); calculationChain1.Append(calculationCell3); calculationChain1.Append(calculationCell4); calculationChain1.Append(calculationCell5); calculationChain1.Append(calculationCell6); calculationChain1.Append(calculationCell7); calculationChain1.Append(calculationCell8); calculationChain1.Append(calculationCell9); calculationChain1.Append(calculationCell10); calculationChain1.Append(calculationCell11); calculationChain1.Append(calculationCell12); calculationChain1.Append(calculationCell13); calculationChain1.Append(calculationCell14); calculationChain1.Append(calculationCell15); calculationChain1.Append(calculationCell16); calculationChain1.Append(calculationCell17); calculationChain1.Append(calculationCell18); calculationChain1.Append(calculationCell19); calculationChain1.Append(calculationCell20); calculationChain1.Append(calculationCell21); calculationChain1.Append(calculationCell22); calculationChain1.Append(calculationCell23); calculationChain1.Append(calculationCell24); calculationChain1.Append(calculationCell25); calculationChain1.Append(calculationCell26); calculationChain1.Append(calculationCell27); calculationChain1.Append(calculationCell28); calculationChain1.Append(calculationCell29); calculationChain1.Append(calculationCell30); calculationChain1.Append(calculationCell31); calculationChain1.Append(calculationCell32); calculationChain1.Append(calculationCell33); calculationChain1.Append(calculationCell34); calculationChain1.Append(calculationCell35); calculationChain1.Append(calculationCell36); calculationChain1.Append(calculationCell37); calculationChain1.Append(calculationCell38); calculationChain1.Append(calculationCell39); calculationChain1.Append(calculationCell40); calculationChain1.Append(calculationCell41); calculationChain1.Append(calculationCell42); calculationChain1.Append(calculationCell43); calculationChain1.Append(calculationCell44); calculationChain1.Append(calculationCell45); calculationChain1.Append(calculationCell46); calculationChain1.Append(calculationCell47); calculationChain1.Append(calculationCell48); calculationChain1.Append(calculationCell49); calculationChain1.Append(calculationCell50); calculationChain1.Append(calculationCell51); calculationChain1.Append(calculationCell52); calculationChain1.Append(calculationCell53); calculationChain1.Append(calculationCell54); calculationChain1.Append(calculationCell55); calculationChain1.Append(calculationCell56); calculationChain1.Append(calculationCell57); calculationChain1.Append(calculationCell58); calculationChain1.Append(calculationCell59); calculationChain1.Append(calculationCell60); calculationChain1.Append(calculationCell61); calculationChain1.Append(calculationCell62); calculationChain1.Append(calculationCell63); calculationChain1.Append(calculationCell64); calculationChain1.Append(calculationCell65); calculationChain1.Append(calculationCell66); calculationChain1.Append(calculationCell67); calculationChain1.Append(calculationCell68); calculationChain1.Append(calculationCell69); calculationChain1.Append(calculationCell70); calculationChainPart1.CalculationChain = calculationChain1; }
// Generates content of calculationChainPart1. private void GenerateCalculationChainPart1Content(CalculationChainPart calculationChainPart1) { CalculationChain calculationChain1 = new CalculationChain(); CalculationCell calculationCell1 = new CalculationCell() { CellReference = "J42", SheetId = 1 }; CalculationCell calculationCell2 = new CalculationCell() { CellReference = "J37" }; CalculationCell calculationCell3 = new CalculationCell() { CellReference = "J34" }; CalculationCell calculationCell4 = new CalculationCell() { CellReference = "J32" }; CalculationCell calculationCell5 = new CalculationCell() { CellReference = "H27" }; CalculationCell calculationCell6 = new CalculationCell() { CellReference = "G27" }; CalculationCell calculationCell7 = new CalculationCell() { CellReference = "F27" }; CalculationCell calculationCell8 = new CalculationCell() { CellReference = "E27" }; CalculationCell calculationCell9 = new CalculationCell() { CellReference = "D27" }; CalculationCell calculationCell10 = new CalculationCell() { CellReference = "C27" }; CalculationCell calculationCell11 = new CalculationCell() { CellReference = "B27" }; CalculationCell calculationCell12 = new CalculationCell() { CellReference = "J27", InChildChain = true }; CalculationCell calculationCell13 = new CalculationCell() { CellReference = "H22" }; CalculationCell calculationCell14 = new CalculationCell() { CellReference = "G22" }; CalculationCell calculationCell15 = new CalculationCell() { CellReference = "F22" }; CalculationCell calculationCell16 = new CalculationCell() { CellReference = "E22" }; CalculationCell calculationCell17 = new CalculationCell() { CellReference = "D22" }; CalculationCell calculationCell18 = new CalculationCell() { CellReference = "C22" }; CalculationCell calculationCell19 = new CalculationCell() { CellReference = "B22" }; CalculationCell calculationCell20 = new CalculationCell() { CellReference = "J22", InChildChain = true }; CalculationCell calculationCell21 = new CalculationCell() { CellReference = "H47", InChildChain = true }; CalculationCell calculationCell22 = new CalculationCell() { CellReference = "H49", InChildChain = true }; CalculationCell calculationCell23 = new CalculationCell() { CellReference = "H50", InChildChain = true }; CalculationCell calculationCell24 = new CalculationCell() { CellReference = "H51", InChildChain = true }; calculationChain1.Append(calculationCell1); calculationChain1.Append(calculationCell2); calculationChain1.Append(calculationCell3); calculationChain1.Append(calculationCell4); calculationChain1.Append(calculationCell5); calculationChain1.Append(calculationCell6); calculationChain1.Append(calculationCell7); calculationChain1.Append(calculationCell8); calculationChain1.Append(calculationCell9); calculationChain1.Append(calculationCell10); calculationChain1.Append(calculationCell11); calculationChain1.Append(calculationCell12); calculationChain1.Append(calculationCell13); calculationChain1.Append(calculationCell14); calculationChain1.Append(calculationCell15); calculationChain1.Append(calculationCell16); calculationChain1.Append(calculationCell17); calculationChain1.Append(calculationCell18); calculationChain1.Append(calculationCell19); calculationChain1.Append(calculationCell20); calculationChain1.Append(calculationCell21); calculationChain1.Append(calculationCell22); calculationChain1.Append(calculationCell23); calculationChain1.Append(calculationCell24); calculationChainPart1.CalculationChain = calculationChain1; }
// Generates content of calculationChainPart1. private void GenerateCalculationChainPart1Content(CalculationChainPart calculationChainPart1) { CalculationChain calculationChain1 = new CalculationChain(); CalculationCell calculationCell1 = new CalculationCell() { CellReference = "I49", SheetId = 1 }; CalculationCell calculationCell2 = new CalculationCell() { CellReference = "I48" }; CalculationCell calculationCell3 = new CalculationCell() { CellReference = "I46" }; CalculationCell calculationCell4 = new CalculationCell() { CellReference = "I44" }; CalculationCell calculationCell5 = new CalculationCell() { CellReference = "J42" }; CalculationCell calculationCell6 = new CalculationCell() { CellReference = "J37" }; CalculationCell calculationCell7 = new CalculationCell() { CellReference = "J32" }; CalculationCell calculationCell8 = new CalculationCell() { CellReference = "J27" }; CalculationCell calculationCell9 = new CalculationCell() { CellReference = "J22" }; calculationChain1.Append(calculationCell1); calculationChain1.Append(calculationCell2); calculationChain1.Append(calculationCell3); calculationChain1.Append(calculationCell4); calculationChain1.Append(calculationCell5); calculationChain1.Append(calculationCell6); calculationChain1.Append(calculationCell7); calculationChain1.Append(calculationCell8); calculationChain1.Append(calculationCell9); calculationChainPart1.CalculationChain = calculationChain1; }
// Generates content of calculationChainPart1. private void GenerateCalculationChainPart1Content(CalculationChainPart calculationChainPart1) { CalculationChain calculationChain1 = new CalculationChain(); CalculationCell calculationCell1 = new CalculationCell() { CellReference = "G20", SheetId = 2 }; CalculationCell calculationCell2 = new CalculationCell() { CellReference = "G21" }; calculationChain1.Append(calculationCell1); calculationChain1.Append(calculationCell2); calculationChainPart1.CalculationChain = calculationChain1; }
// Generates content of calculationChainPart1. private void GenerateCalculationChainPart1Content(CalculationChainPart calculationChainPart1) { CalculationChain calculationChain1 = new CalculationChain(); CalculationCell calculationCell1 = new CalculationCell() { CellReference = "A6", SheetId = 1, NewLevel = true }; calculationChain1.Append(calculationCell1); calculationChainPart1.CalculationChain = calculationChain1; }
// Generates content of calculationChainPart1. private void GenerateCalculationChainPart1Content(CalculationChainPart calculationChainPart1) { CalculationChain calculationChain1 = new CalculationChain(); CalculationCell calculationCell1 = new CalculationCell(){ CellReference = "C22", SheetId = 27 }; CalculationCell calculationCell2 = new CalculationCell(){ CellReference = "D22" }; CalculationCell calculationCell3 = new CalculationCell(){ CellReference = "E22" }; CalculationCell calculationCell4 = new CalculationCell(){ CellReference = "F22" }; CalculationCell calculationCell5 = new CalculationCell(){ CellReference = "G22" }; CalculationCell calculationCell6 = new CalculationCell(){ CellReference = "H22" }; CalculationCell calculationCell7 = new CalculationCell(){ CellReference = "I22" }; CalculationCell calculationCell8 = new CalculationCell(){ CellReference = "J22" }; CalculationCell calculationCell9 = new CalculationCell(){ CellReference = "C27" }; CalculationCell calculationCell10 = new CalculationCell(){ CellReference = "D27" }; CalculationCell calculationCell11 = new CalculationCell(){ CellReference = "E27" }; CalculationCell calculationCell12 = new CalculationCell(){ CellReference = "F27" }; CalculationCell calculationCell13 = new CalculationCell(){ CellReference = "G27" }; CalculationCell calculationCell14 = new CalculationCell(){ CellReference = "H27" }; CalculationCell calculationCell15 = new CalculationCell(){ CellReference = "I27" }; CalculationCell calculationCell16 = new CalculationCell(){ CellReference = "J27" }; CalculationCell calculationCell17 = new CalculationCell(){ CellReference = "C32" }; CalculationCell calculationCell18 = new CalculationCell(){ CellReference = "D32" }; CalculationCell calculationCell19 = new CalculationCell(){ CellReference = "E32" }; CalculationCell calculationCell20 = new CalculationCell(){ CellReference = "F32" }; CalculationCell calculationCell21 = new CalculationCell(){ CellReference = "G32" }; CalculationCell calculationCell22 = new CalculationCell(){ CellReference = "H32" }; CalculationCell calculationCell23 = new CalculationCell(){ CellReference = "I32" }; CalculationCell calculationCell24 = new CalculationCell(){ CellReference = "J32" }; CalculationCell calculationCell25 = new CalculationCell(){ CellReference = "C37" }; CalculationCell calculationCell26 = new CalculationCell(){ CellReference = "D37" }; CalculationCell calculationCell27 = new CalculationCell(){ CellReference = "E37" }; CalculationCell calculationCell28 = new CalculationCell(){ CellReference = "F37" }; CalculationCell calculationCell29 = new CalculationCell(){ CellReference = "G37" }; CalculationCell calculationCell30 = new CalculationCell(){ CellReference = "H37" }; CalculationCell calculationCell31 = new CalculationCell(){ CellReference = "I37" }; CalculationCell calculationCell32 = new CalculationCell(){ CellReference = "J37" }; CalculationCell calculationCell33 = new CalculationCell(){ CellReference = "C42" }; CalculationCell calculationCell34 = new CalculationCell(){ CellReference = "D42" }; CalculationCell calculationCell35 = new CalculationCell(){ CellReference = "E42" }; CalculationCell calculationCell36 = new CalculationCell(){ CellReference = "F42" }; CalculationCell calculationCell37 = new CalculationCell(){ CellReference = "G42" }; CalculationCell calculationCell38 = new CalculationCell(){ CellReference = "H42" }; CalculationCell calculationCell39 = new CalculationCell(){ CellReference = "I42" }; CalculationCell calculationCell40 = new CalculationCell(){ CellReference = "J42" }; CalculationCell calculationCell41 = new CalculationCell(){ CellReference = "I44" }; CalculationCell calculationCell42 = new CalculationCell(){ CellReference = "G45" }; CalculationCell calculationCell43 = new CalculationCell(){ CellReference = "G46" }; CalculationCell calculationCell44 = new CalculationCell(){ CellReference = "I46" }; CalculationCell calculationCell45 = new CalculationCell(){ CellReference = "G47" }; CalculationCell calculationCell46 = new CalculationCell(){ CellReference = "G48" }; CalculationCell calculationCell47 = new CalculationCell(){ CellReference = "I48" }; CalculationCell calculationCell48 = new CalculationCell(){ CellReference = "G49" }; CalculationCell calculationCell49 = new CalculationCell(){ CellReference = "I49" }; CalculationCell calculationCell50 = new CalculationCell(){ CellReference = "G50" }; calculationChain1.Append(calculationCell1); calculationChain1.Append(calculationCell2); calculationChain1.Append(calculationCell3); calculationChain1.Append(calculationCell4); calculationChain1.Append(calculationCell5); calculationChain1.Append(calculationCell6); calculationChain1.Append(calculationCell7); calculationChain1.Append(calculationCell8); calculationChain1.Append(calculationCell9); calculationChain1.Append(calculationCell10); calculationChain1.Append(calculationCell11); calculationChain1.Append(calculationCell12); calculationChain1.Append(calculationCell13); calculationChain1.Append(calculationCell14); calculationChain1.Append(calculationCell15); calculationChain1.Append(calculationCell16); calculationChain1.Append(calculationCell17); calculationChain1.Append(calculationCell18); calculationChain1.Append(calculationCell19); calculationChain1.Append(calculationCell20); calculationChain1.Append(calculationCell21); calculationChain1.Append(calculationCell22); calculationChain1.Append(calculationCell23); calculationChain1.Append(calculationCell24); calculationChain1.Append(calculationCell25); calculationChain1.Append(calculationCell26); calculationChain1.Append(calculationCell27); calculationChain1.Append(calculationCell28); calculationChain1.Append(calculationCell29); calculationChain1.Append(calculationCell30); calculationChain1.Append(calculationCell31); calculationChain1.Append(calculationCell32); calculationChain1.Append(calculationCell33); calculationChain1.Append(calculationCell34); calculationChain1.Append(calculationCell35); calculationChain1.Append(calculationCell36); calculationChain1.Append(calculationCell37); calculationChain1.Append(calculationCell38); calculationChain1.Append(calculationCell39); calculationChain1.Append(calculationCell40); calculationChain1.Append(calculationCell41); calculationChain1.Append(calculationCell42); calculationChain1.Append(calculationCell43); calculationChain1.Append(calculationCell44); calculationChain1.Append(calculationCell45); calculationChain1.Append(calculationCell46); calculationChain1.Append(calculationCell47); calculationChain1.Append(calculationCell48); calculationChain1.Append(calculationCell49); calculationChain1.Append(calculationCell50); calculationChainPart1.CalculationChain = calculationChain1; }