private void CreateWorkbook(string resource) { Workbook workbook; if (string.IsNullOrEmpty(resource)) { workbook = new Workbook(); workbook.Worksheets.Add("Sheet1"); } else { using (Stream stream = Assembly.GetExecutingAssembly().GetManifestResourceStream(resource)) { workbook = Workbook.Load(stream); } Worksheet sheet2 = workbook.Worksheets[2]; OperatorConditionalFormat condition1 = sheet2.ConditionalFormats.AddOperatorCondition("C5:C28", Infragistics.Documents.Excel.ConditionalFormatting.FormatConditionOperator.GreaterEqual); condition1.SetOperand1(2500); condition1.CellFormat.Font.ColorInfo = new WorkbookColorInfo(Color.Red); OperatorConditionalFormat condition2 = sheet2.ConditionalFormats.AddOperatorCondition("C5:C28", FormatConditionOperator.Less); condition2.SetOperand1(2500); condition2.CellFormat.Font.ColorInfo = new WorkbookColorInfo(Color.Green); } this.OnNewWorkbookSelected(workbook); }
private void CreateNewDocument(string templateName) { var tempDocumentName = string.Format(ResourceStrings.ResourceStrings.Text_TempDocumentName, 1); if (DocumentStatus == IgExcelDocumentStatus.NoDocumentLoaded || DocumentStatus == IgExcelDocumentStatus.ExistingNotModified || DocumentStatus == IgExcelDocumentStatus.BlankNotModified || DocumentStatus == IgExcelDocumentStatus.TemplateNotModified) { LoadTemplate(templateName); SetTitle(tempDocumentName); if (templateName == "ProjectBudget" && this.Workbook != null) { Worksheet sheet = this.Workbook.Worksheets[2]; OperatorConditionalFormat format1 = sheet.ConditionalFormats.AddOperatorCondition("C5:C28", Infragistics.Documents.Excel.ConditionalFormatting.FormatConditionOperator.GreaterEqual); format1.SetOperand1(2500); format1.CellFormat.Font.ColorInfo = new WorkbookColorInfo(System.Drawing.Color.Red); OperatorConditionalFormat format2 = sheet.ConditionalFormats.AddOperatorCondition("C5:C28", Infragistics.Documents.Excel.ConditionalFormatting.FormatConditionOperator.Less); format2.SetOperand1(2500); format2.CellFormat.Font.ColorInfo = new WorkbookColorInfo(System.Drawing.Color.Green); } this.IsBackstageOpened = false; this.IsSpreadSheetVisible = true; this.FileNameWithoutExtension = tempDocumentName; } else { var result = this.messageBoxService.Show(ResourceStrings.ResourceStrings.Text_ApplicationTitle, string.Format(ResourceStrings.ResourceStrings.Msg_WantToSaveChanges, tempDocumentName), MessageBoxButtons.YesNoCancel); if (result == InteractionResult.Yes) { this.isNewTemplateRequested = true; this.selectedTemplateName = templateName; ExecuteSaveDocument(); } else if (result == InteractionResult.No) { LoadTemplate(templateName); SetTitle(tempDocumentName); this.FileNameWithoutExtension = tempDocumentName; this.IsBackstageOpened = false; } else { this.IsBackstageOpened = false; } } this.IsUiPartEnabled = true; }