Difference between revisions of "Copy and Paste between applications"

Latest revision as of 04:24, 24 January 2019

Analytica User GuideIntegration with data and applicationsCopy and Paste between applications

Release:	4.6 • 5.0 • 5.1 • 5.2 • 5.3 • 5.4 • 6.0 • 6.1 • 6.2 • 6.3 • 6.4 • 6.5 • 6.6

You can use the standard Copy and Paste commands from the Edit menu or the equivalent keyboard shortcuts, Ctrl+v and Ctrl+c, in most situations you would expect.

Copy and Paste tabular data

Copy cell(s) from an Analytica Result or Edit table

Open the window containing the table.
Select a cell, or rectangular range of cells.
Select Copy from the Edit menu or press Control+c.
Select the top-left cell (or a cell-range of the same size as you copied) in the same or another table in Analytica or in another table-based application, such as Microsoft Excel.
Select Paste from the Edit menu or press Control+v.

Copy All the Elements of a Table in Addition to the Index Elements

If you want to copy an entire table, including row and column headers, and all slices if it has more than two dimension:

Select Copy Table from the Edit menu.

You can paste this into another table-based application, like Microsoft Excel.

Copy and Paste Data from a Spreadsheet into Analytica

This is almost the same as copying data within or between spreadsheets:

Select a group of cells in a spreadsheet.
Select Copy from that program’s Edit menu (Control+c) to copy the data to the clipboard.
Bring the Analytica model to the front and open the Edit Table window you want to paste the data into.
Select a top-left cell or the same number of cells that you originally copied.
Select Paste from the Edit menu (Control+v)

Tip

You may need to pivot the Analytica table first to make sure the rows and columns are arranged in the same way as the original table. When copying a row of data from a spreadsheet into a one-dimensional table, transpose the data first so that you are copying it as a column of cells, not a row of cells.

Paste Data from Another Application

To paste data from a program other than a spreadsheet:

Use tab characters to separate items, and return characters to separate lines.
It accepts numbers in most common formats, including exponential, currency symbols and commas separate thousands. You can use the suffixes that Analytica recognizes, including K, or M.

Quoted values

When pasting data into tables or fields within Analytica, quotations are sometimes added around content. The general rule for when quotations are added is this:

Quotes are added to content when the source of content is not a field that holds Analytica expressions, but the source expects an expression.

The rule has the effect that when you evaluate the target, the result has the same value as the source data. Some consequences of this rule are

When pasting from a Definition to a Definition, quotes are neither added nor removed.
When pasting from a Description (which is not an expression) to a Definition, quotes are added. The result of evaluating the variable is then the same as the Description text.
When pasting from an external text editor into a Definition, quotes are added.
When pasting from an external text editor into a Description field, quotes are not added.

You may encounter cases where you didn't want the quotes to be added for you. When this happens, select the table cells and select Remove quotes when possible from the right-mouse context menu.

Copy and Paste Diagrams and Graphs

Copy Nodes from a Diagram

Select a node or group of nodes from a Diagram (in Browse or Edit mode).
Select Copy from the Edit menu or press Control+c.
Click a location in the same or another Analytica Diagram or in another application, for example a Microsoft Word document, and Select Paste from the Edit menu or press Control+v.

If you paste the results into an Analytica diagram window (the original diagram or another), it creates new nodes into that diagram with their underlying variables or other objects. It adds a digit to each identifier to distinguish them from the original objects that you copied. It retains any influence relationships among the objects. If you past a module node, it copies all objects inside that module (and any submodules recursively).

If you paste copied nodes into another application, like Microsoft Word, Power Point, or Excel, it pastes a picture of the nodes and any influence arrows.

Copy an Entire Influence Diagram

With a Diagram window active, select Copy Diagram from the Edit menu. It copies the influence diagram as a picture but not the objects that the nodes represent.

Copy a Result Graph

This is useful if you want to create a document or presentation using graphs from an Analytica model:

Open a Result window showing the graph.
Select Copy from the Edit menu or Control+c
Click a location in the document of another application, such as Microsoft Word or Powerpoint.
Select Paste from the Edit menu or press Control+v.

This pastes a picture of the graph into the document.

Export Diagram or Graph to image file

