Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Collapse]WinForms Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Build an Application
 [Collapse]Controls and Libraries
  [Expand]Forms and User Controls
  [Expand]Messages, Notifications and Dialogs
  [Expand]Editors and Simple Controls
  [Expand]Ribbon, Bars and Menu
  [Expand]Application UI Manager
  [Expand]Docking Library
  [Expand]Data Grid
  [Expand]Vertical Grid
  [Expand]Pivot Grid
  [Expand]Tree List
  [Expand]Chart Control
  [Expand]Diagrams
  [Expand]Gauges
  [Expand]Map Control
  [Expand]Scheduler
  [Collapse]Spreadsheet
   [Expand]Product Information
    Product Structure
    Getting Started
   [Expand]Spreadsheet Document
    Supported Formats
   [Expand]Cell Basics
   [Expand]Spreadsheet Formulas
    Defined Names
    Data Binding
    Data Validation
   [Expand]Data Presentation
    Data Grouping
   [Expand]Pivot Table Overview
   [Expand]Charting Overview
    Printing
    Events
   [Collapse]Mail Merge Overview
     Mail Merge Ribbon Tab
     Mail Merge Design View
     Field List Panel
     Parameters Panel
     Data Source Wizard
     Mail Merge Functions
     Template Document
    Protection
    Find and Replace
   [Expand]Visual Elements
    Services
   [Expand]Shortcuts
   [Expand]Examples
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]Printing-Exporting
  [Expand]PDF Viewer
   Reporting
  [Expand]Snap
  [Expand]TreeMap Control
 [Expand]Common Features
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Mail Merge Design View

SpreadsheetControl supports a specific mode for displaying worksheets intended for preparing mail merge templates - Mail Merge Design View. This view is switched off by default, but we recommend that you activate it before creating or modifying a template (click the Mail Merge Design View button on the Mail Merge Ribbon page). When this view is active in the SpreadsheetControl, the following features take effect.

  • Template ranges (Detail, DetailLevel, Header and Footer) are highlighted in a worksheet. You can resize and move these ranges visually by dragging them.

  • If a mail merge field (a FIELD or PICTUREFIELD function) is used in a cell formula as one of its elements, the entire formula is displayed in the cell, even if the ShowFormulas option is switched off.

    Note

    In the Mail Merge Design View, formula validation does not work – invalid formulas are displayed in cells instead of being replaced with the corresponding error codes when the ShowFormulas option is disabled.

  • Cells with mail merge fields are marked with database icons (, ).

How would you rate this topic?​​​​​​​