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