Origin 8.5.1 worksheet

From OriginLab Wiki

(Difference between revisions)
Jump to: navigation, search
Revision as of 16:48, 31 January 2011 (edit)
Easwar (Talk | contribs)
(Stack Columns)
← Previous diff
Revision as of 17:49, 31 January 2011 (edit) (undo)
Easwar (Talk | contribs)
(Set Values Related LabTalk Improvements)
Next diff →
Line 79: Line 79:
==Set Values Related LabTalk Improvements== ==Set Values Related LabTalk Improvements==
-Support to define LabTalk function in the Before Formula Scripts box. +It is now possible to define a LabTalk function in the Before Formula Scripts box, and use that function to set column values.
-Below image shows how to change the fractions in col(A) to numeric by defining LabTalk function in Before Formula Scripts.+The image below shows an LT function to change fractions to double being used to transform column A fractions to values in Col B.
:[[Image:SetValuesDialog.png]] :[[Image:SetValuesDialog.png]]
[[:Category:Origin_8.5.1|Back to main page...]] [[:Category:Origin_8.5.1|Back to main page...]]
- 
== No scentific conversion if Display is set to 1,000 == == No scentific conversion if Display is set to 1,000 ==

Revision as of 17:49, 31 January 2011


Contents

Back to main page...

Improvement on Column Label Rows

Improvements for meta data support:

  1. Improved Context menu in Column Label Rows to easily add, insert, and rename user defined parameters
  2. Added context menu to edit Column label rows
  3. Added Context menu to append to Long Name
Image:851beta2wks.png

Back to main page...

Excel-like Improvements

Origin worksheets are now enabled with Excel-style dividers. Grab and move horizontal and/or vertical dividers from the lower-right corner of the worksheet.

Image:WorksheetDividers.png
Worksheet with dividers

Hide/Unhide Columns context menu is added. User can highlight columns and choose Hide/Unhide Columns:Hide context menu to hide them. If there is hidden columns in worksheet, the gridlines for the column header will be thicker than other columns. User can either double click the thicker gridline to unhide one column at a time or highlight columns around the hidden columns and use the Hide/Unhide Columns: Unhide context menu to unhide columns.

Image:HideColumn.png

We used to bold the column and row headers of the selected cell or range in worksheet. In 8.5.1, the corresponding column and row headers are hilighted as in Excel to make the indication more obvious.

Image:Highlight.png

Some bugs related to WYSIWYG printing and exporting of worksheets have been fixed. Objects such as text labels and drawings placed in worksheet now appear in the right place when worksheet is exported or printed.

Back to main page...

Stack Columns and Unstack Columns Improvements

Improvements to Unstack Columns

The following improvements have been made to the dialog:

Image:UnstackColumns.png
  1. Added Hint tab
  2. Supports Select Columns from Worksheet for Group Columns node.
  3. More Options of where to Put Grouping Info. to. In the past, grouping info. can only be put to User-defined parameters, now it can be put to Long Name, Comments, or combine with Data column's long name to make new long name.
  4. Sort Output Columns by Group Variables or Data to be unstacked. This is for the case of there are multiple columns to be unstacked. E.g. user unstacks two data columns. Ticket Rate and Accident Rate.

The image below is when choosing Sort Output Columns by Data to be unstacked. All Ticket Rate columns are put together in output.

Image:Unstack_datatogether.png

The image below is when choosing Unstack Columns by Group Variables.

Image:Unstack_Grouptogether.png

New Stack Columns Tool

A new Stack Columns tool has been added under Worksheet menu. Here are some key features of this tool:

  1. Support specifying multiple Group Identifiers. Each group will be one column in output.
  2. Support Stack by Rows. With this selected, one row of data will be stacked first and then another row.
  3. Support Stack into subgroups. This isn't done yet. We want to use Group Identifier to divide into sub groups.
Image:Wstackcol_dialog.png

Back to main page...

Pivot Table Dialog Improvements

More options are added in Pivot Table dialog.

  • Support adding extra columns and rows with specified settings in Pivot Table.
  • Support combining small values in column or row to one column or rows.
  • Support sorting output by Row Totals in Pivot Table

E.g. There is no data for January. but user may still want to have Month 1 listed in Pivot table. He can enter 1 in Options: Row Source Extra Values edit box. User may also want to ignore smaller data. E.g. combine smaller columns which is less than 10% of grand total as one column named Others. See settings in Combine Smaller Column Source Values node. User can also calculate Row Totals and sort the "Row Total" column ascendingly. Here is the settings in the dialog.

Image:PivotTableDB.png

Here is the Pivot Table created.

Image:PivotTable.png


Back to main page...

Set Values Related LabTalk Improvements

It is now possible to define a LabTalk function in the Before Formula Scripts box, and use that function to set column values.

The image below shows an LT function to change fractions to double being used to transform column A fractions to values in Col B.

Image:SetValuesDialog.png

Back to main page...

No scentific conversion if Display is set to 1,000

In the past, if user sets Display of Column as Decimal: 1,000 and then enters 1234567, he is expecting to see 1,234,567, but the data displays as 1.23457E6. This is because of the upper threshold is set to 6 in Tools: Options: Numeric Format tab. User can set the upper threshold higher to avoid the scientific conversion. But if he gives such opj to someone else who's upper threshold is stil 6, the conversion will happen again.

In 8.5.1, if user set Display of Column as 1,000, Origin will ignore the upper threshold setting so the data will always display as 1,234,567. Note: This only applies to upper threshold.