public void RefreshFpSpread(SheetView Sheet) { if (Sheet != null) { activeSheet = Sheet; myCell = GetParent(Sheet); activeSheet.CellChanged += new SheetViewEventHandler(activeSheet_CellChanged); activeSheet.CellChanged += new SheetViewEventHandler(activeSheet_CellChanged); myCell.EditModeOff -= new EventHandler(myCell_EditModeOff); myCell.EditModeOff += new EventHandler(myCell_EditModeOff); } }
public ChartControl2(SheetView sheet) { InitializeComponent(); if (sheet != null) { activeSheet = sheet; myCell = GetParent(sheet); activeSheet.CellChanged += new SheetViewEventHandler(activeSheet_CellChanged); activeSheet.CellChanged += new SheetViewEventHandler(activeSheet_CellChanged); myCell.EditModeOff -= new EventHandler(myCell_EditModeOff); myCell.EditModeOff += new EventHandler(myCell_EditModeOff); } }
public new void PrintSheet(int SheetIndex) { if (SheetIndex >= 0 && SheetIndex < Sheets.Count) { SheetView sheetView = Sheets[SheetIndex]; MyCell Spread = new MyCell(); if (sheetView != null && sheetView.Tag != null) { if (Watermark != null) { if (this.Watermark.SheetID == new Guid(sheetView.Tag.ToString())) { Spread.Watermark = this.Watermark; sheetView.PrintInfo.Opacity = Watermark.Opacity; } } } Spread.Sheets.Add(sheetView); OwnerPrintDocument Document = new OwnerPrintDocument(Spread); Document.PrintInfo = sheetView.PrintInfo; if (Sheets[SheetIndex].PrintInfo.Preview) { PrintPreviewDialog Dialog = new PrintPreviewDialog(); Dialog.WindowState = FormWindowState.Maximized; Dialog.PrintPreviewControl.Zoom = 1.0; Dialog.Document = Document; Dialog.UseAntiAlias = true; Dialog.ShowDialog(); } else { Document.Print(); } } else if (SheetIndex == -1) { PrintDialog Dialog = new PrintDialog(); Dialog.AllowSomePages = true; Dialog.PrinterSettings.PrintRange = System.Drawing.Printing.PrintRange.SomePages; Dialog.PrinterSettings.FromPage = 1; Dialog.PrinterSettings.ToPage = 1; Dialog.UseEXDialog = true; if (DialogResult.OK == Dialog.ShowDialog()) { foreach (SheetView Sheet in Sheets) { FpSpread Spread = new MyCell(); Spread.Sheets.Add(Sheet); OwnerPrintDocument Document = new OwnerPrintDocument(Spread); Document.ShowPrinterDialog = false; Document.PrinterSettings = Dialog.PrinterSettings; Document.PrintInfo = Sheet.PrintInfo; Document.Print(); } } } }