Origin 8.5.1 worksheet

From OriginLab Wiki

(Difference between revisions)
Jump to: navigation, search
Revision as of 06:49, 30 January 2011 (edit)
Snowli (Talk | contribs)
(Set Values Related LabTalk Improvements)
← Previous diff
Revision as of 07:23, 30 January 2011 (edit) (undo)
Deanna (Talk | contribs)
(Pivot Table Dialog Improvements)
Next diff →
Line 53: Line 53:
== Pivot Table Dialog Improvements == == Pivot Table Dialog Improvements ==
More options are added in Pivot Table dialog. More options are added in Pivot Table dialog.
-* Support adding extra columns and rows with specified stings in Pivot Table.+* Support adding extra columns and rows with specified settings in Pivot Table.
-* Support Combine small values in column or row to one column or rows. +* Support combining small values in column or row to one column or rows.
* Numbers will be sorted in Source Column and Row in Pivot Table * Numbers will be sorted in Source Column and Row in Pivot Table
- 
==Set Values Related LabTalk Improvements== ==Set Values Related LabTalk Improvements==

Revision as of 07:23, 30 January 2011


Contents

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

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.

Stack Columns and Unstack Columns Improvements

Here are changes in Unstack Columns Dialog.

Image:UnstackColumns.png
  1. Add Hint tab in Unstack Columns dialog.
  2. Support 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

Here are changes in Stack Columns Dialog.

  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

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.
  • Numbers will be sorted in Source Column and Row in Pivot Table

Set Values Related LabTalk Improvements

Support to define LabTalk function in the Before Formula Scripts box.

Below image shows how to change the fractions in col(A) to numeric by defining LabTalk function in Before Formula Scripts.

Image:SetValuesDialog.png