Origin 8.5.1 worksheet
From OriginLab Wiki
(Difference between revisions)
|Revision as of 20:51, 29 March 2011 (edit)
Acampbell (Talk | contribs)
(→Microsoft Excel-like Features)
← Previous diff
|Current revision (02:57, 7 April 2011) (edit) (undo)
Deanna (Talk | contribs)
(→No scientific conversion if Display is set to 1,000)
|Line 86:||Line 86:|
|[[:Category:Origin_8.5.1|Back to main page...]]||[[:Category:Origin_8.5.1|Back to main page...]]|
|== No scientific conversion if Display is set to 1,000 ==||== No scientific conversion if Display is set to 1,000 ==|
|When column '''Display''' is set to '''Decimal:1,000''', Origin ignores the '''Upper Threshold Power''' setting so that data does not appear in scientific form (for example, 1234567 appears as 1,234,567 and is not converted to 1.23457E6).||When column '''Display''' is set to '''Decimal:1,000''', Origin ignores the '''Upper Threshold Power''' setting so that data does not appear in scientific form (for example, 1234567 appears as 1,234,567 and is not converted to 1.23457E6).|
 Column Label Rows
- The context menu in column label rows allows users to easily add, insert, and rename user-defined parameters.
 Microsoft Excel-like Features
Origin worksheets are enabled with Excel-style columns, rows, and dividers.
- Grab and move horizontal and/or vertical dividers from the lower-right corner of the worksheet.
- 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.
 Stack Columns and Unstack Columns
 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:
 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.
 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:
 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.