Flash Fill support detect percentage value
More separators are supported in Flash Fill
Excel like leading quote to treat cell content as Text
Allow Keep Excel Formula in German version
Always update reference range when paste Excel formula
New mini toolbar button for adding Data Filter to column(s)
Add Menu “Show Select Filter dialog” under Data menu to specify it shows Select Filter for drag and drop import when there is only one matching filter.
Allow user to save custom formula when add user-defined label row
Support automatic periodically refresh of imported data
This will help Excel users when copying Excel formula into Origin
Check Import Raw Formula checkbox in Excel Connector
Keep Cell Formula/Link checkbox in Clear Worksheet dialog
Improved Minitab Connector to import output as hierarchical sheet OutputsHier.
Introduce a new function DateDif() like Excel
Support auto detect Unix Timestamp in XML file and import as date.
Insert symbol before = of bad formula or replace it with number or text
Open Code Builder to edit before formula scripts/python when set values
Introuduce a new function SumProduct() like Excel
Show <all> sheets option no matter how to open Excel Import Options dialog
Search Only Inside Cell Formula and other improvements
Similar to Flash Fill in Excel and Smart Fill in Google
Import CSV Connector to import NaN values as missing values.
Mini toolbar for dynamic merge and single click to edit for all cells
Using if function with IsEmpty as condition for large data
Use multi-thread to do vector calculation for Set Column Values
Support importing Outputs from Minitab file into a hierarchical sheet.
What you see will be what you search
Indicator in F(x) row for columns with set multiple values
Keep cell formula from Excel and google sheet when pasting data into Origin
Return row index if the 3rd parameter is not specify for Lookup() function
Pre-install Minitab Connector and support showing Sparkline.
Support HTML navigator for Minitab Outputs.
Add more stats properties in the Time Series Pivot tool
Worksheet Query support match by Long Name when query multiple worksheets
Add a new paste menu not to do smart paste
Introduce a new function NumBreak() to find the position of a number/text in string
Introduce a new function NumExtract() to extract number from text
Introduce a new function RandBetween() like Excel
A new mini toolbar button is added to replace cell formula with its result
Set Multiple Columns Values support 0 for auto end column
Improvement on Show Formulas for Worksheet
Skip [i] if referring to same row from other columns in row indexing
Support sort by categorical when sort column by label
Select multiple columns and sort each column ascending or descending
This will make more excel formula work without need to edit formula
Support TRUE and FALSE similar to Excel and Google Sheet
Use #REF!, #NAME?, #NUM!, #ERROR! for bad cell formulas
Mini toolbar on worksheet level to resize all columns to show all contents
Support sort by category indices in the wsort XF
Terms
Refine by Type
Version
Refine by Category