Spreadsheet Paste Options dialog box
this dialog box to paste cells from a Microsoft Excel spreadsheet
into a form, or use the spreadsheet as the basis to create a new
To display this dialog box, select Edit > Paste. The Spreadsheet
Paste Options dialog box is displayed only when you paste the content
from an Excel spreadsheet into a form.
- Paste cells as a table
- Creates a table object in the form with the same dimensions,
number of cells, and data content as the selection in the spreadsheet. Designer
also preserves some of the original formatting of the spreadsheet
cells, including the text, fonts, colors, background colors, alignment,
and borders. If the selected cells in the spreadsheet contain column
headers, Designer maintains the column header formatting in a header
row at the top of the table.
- Paste cells as input fields
- Creates one text field object for each column in the spreadsheet.
Text field objects are positioned in the form from left to right
and wrapped onto additional lines if needed. The caption and binding
name of each text field object corresponds to the column header
text in the spreadsheet.