DevExpress Office File API 24.2

Released: Dec 12, 2024

24.2 での更新項目

機能

Important Changes

  • GDI+ (Libgdiplus) - End of Support for Non Windows-based systems
    • Because of The commitment to Microsoft .NET 8 and following the release of The cross-platform SkiaSharp-based engine last year, DevExpress refactored The source code and removed all GDI+ related method calls for non-Windows environments (libgdiplus).
  • Support Skia for Windows Environments and Deprecation of the AzureCompatibility Property
    • Multiple DevExpress products (Reporting, BI Dashboard, and Office File API) ship with printing and data export functionality for restricted environments such as Microsoft Azure (where certain GDI/GDI+ calls related to metafiles and font objects are unavailable). The AzureCompatibility.Enabled property manages this functionality.
    • In the v23.2 release cycle, DevExpress ended support for capabilities offered by this property toggle for non-Windows environments. With v24.2, DevExpress phased out the AzureCompatibility.Enabled toggle for Office File API libraries in Windows-based environments as well. DevExpress recommend use of The Skia-based Cross-Platform Graphics Engine when targeting cloud/restricted environments.
    • DevExpress Office File API libraries automatically determine the applicable drawing engine used. You can switch to a different drawing engine manually by using the static DevExpress.Drawing.Settings.DrawingEngine option.
  • Resolve Missing Fonts
    • DevExpress added a new DXFontRepository.QueryNotFoundFont event for fonts used within a document but missing in an application’s hosting environment. This feature allows you to identify and resolve missing fonts by adding them to DXFontRepository before document generation.

Spreadsheet Document API

  • Dynamic Array Formulas
    • DevExpress have extended The formula calculation engine and integrated dynamic arrays into The Spreadsheet Document API library. Unlike standard array formulas, which return a single value for each cell with a formula, dynamic array functions return a dynamic array of values (this array of values automatically spills into neighboring cells).
    • You can now import Excel documents containing dynamic array formulas in the Spreadsheet Document API library, call the Workbook.Calculate method to recalculate these formulas, and save the document calculated with values to Excel formats. Printing and export to PDF are also available.
  • Embed Images in Cells
    • The DevExpress Spreadsheet Document API library (v24.2) allows you to embed images directly into worksheet cells (using Microsoft Excel's "Place in Cell" option). You can import documents with images embedded in worksheet cells, print these documents, export them to the PDF and save them to a supported Excel file (without the content loss).
    • v24.2 includes new APIs designed to manage cell embedded images in code. Embedded images are stored as cell values. To determine if a cell has an embedded image, use the CellValue.IsCellImage property. Use the CellValue.ImageValue property to obtain the cell image value as a OfficeImage object (allows you to check the image format or obtain image bytes). To insert an image in a cell, assign it to the CellRange.Value property.
    • Additionally, DevExpress implemented options to specify image Alt Text (a meaningful description) values and mark the cell image as decorative. These settings are available via the Cell.ImageInfo property.
  • Justify & Distributed Vertical Text Alignment
    • v24.2 adds support for Justify and Distributed vertical alignment types within Spreadsheet cells. Excel files with these alignment options can be printed and exported to PDF.

PDF Document API

  • ZuGFeRD v2.3.2 Support
    • The DevExpress PDF File API (part of the Office File API Suite) fully supports Germany’s ZuGFeRD e-invoicing standard (ZuGFeRD v2.3.2).
  • Signature Validation Enhancements
    • v24.2 ships with enhanced PDF Signature Validation APIs. New capabilities include:
      • API to verify certificate revocation based on Online Certificate Status Protocol (OCSP) responses.
      • API to verify certificate revocation based on Certificate Revocation List (CRL).
      • API to validate Long Term Validation (LTV) signatures.
      • API to validate Document Level Timestamps.
  • Export PDF Documents to SVG
    • DevExpress implemented a PdfDocumentProcessor.CreateSvgImage method designed to convert individual PDF pages to SVG images.
  • Image Extraction API
    • To improve user experiences when extracting PDF content and analyzing document structure, DevExpress introduced PdfDocumentProcessor.GetImagesInfo method overloads for the PDF Document API library. With The new APIs, you can obtain additional information about PDF page images and determine image size and location on a page.

Word Processing Document API

  • SmallCaps Formatting
    • The Word Processing Document API library now supports Small Caps character formatting. Word documents with Small Caps formatting can be previewed, printed, and exported to PDF.
  • Page Borders
    • The DevExpress Word Processing Document API library now supports page borders. Word documents with page borders can be saved without content loss, printed, and exported to PDF.
  • Paragraph Borders API
    • v24.2 includes new APIs designed to manage Word document paragraph borders in code. You can now add borders to document paragraphs, change border style, color, and thickness for each border type (Top, Left, Right, Bottom or Horizontal) individually, or remove border formatting as needed. Additionally, you can manage paragraph border settings for paragraph styles and list levels in numbered lists.
  • Alt Text for Tables
    • Table.Title and Table.Description properties allow you to specify alternative, text-based representations of information contained in a Word document table.
  • Macros API
    • DevExpress implemented a Document.VbaProject property to programmatically retrieve a VBA project stored in a macro-enabled Word file. Use the VbaProject.Modules collection to obtain information about VBA project modules (the number of modules, their names and binary data) or remove a specific module from the project.

Barcode Generation API

  • New Aztec Barcode
    • You can now generate an Aztec code when using The Barcode Generation library. Aztec barcodes offer a compact/efficient way to encode large amounts of data without requiring a quiet zone, which makes them ideal for space-constrained documents.
  • New Micro QR Code
    • You can now create Micro QR Codes (a smaller alternative to traditional QR Codes). Micro QR Codes are suitable for space-limited documents, where only small amounts of data (35 characters or 128 bits) require encoding.