Copy and paste behavior in spreadsheet views and tables

Claris Studio allows you to work with many different types of fields in spreadsheet views and tables, however the copy and paste behavior is different depending on the source field and the target field.

For example, signature fields can not be copied from or pasted to for security.

Below is the list of fields, their copy and paste compatibility, and any special behavior.

Field	Copy	Paste	Behavior
Short text	✅	✅	Literal value
Long text	✅	✅	Literal value
Rich text	✅	✅	Copies and pastes as Markdown.
Comments	❌	❌	N/A
Number	✅	✅	Pasting Must be a number or Claris Studio will attempt to convert it to a number.
Drop-down	✅	✅	Pasting Must be a value of an item in the value list. For example: "Option A"
Person	✅	✅	Pasting Must be the full name of a valid user. For example: "Johnny Appleseed."
Checkboxes	✅	✅	Copying JSON representation of values. For example: ["Option A", "Option B", "Option C"] Pasting For pasting into this field, must be a properly formatted array with values found in the checkbox set. For pasting from this field, for example into a text field, value will be converted to plain text. For example: "Option A", "Option B", "Option C"
Ranking	✅	✅
Single choice	✅	✅	Pasting Must be a value of an item in the value list. For example: "Option A"
Date	✅	✅	Pasting Must be correctly formatted, otherwise value will be ignored. For example: "7/11/2025"
Time	✅	✅	Pasting Must be correctly formatted, otherwise value will be ignored. For example: "11:00 AM"
Timestamp	✅	✅	Pasting Must be correctly formatted, otherwise value will be ignored. For example: "7/11/2025 11:00 AM"
Phone	✅	✅
Email	✅	✅
Signature	❌	❌	N/A
Currency	✅	✅	Pasting Must be a number or Claris Studio will attempt to convert it to a number.
Calculation	✅	❌
Container	❌	❌	N/A
Link	❌	❌	N/A
Address	✅	✅