private void btnGridLines_Click(object sender, EventArgs e)
{
ExcelFile xls = flexCelImgExport1.Workbook;
if (xls == null)
{
return;
}
if (cbAllSheets.Checked)
{
int SaveActiveSheet = xls.ActiveSheet;
for (int sheet = 1; sheet <= xls.SheetCount; sheet++)
{
xls.ActiveSheet = sheet;
xls.PrintGridLines = btnGridLines.Checked;
}
xls.ActiveSheet = SaveActiveSheet;
}
else
{
xls.PrintGridLines = btnGridLines.Checked;
}
MainPreview.InvalidatePreview();
}
internal void LoadFile(string FileName)
{
openFileDialog.FileName = FileName;
lbSheets.Items.Clear();
XlsFile xls = new XlsFile();
xls.HeadingColWidth = -1;
xls.HeadingRowHeight = -1;
xls.Protection.OnPassword += new OnPasswordEventHandler(GetPassword);
xls.Open(FileName);
for (int i = 1; i <= xls.SheetCount; i++)
{
lbSheets.Items.Add(xls.GetSheetName(i));
}
lbSheets.SelectedIndex = xls.ActiveSheet - 1;
flexCelImgExport1.Workbook = xls;
MainPreview.InvalidatePreview();
Text = "Custom Preview: " + openFileDialog.FileName;
//btnHeadings.Checked = flexCelImgExport1.Workbook.PrintHeadings;
//btnGridLines.Checked = flexCelImgExport1.Workbook.PrintGridLines;
btnFirst.Enabled = true; btnPrev.Enabled = true; btnNext.Enabled = true; btnLast.Enabled = true; edPage.Enabled = true;
btnZoomIn.Enabled = true; edZoom.Enabled = true; btnZoomOut.Enabled = true;
btnGridLines.Enabled = true; btnHeadings.Enabled = true; btnRecalc.Enabled = true; btnPdf.Enabled = true;
}
private void BodyAction(object sender)
{
try
{
flagIsOver = false;
MFFrame pFrame = (MFFrame)sender;
MFFrame clonedFrame;
pFrame.MFClone(out clonedFrame, eMFrameClone.eMFC_Video, eMFCC.eMFCC_ARGB32);
M_AV_PROPS avProps;
int audiosamples;
clonedFrame.MFAVPropsGet(out avProps, out audiosamples);
int cbPicture;
long pbPicture;
clonedFrame.MFVideoGetBytes(out cbPicture, out pbPicture);
int nRowBytes = avProps.vidProps.nRowBytes;
IntPtr ptr = new IntPtr(pbPicture);
Image bSource = new Bitmap(avProps.vidProps.nWidth, Math.Abs(avProps.vidProps.nHeight), nRowBytes,
PixelFormat.Format32bppRgb, ptr);
this.Invoke(new Action(() => MainPreview.SetSource(bSource)));
Marshal.ReleaseComObject(clonedFrame);
m_nFrameCounter++;
if (m_nFrameCounter == 10)
{
GC.Collect();
m_nFrameCounter = 0;
}
flagIsOver = true;
}
catch
{
flagIsOver = true;
}
}
private void btnRecalc_Click(object sender, System.EventArgs e)
{
if (flexCelImgExport1.Workbook == null)
{
MessageBox.Show("Please open a file before recalculating.");
return;
}
flexCelImgExport1.Workbook.Recalc(true);
MainPreview.InvalidatePreview();
}
private void cbAllSheets_CheckedChanged(object sender, System.EventArgs e)
{
lbSheets.Visible = !cbAllSheets.Checked;
sheetSplitter.Visible = lbSheets.Visible;
flexCelImgExport1.AllVisibleSheets = cbAllSheets.Checked;
if (flexCelImgExport1.Workbook == null)
{
return;
}
MainPreview.InvalidatePreview();
}
private void lbSheets_SelectedIndexChanged(object sender, System.EventArgs e)
{
if (flexCelImgExport1.Workbook == null)
{
return;
}
if (lbSheets.Items.Count > flexCelImgExport1.Workbook.SheetCount)
{
return;
}
flexCelImgExport1.Workbook.ActiveSheet = lbSheets.SelectedIndex + 1;
MainPreview.InvalidatePreview();
}
void ctrlPreview_ItemDragged(object sender, EventArgs e)
{
MainPreview.eMode = eMode.eM_Default;
MainPreview.SetCurcsor(Cursors.Arrow);
try
{
ItemDragEventArgs args = (ItemDragEventArgs)e;
AddDefaultItem(args.ItemType, new Point(args.Location.X, args.Location.Y));
}
catch
{
}
}
private void ctrlLeftButtonDown_Click(object sender, EventArgs e)
{
if (ListBoxTools.SelectedItem != null && MainPreview.eMode == eMode.eM_Add)
{
try
{
PreviewClickArgs args = (PreviewClickArgs)e;
var lbi = ListBoxTools.SelectedItem;
string tbCurrent = lbi.ToString();
string strType = tbCurrent;
AddDefaultItem(strType, args.CGPoint);
MainPreview.eMode = eMode.eM_Default;
MainPreview.SetCurcsor(Cursors.Arrow);
}
catch
{
}
}
}
private void MainForm_ResizeEnd(object sender, EventArgs e)
{
MainPreview.EnableRepaint();
}
private void MainForm_ResizeBegin(object sender, EventArgs e)
{
MainPreview.DisableRepaint();
}
