DevExpress Office File API 21.1

PDF Document API

• ZUGFeRD-Compliant PDF - The DevExpress PDF Document API now allows you to attach ZUGFeRD XML (cross-industry data format for electronic invoice data exchange) to your PDF documents.
• Form Field API Enhancements - Extended the Form Field API so you can change the properties of available form field types, retrieve complex field items, and change associated display text.
• Digital Signature Appearance - The new API allows you to manage signature appearance. You can display additional information in a signature field (location, reason, signer name, etc.) alongside a signature image.
• Printing Enhancements - Improved the DirectX printing engine so that documents are printed faster, with a smaller print job size. For backward compatibility, use the PdfPrinterSettings.PrintTextAsOutlines option.
• XMP Metadata - You can now embed Extensible Metadata Platform (XMP) data in your PDF document. XMP is a standard format for metadata generation, processing, and interchange.

Spreadsheet Document API

• RC4 CryptoAPI Encryption - The Spreadsheet Document API and WinForms/WPF Spreadsheet controls can import and export RC4 CryptoAPI encrypted XLS files. RC4 CryptoAPI is now the default encryption method for binary files if you use the Strong encryption type to encrypt your documents.
• Progress Indication - Added an IProgress<T> parameter to the following asynchronous methods to implement progress notifications:
  • Workbook.LoadDocumentAsync.
  • Workbook.SaveDocumentAsync.
  • Workbook.ExportToPdfAsync.
  • Workbook.ExportToHtmlAsync.
• Document Themes API - You can now access and modify document theme in code. Load a custom theme from a THMX file or customize predefined theme colors as needed.
• Save Cell Ranges as Images - The new 'CellRange.ExportToImage' extension method allows you to export a cell range to an image and define export options (image resolution, scale percentage, enable black or white mode, etc.).
• Image Replacement - Use the new 'Picture.ChangeImage' method to replace an existing worksheet image with a different image. You can specify whether to retain the size of the original image or use new image attributes (size and proportions).
• Sunburst and Treemap Charts - You can now print and export (to PDF) Treemap and Sunburst charts.
• Accounting Number Format Alignment - Now supports Accounting number format alignment. If you apply this number format to cells and then print or export your document to PDF, the Spreadsheet Document API will render the currency symbol on the left and numbers on the right.

Word Processing Document API

• RC4 CryptoAPI Encryption - The Word Processing Document API and Rich Text Editors (for WinForms and WPF) can import and export RC4 CryptoAPI encrypted DOC files. RC4 CryptoAPI is now the default encryption method for binary files if you use the Strong encryption type to encrypt your documents.
• Repeat Row as Header - Enable the new TableRow.RepeatAsHeaderRow option to repeat a row as a header at the top of each page.
• Charts (CTP) - The Word Processing Document API and WinForms/WPF Rich Text Editors can now display, print, and export (to PDF) documents with charts. You can also use the Spreadsheet Chart API to create 2D/3D charts in code, apply chart styles, and format individual chart elements.
• Watermarks - The Word Processing Document API and WinForms/WPF Rich Text Editors allow you to import and export documents with watermarks. Watermarks are displayed, printed, and exported to PDF. New API allows you to insert picture and text watermarks, specify watermark options, or remove existing watermarks from a document.
• ActiveX Controls - The new API allows you to access ActiveX controls in code, obtain associated properties (type, name, and ProgID), and remove these controls from a document when necessary.