Origin 8.5.1 worksheet

From OriginLab Wiki

Jump to: navigation, search


Back to main page...

[edit] Column Label Rows

  • The context menu in column label rows allows users to easily add, insert, and rename user-defined parameters.

Back to main page...

[edit] Microsoft Excel-like Features

Origin worksheets are enabled with Excel-style columns, rows, and dividers.

Drag separators to create dividers
  • Grab and move horizontal and/or vertical dividers from the lower-right corner of the worksheet.
Worksheet with dividers
  • Select a column and right-click, and then select Hide/Unhide Columns from the context menu to hide or show the column. Hidden columns are indicated by thicker gridlines in the column headers. Double-click the thicker gridlines to unhide a single column, or select the surrounding columns and use the Hide/Unhide Columns command to show the hidden columns. Rows can be hidden or shown in a similar manner.
  • Column and row headers feature Excel-style shading.

Back to main page...

[edit] Stack Columns and Unstack Columns

[edit] Unstack Columns

  • Refer to the Hint tab for helpful guidance when using the Stack Columns or Unstack Columns dialog box.
  • Use the Select Columns from Worksheet command to select multiple columns in the Stack Columns or Unstack Columns dialog box.
  • Specify where to put grouping information in your output by selecting Long Name, Comments, Append to Data Column's Long Name, or User Defined Parameters from the Put Grouping Info. to menu in the Unstack Columns dialog box.
  • Sort output columns by Group Variables or by Data to be Unstacked. This is useful when unstacking multiple data columns.
The example below demonstrates the result of selecting Data to be Unstacked from the Sort Output Columns By menu in the Unstack Columns dialog box. Note that all Ticket Rate columns have been grouped together in the output.
This image shows the result selecting Group Variables from the Sort Output Columns By menu in the Unstack Columns dialog box:

[edit] Stack Columns Tool

The Stack Columns tool is available from the Worksheet menu.

  • Specify multiple group identifiers. Each group is sorted into its own column in the output.
  • Stack by Rows. With this option selected, data will be stacked by alternating rows rather than columns.

Back to main page...

[edit] Pivot Table Dialog Box

  • Add extra columns and rows using the Pivot Settings dialog box.
  • Combine small values in columns or rows into a single column or row.
  • Sort output by row totals in the pivot table.
In the example below, there is no data for Month 1 (January), but the user wants to have January listed in the pivot table. Under Options, the user has entered 1 in the Row Source Extra Values field. The user has also chosen to ignore smaller data by expanding Combine Smaller Values, and selecting Column for Combine Direction, and By Percent of Grand Total for Mode. The user has entered 10 for Percent and set the Column Label to Others, and the user has chosen to calculate Totals by Row and to sort the output Ascending by Row Totals.


Here is the resulting pivot table:


Back to main page...

[edit] Set Values Using LabTalk

  • Define a LabTalk function in the Before Formula Scripts box to set column values.
In the example below, a LabTalk function has been defined to change fractions to doubles. This function is then called to transform the fractions in column A into the values in column B.

Back to main page...