Worksheet (ORG-6133)
Sparkline Improvements (ORG-7319)
Histogram and Box chart as Sparkline (ORG-8263)
Log10 X and Y support (ORG-7319)
Choose Column:Add or Update Sparklines...
Add Graph as Sheet (ORG-8797)
Right click sheet tab and choose Add Graph as Sheet... from the context menu. Creates a new sheet and adds one graph to a single worksheet cell.
Double click on the embedded graph to open an editable graph window. Note that th editable graph window has an arrow-like button in the upper right corner (in place of the usual Windows "delete" button). To exit the editable window and preserve customizations, click this arrow button. This closes the editable window and pushes updates back to the embedded graph.
Right click and choose Restore Window to delete the embedded graph and break the link to the original graph window.
Generate Patterned Data (ORG-7792)
Fill Column with patterened/random numbers, patterened/random date/time values, patterened or random set of strings.
Set Column Value Improvements (ORG-9021)
Formula column label row (ORG-6669)
User can right click workbook title and choose View: Formula to turn the formula on.Then type formula directly using the same syntax as used in Set Column Values dialog. E.g. col(B)-col(A), sin(col(A)), i*2, etc.
User can also open Set Column Values as before to set formula. The formula label row will update.
User can also uncheck Options: Direct Edit Formula Cell, and then choose Options: Formula Text... to type in some explanation of the formula, in cases like formula is complicated, etc.
Support subrange notation in Formula (ORG-9044)
E.g. enter StdDev(col(A)\[i-5:i+5]) in Formula to do running statistics
More built-in Functions added – todo (ORG-8781 ORG-7697 ORG-8945)
Different moving average functions are added under F(X): Statistics: menu.
E. g. Exponential Moving Average, Modified Moving Average, Triangular Moving Average, Weighted Moving Average
Keep Text option (ORG-8555)
In the past, if there are text in some data rows of a column, Set column value will change them into missing values.
Set Multiple Column Values (ORG-8554)
Select Multiple contiguous columns and choose Set Multiple Column Values context menu.
Use wcol(j) or cell(i,j) to refer to selected columns, e.g.
Example 1: Set Column B, C and D to be log10 of their original values.
Example 2: Set Whole Sheet2 to be all Values in Sheet1 times 10.
Reduce Columns (ORG-8538)
Choose Worksheet: Reduce Columns... menu.
We also added reduce by merged values option in Reduce Rows dialog.
Sort Column by Values in Column Label Rows - (ORG-8340)
You can sort worksheet columns by information in column label rows. From the main menu, choose Worksheet: Sort Columns by Label...
Column Filter Improvements (ORG-6064)
Copy Column To and Save Filter Info. in Operation (ORG-6078)
Sometimes user may want to change filter conditions and want to plot the graphs for each filter conditions. User can use Copy Columns To context menu to copy the columns to elsewhere and save the filter condition within the copied data. Then plot graph from it.
Then if user changes original worksheet's filter conditions, it will not affect the copied data and its graph.
Row index i support in condition (ORG-7975)
Stack/Unstack/Pivot Table Improvements (ORG-3656)
More Copy Column options (ORG-7937)
Select a column and right-click >
- Copy (Formula): Copy Set Column Value settings
- Copy (Label Rows): Copy Column Rows
- Copy (Formula and Label Rows): Copy both Set Column Value Settings and Label Rows
Analysis
Copy/Paste Operation(ORG-7944)
This is not supported for all analyses, but it can be very useful to copy operation and then paste to all curves in another graph, etc.
Fitting Improvements
LR/PR: Support showing parameter values in equation (ORG-5119)
Custom X Column Data for fitted curve (ORG-7459)
Fitting Function Builder: Easy way to edit parameters (ORG-8380)
Surface Fit: Add fitted surface to source graph (ORG-8434)
Partial Least Squares Regression (ORG-5412)
Global Fit Speed Improvements (ORG-8883)
Compare Models/Dataset Improvements (ORG-8445)
BIC in Compare Model (ORG-6495)
Friendly naming of models (ORG-8460)
Fit and Rank all functions in a category (ORG-8257)
Set Numeric Settings for Report (ORG-8413)
Global setting of Digits in Report on Numeric Format tab of Tools:Options dialog box.
Adjust Footnote Size (ORG-8515)
If user feels Footnote size is too small in report sheet, there is global Footnote Size Ratio on Miscellaneous tab of Tools:Options dialog.
User may need to Refresh result sheet to see the change.
Akima Spline Interpolation (ORG-3238)
Input/Output Data tooltip (ORG-7799)
Easier for user to read Input Data info. without expanding Input Data node.
Useful to see where data will be output too as well.
Gadget (ORG-6642)
New Output to All Curves/All Layers (ORG-8188)
After determining region of interest and customizing settings, choose New Output for All Curves or New Output for All Layers to do the analysis on all curves and output the result.
Hotkey O for New Output action (ORG-8185)
Pressing O with a gadget active is equal to clicking the gadget's menu button (the small arrow in the upper right corner of the gadget) and choosing New Output.
Indicate Scatter Points in ROI in Cluster Gadget (ORG-8432)
Smart Labeling of Peaks in Quick Peak Gadget (ORG-8681)
Output gadget results to a tree variable (ORG-8124)
Importing (ORG-6948)
Import Mat File Structure (ORG-8462)
Choose File: Import: MatFile(MAT)... to import all variables in MAT file into a worksheet.
Click each variable in the worksheet to import the variable into a new worksheet of the same workbook.
Excel Import Improvements
More options in File: Import Excel dialog (ORG-8827)
Replace Existing Data option is added in 1st File Import Mode
Exclude Empty Sheets checkbox is added.
Reimport of Excel File (ORG-8826)
If user has modified the excel file in Origin, can use File: Reimport Directly to reimport the xls file.
Or if outside xls file has been changed, user can choose File: Reimport Directly to reimport the xls.
ASCII Import Improvements
Save import settings to <sheet> automatically (ORG-7725)
This way, if user saves template(OTW), or analysis template (OGW, OPJ), the import setting is saved as well.
Transpose in Import (ORG-8551)
Skip Columns in Import ASCII and Import Wizard (ORG-8706)
Here is the picture in Import wizard.
It's also supported in Import ASCII dialog. Partial Import node.
Set repetitive column designations in Import Wizard (ORG-8539)
With the following XY2Z designation, the imported columns will be XYZZXYZZ......
File: menu change: Moved Recent Import and Re-Import related Menus below Import menu
Statistics
Outlier tests (ORG-7936)
Grubbs Test and Dixon's Q-Test are added to Statistics: Descriptive Statistics menu.
More Power and Sample Size Test (ORG-7711, ORG-7712, ORG-7707, ORG-7706, ) – not all done yet
One-Proportion Test
Two-Proportion Test
One-Variance Test
Two Variance Test
Proportion Testing in Hypothesis Testing (ORG-7709 ORG-7710) – not all done yet
One-Sample Proportion Testing
Two-Sample Proportion Testing
t-Test on Rows
General Improvements
Arrange graph of same type in one graph in applicable statistics
More statistics quantities for Pair sample t test
Signal Processing
Two methods Lowess and Loess in smooth X-Function (ORG-6564)
Like matlab, SigmaPlot and Igor
An option Span Proportion should be available instead of Points of Window for it.
Interface
Smart Hint and Smart Hint Logs
In addition to the familiar Reminder popups, we have added a fading Smart Hint in places where the user may need some hint. If the user doesn't click on the hint, it will fade away.
E.g. we don't support smoothing on multiple Y datasets, but after doing smoothing on one dataset, there is faded hint to tell the user how to repeat analysis on all Y data.
There is also a Smart Hint Log window below the Messages Log where you can read smart hints displayed during the current session. You can also right click to search the hint in the Smart Hint Log window.
