4.6 Simple Manipulation of Worksheet Datasets

There are a couple of simple methods for filling a worksheet column with numbers. The simplest is to use a menu command to fill a column with either row index numbers, uniform random numbers or normal random numbers.

A second, more powerful method allows you to generate the dataset by defining a column formula. These column formulae may reference other columns of values and may incorporate Origin's built-in math and statistical functions, as well as user-defined LabTalk and Origin C functions.

Topics covered in this section:
  • The Workbook Script Panel
  • Data Reduction
  • Reduce Columns
  • Reduce Duplicated Rows
  • Reduce Rows
  • Transposing Worksheets
  • Generating Simple Worksheet Datasets
  • Using Formulae to Set or Transform Worksheet Column Values
  • Using a Formula to Set Cell Values
  • Named Range
    		•
    English | Deutsch | 日本語