private void LoadSheetConfig()
{
ExcelFile Xls = flexCelPrintDocument1.Workbook;
chGridLines.Checked = Xls.PrintGridLines;
chHeadings.Checked = Xls.PrintHeadings;
chFormulaText.Checked = Xls.ShowFormulaText;
chPrintLeft.Checked = (Xls.PrintOptions & TPrintOptions.LeftToRight) != 0;
edHeader.Text = Xls.PageHeader;
edFooter.Text = Xls.PageFooter;
chFitIn.Checked = Xls.PrintToFit;
edHPages.Text = Xls.PrintNumberOfHorizontalPages.ToString();
edVPages.Text = Xls.PrintNumberOfVerticalPages.ToString();
edVPages.ReadOnly = !chFitIn.Checked;
edHPages.ReadOnly = !chFitIn.Checked;
edZoom.ReadOnly = chFitIn.Checked;
edZoom.Text = Xls.PrintScale.ToString();
TXlsMargins m = Xls.GetPrintMargins();
edl.Text = m.Left.ToString();
edt.Text = m.Top.ToString();
edr.Text = m.Right.ToString();
edb.Text = m.Bottom.ToString();
edf.Text = m.Footer.ToString();
edh.Text = m.Header.ToString();
Landscape.Checked = (Xls.PrintOptions & TPrintOptions.Orientation) == 0;
}
private void LoadSheetConfig()
{
ExcelFile Xls = flexCelPdfExport1.Workbook;
chGridLines.Checked = Xls.PrintGridLines;
chFormulaText.Checked = Xls.ShowFormulaText;
chPrintLeft.Checked = (Xls.PrintOptions & TPrintOptions.LeftToRight) != 0;
edHeader.Text = Xls.PageHeader;
edFooter.Text = Xls.PageFooter;
chFitIn.Checked = Xls.PrintToFit;
edHPages.Text = Xls.PrintNumberOfHorizontalPages.ToString();
edVPages.Text = Xls.PrintNumberOfVerticalPages.ToString();
edVPages.ReadOnly = !chFitIn.Checked;
edHPages.ReadOnly = !chFitIn.Checked;
edZoom.ReadOnly = chFitIn.Checked;
edZoom.Text = Xls.PrintScale.ToString();
TXlsMargins m = Xls.GetPrintMargins();
edl.Text = m.Left.ToString();
edt.Text = m.Top.ToString();
edr.Text = m.Right.ToString();
edb.Text = m.Bottom.ToString();
edf.Text = m.Footer.ToString();
edh.Text = m.Header.ToString();
chLandscape.Checked = Xls.PrintLandscape;
edAuthor.Text = Convert.ToString(Xls.DocumentProperties.GetStandardProperty(TPropertyId.Author));
edTitle.Text = Convert.ToString(Xls.DocumentProperties.GetStandardProperty(TPropertyId.Title));
edSubject.Text = Convert.ToString(Xls.DocumentProperties.GetStandardProperty(TPropertyId.Subject));
}
private bool LoadPreferences()
{
//NOTE: THERE SHOULD BE *A LOT* MORE VALIDATION OF VALUES ON THIS METHOD. (For example, validate that margins are between bounds)
// As this is a simple demo, they are not included.
try
{
flexCelPrintDocument1.AllVisibleSheets = cbAllSheets.Checked;
flexCelPrintDocument1.ResetPageNumberOnEachSheet = cbResetPageNumber.Checked;
flexCelPrintDocument1.AntiAliasedText = chAntiAlias.Checked;
ExcelFile Xls = flexCelPrintDocument1.Workbook;
Xls.PrintGridLines = chGridLines.Checked;
Xls.PrintHeadings = chHeadings.Checked;
Xls.PageHeader = edHeader.Text;
Xls.PageFooter = edFooter.Text;
Xls.ShowFormulaText = chFormulaText.Checked;
if (chFitIn.Checked)
{
Xls.PrintToFit = true;
Xls.PrintNumberOfHorizontalPages = Convert.ToInt32(edHPages.Text);
Xls.PrintNumberOfVerticalPages = Convert.ToInt32(edVPages.Text);
}
else
{
Xls.PrintToFit = false;
}
if (chPrintLeft.Checked)
{
Xls.PrintOptions |= TPrintOptions.LeftToRight;
}
else
{
Xls.PrintOptions &= ~TPrintOptions.LeftToRight;
}
try
{
Xls.PrintScale = Convert.ToInt32(edZoom.Text);
}
catch
{
MessageBox.Show("Invalid Zoom");
return(false);
}
TXlsMargins m = new TXlsMargins();
m.Left = Convert.ToDouble(edl.Text);
m.Top = Convert.ToDouble(edt.Text);
m.Right = Convert.ToDouble(edr.Text);
m.Bottom = Convert.ToDouble(edb.Text);
m.Footer = Convert.ToDouble(edf.Text);
m.Header = Convert.ToDouble(edh.Text);
Xls.SetPrintMargins(m);
flexCelPrintDocument1.PrintRangeLeft = Convert.ToInt32(edLeft.Text);
flexCelPrintDocument1.PrintRangeTop = Convert.ToInt32(edTop.Text);
flexCelPrintDocument1.PrintRangeRight = Convert.ToInt32(edRight.Text);
flexCelPrintDocument1.PrintRangeBottom = Convert.ToInt32(edBottom.Text);
flexCelPrintDocument1.DocumentName = flexCelPrintDocument1.Workbook.ActiveFileName + " - Sheet " + flexCelPrintDocument1.Workbook.ActiveSheetByName;
flexCelPrintDocument1.DefaultPageSettings.Landscape = Landscape.Checked;
}
catch (Exception e)
{
MessageBox.Show("Error: " + e.Message);
return(false);
}
return(true);
}
private bool LoadPreferences()
{
//NOTE: THERE SHOULD BE *A LOT* MORE VALIDATION OF VALUES ON THIS METHOD. (For example, validate that margins are between bounds)
// As this is a simple demo, they are not included.
try
{
ExcelFile Xls = flexCelPdfExport1.Workbook;
Xls.PrintGridLines = chGridLines.Checked;
Xls.PageHeader = edHeader.Text;
Xls.PageFooter = edFooter.Text;
Xls.ShowFormulaText = chFormulaText.Checked;
if (chFitIn.Checked)
{
Xls.PrintToFit = true;
Xls.PrintNumberOfHorizontalPages = Convert.ToInt32(edHPages.Text);
Xls.PrintNumberOfVerticalPages = Convert.ToInt32(edVPages.Text);
}
else
{
Xls.PrintToFit = false;
}
if (chPrintLeft.Checked)
{
Xls.PrintOptions |= TPrintOptions.LeftToRight;
}
else
{
Xls.PrintOptions &= ~TPrintOptions.LeftToRight;
}
try
{
Xls.PrintScale = Convert.ToInt32(edZoom.Text);
}
catch
{
MessageBox.Show("Invalid Zoom");
return(false);
}
TXlsMargins m = new TXlsMargins();
m.Left = Convert.ToDouble(edl.Text);
m.Top = Convert.ToDouble(edt.Text);
m.Right = Convert.ToDouble(edr.Text);
m.Bottom = Convert.ToDouble(edb.Text);
m.Footer = Convert.ToDouble(edf.Text);
m.Header = Convert.ToDouble(edh.Text);
Xls.SetPrintMargins(m);
flexCelPdfExport1.PrintRangeLeft = Convert.ToInt32(edLeft.Text);
flexCelPdfExport1.PrintRangeTop = Convert.ToInt32(edTop.Text);
flexCelPdfExport1.PrintRangeRight = Convert.ToInt32(edRight.Text);
flexCelPdfExport1.PrintRangeBottom = Convert.ToInt32(edBottom.Text);
if (chEmbed.Checked)
{
flexCelPdfExport1.FontEmbed = TFontEmbed.Embed;
}
else
{
flexCelPdfExport1.FontEmbed = TFontEmbed.None;
}
if (chSubset.Checked)
{
flexCelPdfExport1.FontSubset = TFontSubset.Subset;
}
else
{
flexCelPdfExport1.FontSubset = TFontSubset.DontSubset;
}
flexCelPdfExport1.Kerning = cbKerning.Checked;
switch (cbFontMapping.SelectedIndex)
{
case 0: flexCelPdfExport1.FontMapping = TFontMapping.ReplaceAllFonts; break;
case 1: flexCelPdfExport1.FontMapping = TFontMapping.ReplaceStandardFonts; break;
case 2: flexCelPdfExport1.FontMapping = TFontMapping.DontReplaceFonts; break;
}
switch (cbPdfType.SelectedIndex)
{
case 0:
flexCelPdfExport1.PdfType = TPdfType.Standard;
break;
case 1:
flexCelPdfExport1.PdfType = TPdfType.PDFA1;
break;
case 2:
flexCelPdfExport1.PdfType = TPdfType.PDFA2;
break;
case 3:
flexCelPdfExport1.PdfType = TPdfType.PDFA3;
break;
}
switch (cbTagged.SelectedIndex)
{
case 0: flexCelPdfExport1.TagMode = TTagMode.Full; break;
case 1: flexCelPdfExport1.TagMode = TTagMode.None; break;
}
switch (cbVersion.SelectedIndex)
{
case 0: flexCelPdfExport1.PdfVersion = TPdfVersion.v14; break;
case 1: flexCelPdfExport1.PdfVersion = TPdfVersion.v16; break;
}
flexCelPdfExport1.Properties.Author = edAuthor.Text;
flexCelPdfExport1.Properties.Title = edTitle.Text;
flexCelPdfExport1.Properties.Subject = edSubject.Text;
flexCelPdfExport1.Properties.Language = edLang.Text;
Xls.PrintLandscape = chLandscape.Checked;
}
catch (Exception e)
{
MessageBox.Show("Error: " + e.Message);
return(false);
}
return(true);
}
