<!DOCTYPE html
  PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<!--
Copyright (c) 2006 UGS Corp.

All Rights Reserved.

This software and related documentation are proprietary to UGS Corp.
-->
<html>
   <head>
      <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
      <title>Spreadsheet Menu Options</title>
      <script language="javaScript">
        abridged="false";
        displayConditions=new Array();
      </script>
      <link type="text/css" href="../css/main_styles.css" rel="stylesheet">
   </head>
   <body class="bodydocs" onload="top.pageLoader()" bgcolor="#FFFFFF">
      <div class="title_topic3" id="xps10_pagetitle">Spreadsheet Menu Options</div>
      <hr noshade="true">
      <p class="para_topic">While the Gateway spreadsheet is active, you will see additional menu items on the spreadsheet pull-down menus. These functions are:</p>
      <table cellspacing="3" align="center">
         <tr>
            <th bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_th">Option</p>
            </th>
            <th bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_th">Description</p>
            </th>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td">Tools&rarr;Save Part</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td">Save the NX work part.</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td">Tools&rarr;Save Part As</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td">Save the NX work part under a new name.</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td">File&rarr;Save</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td">Save the spreadsheet data in the work part.</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td">File&rarr;Open</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td">Load the spreadsheet data from the work part.</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td">Connections&rarr;Disconnect</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td">Return control to NX.</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td">View&rarr;Refresh</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td">Refresh the NX graphics window.</p>
            </td>
         </tr>
      </table><br><p class="para_topic">In addition to the normal built-in functions, the spreadsheet adds some additional functions that more tightly integrate the spreadsheet with NX.</p>
      <p class="para_topic">An example of a spreadsheet built-in function might be the function, @SUM(c1,c2). The @SUM function adds the values in the cells specified by c1 and c2, and loads the current cell with the results of that calculation. You would find this sort of function in virtually any spreadsheet. In the same manner, the spreadsheet supports special built-in functions that work with NX data and parts.</p>
      <p class="para_topic">An example of an NX built-in function in the spreadsheet environment is @UGEXPR(&quot;P1&quot;). This function fetches the value of an expression in NX specified by name, which in this case is the string, P1. The built-in functions provided by NX for the spreadsheet environment allow you to relate spreadsheet calculations directly to objects or other part information, as well as perform specialized mathematical functions.</p>
      <table border="0">
         <tr>
            <td valign="top" align="left"><img align="left" src="../graphics/note.gif" alt="Note" title="Note"></td>
            <td valign="bottom" align="left" width="100%">
               <div class="para_note">
                  <p class="para_note_body">  There are some differences in the way you specify functions for Xess and Excel. For more information, see the section  <a class="links" href="javascript:void(0)" onclick="top.openFile('shared_func/tls_spd_ov_usagenotes_r.html');return(false);">Differences between Excel and Xess</a>.
                  </p>
               </div>
            </td>
         </tr>
      </table>
   </body>
</html>