For greater flexibility, you can use the Export' from the File menu to export a Diagram or Graph into an image file. In each case, it prompts you for the desired image format, including EMF, PNG, JPEG, BMP, and TIFF.

@@ Line 1: / Line 1: @@
 [[Category: Analytica User Guide]]
-<breadcrumbs> Analytica User Guide > Importing, Exporting, and OLE Linking Data > {{PAGENAME}}</breadcrumbs><br />
+<breadcrumbs> Analytica User Guide > Integration with data and applications > {{PAGENAME}}</breadcrumbs>
-You can use the standard Copy and Paste commands to perform the following operations:<br />
+{{ReleaseBar}}
-'''To Copy a Diagram, Including the Objects Represented by the Nodes'''
+;
+You can use the standard '''Copy''' and '''Paste''' commands from the  [[Edit menu]] or the equivalent keyboard shortcuts, Ctrl+v and Ctrl+c, in most situations you would expect.
-# Select the group of nodes you wish to copy.
+== Copy and Paste tabular data ==
-# Select Copy from the Edit menu (Control+c). The objects that the nodes represent, as well as a picture of the selected nodes with all of the relevant arrows between the selected nodes, are copied to the clipboard.
-<br />'''To Copy an Entire Influence Diagram Window'''
-Select Copy Diagram from the Edit menu. The entire influence diagram is copied as a picture representation without copying the objects that the nodes represent.<br />
+===Copy cell(s) from an Analytica Result or Edit table===
-'''To Copy an Edit Table or Result Table'''
+# Open the window containing the table.
+# Select a cell, or rectangular range of cells.
+# Select '''Copy''' from the [[Edit menu]] or press ''Control+c''.
+# Select the top-left cell (or a cell-range of the same size as you copied) in the same or another table in Analytica or in another table-based application, such as Microsoft Excel.
+# Select '''Paste''' from the [[Edit menu]] or press ''Control+v''.
-# Open the window containing the table.
+===Copy All the Elements of a Table in Addition to the Index Elements===
-# Select cells and choose Copy from the Edit menu (Control+c).
-<br />''''To Copy All the Elements of a Table in Addition to the Index Elements'''
+If you want to copy an entire table, including row and column headers, and all slices if it has more than two dimension:
-Select Copy Table from the Edit menu. The entire multidimensional array is copied as a graphic and as a list of two-dimensional tables in a special text format.<br />
+# Select '''Copy Table''' from the [[Edit menu]].
-'''To Copy a Result Graph'''
+You can paste this into another table-based application, like Microsoft Excel.
-# Open the Result window containing the graph.
+===Copy and Paste Data from a Spreadsheet into Analytica===
-# Select Copy from the Edit menu (Control+c) to copy an image representation of the graph to the clipboard.
-<br />'''To Paste Data from a Spreadsheet'''
-To paste tabular data from a spreadsheet into an Analytica table:<br />
+This is almost the same as copying data within or between spreadsheets:
 # Select a group of cells in a spreadsheet.
-# Select Copy from that program’s Edit menu (Control+c), to copy the data to the clipboard.
+# Select '''Copy''' from that program’s [[Edit menu]] (''Control+c'') to copy the data to the clipboard.
-# Bring the Analytica model to the front and open the Edit Table window you want to paste the data into.
+# Bring the Analytica model to the front and open the '''Edit Table''' window you want to paste the data into.
 # Select a top-left cell or the same number of cells that you originally copied.
-# Select Paste from the Edit menu (Control+v)
+# Select '''Paste''' from the [[Edit menu]] (''Control+v'')
-<tip title="Tip">When copying a row of data from a spreadsheet into a one-dimensional table, transpose the data first so that you are copying it as a column of cells, not a row of cells.</Tip>
+<tip title="Tip">You may need to pivot the Analytica table first to make sure the rows and columns are arranged in the same way as the original table.  When copying a row of data from a spreadsheet into a one-dimensional table, transpose the data first so that you are copying it as a column of cells, not a row of cells.</Tip>
-'''To Paste Data from Another Program'''
+===Paste Data from Another Application===
-To paste data from a program other than a spreadsheet:<br />
+To paste data from a program other than a spreadsheet:
 * Use tab characters to separate items, and return characters to separate lines.
