Export custom properties

Export custom properties in the Bold Reports^® UWP Report Viewer control the export behavior at the report level, such as Excel performance, PDF conformance, document encryption, and document protection.

How do I improve Excel export performance?

To improve Excel export performance in the Report Viewer, set the DisableExcelCellFormat custom property, which ignores the rendering of report item styles. It allows property value from anyone of the following values.

• Style - Disables rendering of the cell styles like padding, background, color, and text style.
• Border - Disables rendering of the cell border.
• All - Disables rendering of the cell border, padding, background, color, and text style.

Set the property value as All to improve maximum excel export performance.

You can set the DisableExcelCellFormat custom property,

The DisableExcelCellFormat property must be added to report properties.

How do I improve Excel export readability?

To improve Excel export readability in the Report Viewer, set the ExcelLayoutOption custom property value as IgnoreCellMerge, which eliminates the tiny columns, rows, and merged cells. You can set the property value,

The ExcelLayoutOption property must be added to report properties.

How do I set the PDF conformance level?

To set the PDF conformance level in the Report Viewer, use the PdfConformanceLevel custom property, which sets the PDF document version.

You can set anyone of the following PDF conformance option.

• Pdf_A1B - You can create a Pdf_A1B document by specifying the conformance level as Pdf_A1B through PdfConformanceLevel Enum when creating the new PDF document.
• Pdf_A2B - You can create a Pdf_A2B document by specifying the conformance level as Pdf_A2B through PdfConformanceLevel Enum when creating the new PDF document.
• Pdf_A3B - The PDF_A3B conformance supports the external files as attachment to the PDF document, so you can attach any document format such as Excel, Word, HTML, CAD, or XML files.
• Pdf_A1A - This conformance includes all Pdf_A1B requirements in addition to the features intended to improve a document’s accessibility. PDF/A-1a conformance additionally have crucial properties of Tagged PDF.
• Pdf_A2A - This conformance includes all PDF_A2B requirements in addition to the features intended to improve a document’s accessibility. PDF/A-2a conformance additionally have crucial properties of Tagged PDF.
• Pdf_A2U - This conformance includes all Pdf_A2U requirements, and additionally Unicode mapping for all text in the document.
• Pdf_X1A2001 - You can create a PDF/X-1a document by specifying the conformance level as Pdf_X1A2001 through PdfConformanceLevel Enum when creating the new PDF document.

You can set the PdfConformanceLevel custom property,

How do I export PDF documents with complex script?

To export PDF documents with complex script language texts from the Report Viewer, set the EnableComplexScript custom property. You can set the property value,

How do I encrypt exported documents with a password?

To encrypt exported documents with a password in the Report Viewer, set the DocumentOpenPassword custom property. The property protects exported documents such as PDF, Word, and Excel from unauthorized users. You can set the property value,

Open the PDF document to see the following output.

How do I protect a Word document from editing?

To protect a Word document from editing in the Report Viewer, set the WordProtectionType custom property. The property restricts editing either with a password or without a password, using the following types of protection.

• AllowOnlyComments- You can add or modify only the comments in the Word document.
• AllowOnlyFormFields- You can modify the form field values in the Word document.
• AllowOnlyRevisions- You can accept or reject the revisions in the Word document.
• AllowOnlyReading- You can only view the content in the Word document.
• NoProtection- You can access or edit the Word document contents as normally.

You can set the WordProtectionType custom property,

How do I set an Excel document edit password?

To allow only specific users to modify the workbook data and save changes in an Excel document exported from the Report Viewer, set the DocumentEditPassword custom property. You can set the property value,

Open the Excel document to see the following output.

How do I protect an Excel worksheet?

To protect an Excel worksheet in the Report Viewer, set the ExcelProtectionType custom property. The property protects the worksheet either with a password or without a password, using the following types of protection.

• None - Represents no protection in excel sheet.
• Objects - allows to protect shapes in excel sheet.
• Scenarios - allows to protect scenarios.
• FormattingCells - allows the user to format any cell on a protected worksheet.
• FormattingColumns - allows the user to format any column on a protected worksheet.
• FormattingRows - allows the user to format any rows on a protected worksheet.
• InsertingColumns - allows the user to insert columns on the protected worksheet.
• InsertingRows - allows the user to insert rows on the protected worksheet.
• InsertingHyperlinks - allows the user to insert hyperlinks on the worksheet.
• DeletingColumns - allows the user to delete columns on the protected worksheet, where every cell in the column to be deleted is unlocked.
• DeletingRows - allows the user to delete rows on the protected worksheet, where every cell in the row to be deleted is unlocked.
• LockedCells - allows to protect locked cells.
• Sorting - allows the user to sort on the protected worksheet.
• Filtering - allows the user to set filters on the protected worksheet. Users can change filter criteria but can not enable or disable an auto filter.
• UsingPivotTables - allows the user to use pivot table reports on the protected worksheet.
• UnLockedCells - allows to protect the user interface, but not macros.
• Content - allows to protect the contents in the excel sheet.
• All - allows to protect all type of protection.

You can set the ExcelProtectionType custom property,