Column Formula Label Row
You can now directly click into any cell in the new Fx row to add or modify column formula
Set Multiple Column Values
Origin 9.1 allow user to set value of multiple selected columns or columns of whole worksheet, using wcol(j) or cell(i,j) to refer to the columns
Generate Patterned Data
Origin 9.1 enable user to fill column with
- Patterned/random numbers
- Patterned/random date/time values
- Patterned or random set of strings.
Sort Column by Values in Column Label Rows
In Origin 9.1, You can sort worksheet columns by information in column label rows
Reduce Columns
The reduce columns tool allows user to remove the unwanted columns, which may be introduced by the imported files, by deleting-skipping columns
Copy & Paste Formula, Label Rows
We introduce more copy column options in Origin 9.1, which allow user to copy formula or column column rows to other selected columns in the same worksheet or other worksheets.
Sparkline Improvements
Origin 9.1 supports adding sparkline as histogram or box chart, and we also have options for supporting log X/Y scales for sparkline graphs.
