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();
}
}
}
}
