Origin 8.5.1 worksheet

From OriginLab Wiki

(Difference between revisions)
Jump to: navigation, search
Revision as of 07:30, 28 January 2011 (edit)
Penn (Talk | contribs)
(Stack Columns and Unstack Columns Improvements)
← Previous diff
Revision as of 07:59, 28 January 2011 (edit) (undo)
Deanna (Talk | contribs)

Next diff →
Line 1: Line 1:
[[Category:Origin 8.5.1]] [[Category:Origin 8.5.1]]
- +==Improvement on Column Label Rows==
-==Worksheet 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'''+
Improvements for meta data support: Improvements for meta data support:
Line 15: Line 10:
:[[Image:851beta2wks.png]] :[[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'''
 +
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. 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.

Revision as of 07:59, 28 January 2011


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


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