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>
+{{ReleaseBar}}
-==Copying and Pasting==
+;
-You can use the standard '''Copy''' and '''Paste''' commands to perform the following operations:<br />
+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.
-===Copying a Diagram===
+== Copy and Paste tabular data ==
-'''To Copy an Influence Diagram, Including the Objects Represented by the Nodes'''
-# Select the group of nodes you wish to copy.
+===Copy cell(s) from an Analytica Result or Edit table===
-# 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 />
+# 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 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>
+===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 <code>K</code>, or <code>M</code>.
-'''To Copy an Entire Influence Diagram Window'''
+=== 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.
-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 />
+{{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.}}
-===Copying an Edit Table or Result Table===
+== Copy and Paste Diagrams and Graphs ==
-'''To Copy an Edit Table or Result Table'''
-# Open the window containing the table.
+===Copy Nodes from a Diagram===
-# Select cells and choose '''Copy''' from the '''Edit''' menu (Control+c).<br />
+# [[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''.
-''''To Copy All the Elements of a Table in Addition to the Index Elements'''
+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).
-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 />
+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.
-===Copying a Result Graph===
+===Copy an Entire Influence Diagram ===
-'''To Copy a Result Graph'''
-# Open the '''Result''' window containing the graph.
+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.
-# Select '''Copy''' from the '''Edit''' menu (''Control+c'') to copy an image representation of the graph to the clipboard.<br />
-===Pasting Data from a Spreadsheet===
+===Copy a Result Graph===
-'''To Paste Data from a Spreadsheet'''
-To paste tabular data from a spreadsheet into an Analytica table:<br />
+This is useful if you want to create a document or presentation using graphs from an Analytica model:
-# Select a group of cells in a spreadsheet.
+# Open a [[Result window]] showing the graph.
-# Select '''Copy''' from that program’s '''Edit''' menu (''Control+c'') to copy the data to the clipboard.
+# Select '''Copy''' from the [[Edit menu]] or ''Control+c''
-# Bring the Analytica model to the front and open the '''Edit Table''' window you want to paste the data into.
+# Click a location in the document of another application, such as Microsoft Word or Powerpoint.
-# Select a top-left cell or the same number of cells that you originally copied.
+# Select '''Paste''' from the [[Edit menu]] or press ''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>
+This pastes a picture of the graph into the document.
-===Pasting Data from Another Program===
+==Export Diagram or Graph to image file==
-'''To Paste Data from Another Program'''
-To paste data from a program other than a spreadsheet:<br />
+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.
-* Use tab characters to separate items, and return characters to separate lines.
+===Export Diagram as an Image File===
-* Use numbers in floating point or exponential format. You can use the suffixes that Analytica recognizes, including K, M, and m. Dollar signs ($) and commas (thousands separators) are not permitted.<br />
-===Exporting an Image File===
+# With the diagram showing, select '''Export''' from the [[File menu]].
-'''To Export an Influence Diagram to an Image File'''
+# From the '''Save''' dialog, select the desired format.
-# With the diagram showing, select '''Export''' from the '''File''' menu.
+It stores an image of the full diagram (not just the selected nodes).
-# 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 />
-===Exporting a Result Graph to an Image File===
+===Export a Result Graph as an Image File===
-'''To Export a Result Graph to 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 ==
-Character Suffixes<br />
+* [[Analytica User FAQs/Application Integration]]
-[[Using_the_Import_and_Export_Commands#Default_and_XML_Model_File_Formats|Default and XML Model File Formats]]<br />
+* [[Model file formats]]
+* [[Excel to Analytica Translation]]
+* [[Diagram window]]
-<footer>Importing, Exporting, and OLE Linking Data / {{PAGENAME}} / Using OLE linking</footer>
+<footer>Integration with data and applications / {{PAGENAME}} / Read and write text files</footer>