DevExpress Office File API 23.1

DevExpress Drawing Graphics Library

• The DevExpress.Drawing Graphics Library was first introduced in November 2022 as a Community Technology Preview (CTP). This update marks its official release. The following drawing library-related capabilities and features are now available in non-Microsoft Windows environments:
  • Shapes in Word Processing and Spreadsheet Document API.
  • PDF Graphics API.
  • Treemap and Sunburst Visualizations in Word Processing and Spreadsheet Document API.
  • Export to Bitmap and Image Extraction in PDF Document API.
  • Improved Barcode Export in Barcode Generation API.
• Replaced all System.Drawing enumerations in the public API with cross-platform counterparts.

Microsoft .NET MAUI Support (Apple macOS, Apple iOS, Android)

• You can now leverage the capabilities of the Office File API products within your .NET MAUI apps:
  • Create and edit Microsoft Excel, Microsoft Word, PDF Documents.
  • Generate barcodes.
  • Convert documents (DOCX to PDF, PDF to image, etc.).
  • Merge documents (DOCX, PDF).
  • Digitally sign Word, Excel, and PDF documents.

Microsoft Excel Spreadsheet API

• Threaded Comments - You can now manage threaded comments. Use the Worksheet.ThreadedComments property to add, edit, reply, and remove threaded comments from Excel documents.
• Chart Enhancements - The Excel Spreadsheet API now prints and exports (PDF) spreadsheet documents with the following chart elements:
  • Legends with Custom Fonts (specified by the Legend.Font property).
  • Chart Markers with Solid Outlines.
  • Trendlines.
  • Data Tables.
• Use Cell Values as Data Labels in Charts - You can now use cell values as data labels for a chart. Use the CustomDataLabels.SetReference method to specify a cell range used as a reference. You can print and export to PDF documents that contain charts with custom data labels.

Word Processing Document API

• Embedded Fonts - Added a new API that allows you to embed fonts in Microsoft Word documents. Once fonts are embedded in a document, the document's appearance remains unchanged when viewed, printed or exported on any computer (regardless of the presence of the font on the target machine).
• Rotated Text In Tables - Added support for rotated text in table cells. Use the TableCell.TextDirection property to specify text orientation. You can also print and export to PDF documents with rotated text in tables.