<!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>Usage Notes</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">Usage Notes</div>
      <hr noshade="true">
      <div class="title_division">Installation Note</div>
      <p class="para_division">The normal installation of NX includes a specialized version of the Xess spreadsheet called xessu, for Xess NX. You can start the NX version of Xess only from a NX session; it cannot be started from the command line.</p>
      <p class="para_division">The installation involves the following three main files:</p>
      <table cellspacing="3" width="50%" align="center">
         <tr>
            <th bgcolor="#c0c0c0" colspan="1" rowspan="1" valign="top">
               <p class="para_th">File</p>
            </th>
            <th bgcolor="#c0c0c0" 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">xessu</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td">Main program</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td">Xessu4</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td">Resource file</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td">xessu4-hel p.html</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td">Help file</p>
            </td>
         </tr>
      </table><br><div class="title_division">Differences between Excel and Xess</div>
      <p class="para_division">Both Xess and Microsoft Excel functions are exactly the same in conjunction with NX except for the following operations:</p>
      <ul>
         <li>
            <p class="para_item">In Xess, a function name is preceded by the &quot;@&quot; character, but this is not true in Excel. For example, to use the absolute value function in Xess, you would type &quot;=@ABS(5.3)&quot;, but in Excel you would type &quot;=ABS(5.3)&quot;. </p>
         </li>
         <li>
            <p class="para_item">For arrays or functions that take up more than one cell in the spreadsheet, the input for Excel is different than for Xess. In Xess you simply select the first cell, type in the function, and hit enter, but for Excel you must first select all of the cells that the function will fill, type in the function, and then hit Ctrl-Shift-Enter to evaluate the function. </p>
         </li>
         <li>
            <p class="para_item">When specifying a range for a function, Excel uses a colon ( : ) where Xess uses two periods ( .. ). </p>
         </li>
         <li>
            <p class="para_item">Graphs created in Excel by NX are opened as a sheet in a workbook, whereas in Xess it would open as its own window. Different sheets in a workbook can be displayed by selecting the tabs at the bottom of the screen. When you create a new graph, that sheet will automatically be displayed. </p>
         </li>
         <li>
            <p class="para_item">Microsoft Excel does not distinguish between uppercase and lowercase characters in names. For example, if you have created the name Sales and then create another name called SALES in the same workbook, the second name will replace the first one. </p>
         </li>
      </ul>
      <div class="title_division">Spreadsheet Pop-Up Menu</div>
      <p class="para_division">You can open the Spreadsheet Pop-Up menu anytime you are in the spreadsheet by clicking MB3. The Spreadsheet Pop-Up menu provides quick access to many of the cell functions found under the Edit and Format pull-down menus.</p>
      <div class="title_division">Using Spreadsheet Views - Xess Only</div>
      <p class="para_division">Use additional spreadsheet views to access more data from spreadsheets. The functions for spreadsheet views are under the spreadsheet View pull-down menu.</p>
      <p class="para_division">A spreadsheet view is an additional spreadsheet window that you can use to look at another region of the spreadsheet. Use View&rarr;New Views to add another spreadsheet window, and then use the scroll bars to position the additional view. Working in a view is the same as working in the main spreadsheet window. If nothing else, using multiple views reduces the amount of time spent scrolling around the spreadsheet to get to the data you want to see.</p>
      <p class="para_division">The size, position, and orientation of additional spreadsheet views are saved with the spreadsheet data in the NX part file, and are restored when the spreadsheet is brought up from NX. </p>
      <div class="title_division">Spreadsheet Limitations</div>
      <p class="para_division">Excel does not support use of the 'Automatic Save' add-in in an embedded spreadsheet. If you are using Excel 97 with this feature, NX will not be able to open an Excel spreadhseet. If you are using Excel 2000, NX can open the spreadsheet, but disables the 'Automatic Save' add-in.</p>
      <div class="title_division">Excel Versions</div>
      <table align="center">
         <tr>
            <th colspan="1" rowspan="1">
               <p class="para_th">UG Version</p>
            </th>
            <th colspan="1" rowspan="1">
               <p class="para_th">Excel Version</p>
            </th>
         </tr>
         <tr>
            <td colspan="1" rowspan="1">
               <p class="para_td">UG V18.0.1.1 and BELOW</p>
            </td>
            <td colspan="1" rowspan="1">
               <p class="para_td">You must have Excel 1997 or Excel 2000 installed.</p>
            </td>
         </tr>
         <tr>
            <td colspan="1" rowspan="1">
               <p class="para_td">V18.0.1.2 and higher</p>
            </td>
            <td colspan="1" rowspan="1">
               <p class="para_td">Excel 97, Excel 2000 and Excel XP are supported.</p>
            </td>
         </tr>
      </table><br></body>
</html>