-* Use numbers in floating point or exponential format. You can use the suffixes that Analytica recognizes (including K, M, and m; see character suffixes (page 140) for a comprehensive list). Dollar signs ($) and commas (thousands separators) are not permitted.<br />
+* It accepts numbers in most common formats, including exponential, currency symbols and commas separate thousands. You can use the suffixes that Analytica recognizes, including <code>K</code>, or <code>M</code>.
+=== Quoted values ===
+When pasting data into tables or fields within Analytica, quotations are sometimes added around content. The general rule for when quotations are added is this:
+* Quotes are added to content when the source of content is not a field that holds Analytica expressions, but the source expects an expression.
+The rule has the effect that when you evaluate the target, the result has the same value as the source data. Some consequences of this rule are
+* When pasting from a Definition to a Definition, quotes are neither added nor removed.
+* When pasting from a Description (which is not an expression) to a Definition, quotes are added. The result of evaluating the variable is then the same as the Description text.
+* When pasting from an external text editor into a Definition, quotes are added.
+* When pasting from an external text editor into a Description field, quotes are not added.
+{{Release|5.0||You may encounter cases where you didn't want the quotes to be added for you. When this happens, select the table cells and select '''Remove quotes when possible''' from the right-mouse context menu.}}
+== Copy and Paste Diagrams and Graphs ==
+===Copy Nodes from a Diagram===
+# [[Selecting nodes|Select a node or group of nodes]] from a Diagram (in Browse or Edit mode).
+# Select '''Copy''' from the [[Edit menu]] or press ''Control+c''.
+# Click a location in the same or another Analytica Diagram or in another application, for example a Microsoft Word document, and Select '''Paste''' from the [[Edit menu]] or press ''Control+v''.
+If you paste the results into an Analytica diagram window (the original diagram or another), it creates new nodes into that diagram with their underlying variables or other objects.  It adds a digit to each identifier to distinguish them from the original objects that you copied. It retains any influence relationships among the objects.  If you past a module node, it copies all objects inside that module (and any submodules recursively).
+If you paste copied nodes into another application, like Microsoft Word, Power Point, or Excel, it pastes a picture of the nodes and any influence arrows.
+===Copy an Entire Influence Diagram ===
+With a Diagram window active, select '''Copy Diagram''' from the [[Edit menu]]. It copies the influence diagram as a picture but not the objects that the nodes represent.
+===Copy a Result Graph===
+This is useful if you want to create a document or presentation using graphs from an Analytica model:
+# Open a [[Result window]] showing the graph.
+# Select '''Copy''' from the [[Edit menu]] or ''Control+c''
+# Click a location in the document of another application, such as Microsoft Word or Powerpoint.
+# Select '''Paste''' from the [[Edit menu]] or press ''Control+v''.
+This pastes a picture of the graph into the document.
+==Export Diagram or Graph to image file==
+For greater flexibility, you can use the ''Export''' from the [[File menu]] to export a Diagram or Graph into an image file. In each case, it prompts you for the desired image format, including EMF, PNG, JPEG, BMP, and TIFF.
-'''To Export An Influence Diagram to an Image File'''
+===Export Diagram as an Image File===
-# With the diagram showing, select Export from the File menu.
+# With the diagram showing, select '''Export''' from the [[File menu]].
-# From the Save dialog, select the desired format (e.g., EMF, PNG, JPEG). An image of the full diagram is stored (not just the selected nodes).<br />
+# From the '''Save''' dialog, select the desired format.
+It stores an image of the full diagram (not just the selected nodes).
-'''To Export a Result Graph to an Image File'''
+===Export a Result Graph as an Image File===
-# Open the Result window containing the graph.
+# Open the [[Result window]] containing the graph.
-# Select Export from the File menu and select the desired image file format (e.g., EMF, PNG, JPEG).
+# Select '''Export''' from the [[File menu]] and select the desired image file format.
 == See Also ==
-Default and XML Model File Formats<br />
+* [[Analytica User FAQs/Application Integration]]
+* [[Model file formats]]
+* [[Excel to Analytica Translation]]
+* [[Diagram window]]
-<footer>Importing, Exporting, and OLE Linking Data / {{PAGENAME}} / Next</footer>
+<footer>Integration with data and applications / {{PAGENAME}} / Read and write text files</footer>