<!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>Active Range</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_topic4" id="xps10_pagetitle">Active Range</div>
      <hr noshade="true">
      <p class="para_topic"> The spreadsheet Active Range is a named range in the spreadsheet that defines the area that contains the active block of NX expression data. It includes  <em>both</em> the expression names and the corresponding formulas (either values or expressions). The first column or row contains the expression names. Immediately to the right (column-wise) or below (row-wise), the cells contain corresponding expressions or constants. Whenever you elect to update the part, the Active Range definition and, optionally, the cell cursor position determine what data is sent to NX. 
      </p>
      <p class="para_topic"> To define the Active Range use one of the following methods.</p>
      <ul>
         <li>
            <p class="para_item"> If you extracted the names and expressions using a function in Tools&rarr;Extract Expr, then the Modeling Spreadsheet automatically defines the active range. If you do not modify the list (other than modifying expressions), no further action is required, or</p>
         </li>
         <li>
            <p class="para_item"> If you used an alternate input method, or you modified the extracted lists, you must explicitly set the expression active range as follows:</p>
            <ol type="1" start="1">
               <li>
                  <p class="para_item"> Select (highlight) the scope of the expression Active Range - names and expressions.</p>
               </li>
               <li>
                  <p class="para_item"> Select Edit&rarr;Define Expr Rng.</p>
               </li>
            </ol>
         </li>
      </ul>
      <p class="para_topic"> For example in the Column-wise Data Layout Example, A2..B4 contains the expression names and expressions you need. Highlight A2..B4, then select Edit&rarr;Define Expr Rng.</p>
      <p class="para_topic"> If you want the Active Range to be saved, you must save the spreadsheet with File&rarr;Save from the spreadsheet menu.</p>
      <p class="para_topic"> You can confirm the definition of the active range. The following sections explain how for each spreadsheet application.</p>
      <div class="title_division">Xess</div>
      <p class="para_division"> Select Edit&rarr;Named Range from the Xess spreadsheet menu. The named range, UG_ACTIVE_RNG, refers to the Active Range. Do not directly define UG_ACTIVE_RNG using the Edit&rarr;Named Range, spreadsheet menu option.</p>
      <div class="title_division">Excel</div>
      <p class="para_division"> Select Insert&rarr;Name&rarr;Define from the Excel spreadsheet menu. The name UG_ACTIVE_RNG, refers to the Active Range.</p>
      <p class="para_division"> Alternatively, you can select the Down Arrow on the right side of the Name Box. The Name box is below the New, Open, Save icons on the upper left corner of the spreadsheet. If a UG_ACTIVE_RANGE has been set, it will be listed and selecting it will highlight the cells. Do not define UG_ACTIVE_RNG directly using the Insert&rarr;Name&rarr;Define spreadsheet menu option.  </p>
      <div class="title_division">Redefining the Active Range</div>
      <p class="para_division"> Suppose you have extracted 200 expression names and formulas on the spreadsheet, and are only interested in 5 of them. You can:</p>
      <ol type="1" start="1">
         <li>
            <p class="para_item"> Delete the rest of them using Edit&rarr;Delete&rarr;Delete Row, or by using Edit&rarr;Move operations in the spreadsheet. Then redefine the Active Range to include only those 5 names and their formulas.</p>
         </li>
         <li>
            <p class="para_item"> You could move the names you are interested in to the beginning of the list and redefine the Active Range to only include the first 5 items.</p>
         </li>
      </ol>
      <p class="para_division"> Both approaches have the same effect on the spreadsheet. The difference is that in the second approach the data for the other expressions is available for future reference.  </p>
      <div class="title_division"></div>
   </body>
</html>