Office File API & Office-Inspired Desktop UI Controls – Tips & Tricks (May 2020)

Here is this month’s edition of our tips & tricks for our Office File API and Office-inspired UI controls. We hope you find these support tickets interesting and of business value. Should you have any questions, feel free to comment below.

Tips & Tricks

• Word Processing: How to delete unused styles from a document (T868486)
• Word Processing: How to sequentially insert several tables and avoid table merge operations (T873232)
• Word Processing: How to replace section breaks with page breaks in a document (T885997)
• Word Processing: How to replace document fields with plain text (T874183)
• Word Processing: How to set Bullet Position and Text Position for list items in code (T875588)
• PDF Document API: How to find hyperlinks and bookmarks in a PDF document (T879342)
• PDF Document API: How to draw wrapped text in a PDF document (T874068)
• PDF Document API: How to place a visual signature over a text box (T873771)
• Spreadsheet Document API: How to change the column type detected by the CreateDataTable method (T885076)
• Spreadsheet Document API: How to set a date and time format in a cell based upon a predefined language (T875941)
• WinForms Rich Text Editor: How to use the Rich Text Editor to build an email client (T875808)
• WPF PDF Viewer: How to find a form field in a PDF document and scroll to this field in the PDF Viewer control (T873858)
• WinForms & WPF Spreadsheet: How to import an RTF string in a worksheet cell (T869104)
• WinForms & WPF Spreadsheet: How to drag and drop data from the Grid control to the Spreadsheet control (T716699)
• WinForms & WPF Spreadsheet: How to programmatically close the Spreadsheet comment editor (T884521)
• WinForms & WPF Spreadsheet: How to insert a picture into a cell based on a custom parameter (T875844)
• WinForms & WPF Spreadsheet: How to reverse the order of a chart’s vertical axis (T876649)
• WinForms & WPF Spreadsheet: How to save and reapply a conditional formatting rule (T870509)

Enhancements

• Word Processing: Mark a custom style as a primary style (T879522)
• PDF Document API: Determine the number of characters drawn by the DrawString method (T868856)
• PDF Document API: Merge multiple PDF/A documents into a single document (T878504)
• PDF Document API: Apply a date and time format to form field values (T874694)

  Please refer to the following documentation article for more information on how to apply formats to form field values: How to: Specify the Format of a Form Field Value.

• Spreadsheet: Turn off formula calculation in a Workbook or Spreadsheet control without changing document calculation mode (T869585)

If you’ve come across an interesting support ticket you’d like to share with the rest of the DevExpress developer community, please comment below and include the link. Thank you for your continued support.

Free DevExpress Products - Get Your Copy Today