[Test] Junk

1517

ORG-21489

Add EC90 and EC10 output for built-in functions and Sigmoidal gadget

We only output EC80 and EC20 in built-in Fitting Functions in the past. EC90 and EC10 are added in the following fitting functions and Sigmoidal Gadget.

• Boltzmann

• DoseResp

• Hill

• Hill1

• Logistic

• MichaelisMenten

1523

ORG-21366

ANOVA support ordinary numeric data as Factor

To display the X axis of interaction plot in two way ANOVA to be numeric instead of text, Origin 2020b improved Group designation to support such requirement.

1514

ORG-21059

Batch Peak Analysis improvements

• Speed improvement of batch peak analysis

• Recalculation support of Batch PA

• All Columns option in Input node

• Sort Output Sheet by Peak Index checkbox to show peaks by peak index. E.g. peak 1 of all spectra show together, then peak2 of all spectra, and so on.

• Further speed up to open Batch Peak Analysis dialog when input has many XY datasets

• Better error message on Messages log so user knows which data failed during batch processing.

• Batch PA picks all plots in page if starting from Graph window

• Put Dataset ID in user-defined parameter row when appending results by Columns

1512

ORG-21218

Customize Peak Filtering Method with script

New Filter Condition box added on Find Peaks page of Peak Analyzer to set some condition of found peaks

E.g. write n<=3 AND hp>=20 so find no more than 3 peaks found peak height must be no less than 20% of maximum height.

1522

ORG-20798

Easy way to select data for ANOVA

ANOVA Tools dialog Add a ? button next to the Data node for Raw data

1511

ORG-21205

Option to use data in x axis range when doing PA from zoomed in graph window

1506

ORG-21147

Output Gadget results to source data workbook

In the past, user could only output gadget results to new workbook.

In Origin 2020b, user can specify [<input>]Sheet2 to output results to new sheet Sheet2 in source data book.

1513

ORG-21225

Peak analysis on plot with Y error bars

When there is Y Error bar in plot and open Peak Analyzer, the Y Error will be included in Input data on first page. Weighting method is still controlled on Fit Peaks page. User can save PA theme with Y error bar and use on new plot with error bar.

1516

ORG-21250

Put more useful information in analysis that output to matrix

The source data's info should be putted to  the result matrix object's metadata, such as sheet name, long name, unit, comment and so on

1508

ORG-21336

Reprocess button on Batch Processing summary sheet

After doing batch process, use may want to modify template and do the batch process again, or data file has been modified and user wants to batch process again.

In Origin 2020b, a Reprocess button is added on summary book. Use can click it to update the result based on modified template or data.

1525

ORG-18845

Request for pairwise group comparison in survival analysis

Origin 2020b supports Pairwise Comparisons in survival analysis tools.

1510

ORG-21228

Sort Peaks in Peak Properties sheet

Sort worksheet wasn’t supported in Peak Properties sheet before Origin 2020b.

1515

ORG-20579

Speed improvements of Unstack Columns

Using multi-threaded for Unstack Columns calculation, so the speed should be much faster now.

For example, unstacks 4M points of data to about 2000 groups, the speed is about 6 times faster.

1521

ORG-21407

Statsxy X-Function to get statistics by binning

Calculate statistics on Y based on X Binning. Multiple quantities can be calculated.

1524

ORG-8509

Support 3D plot in Principal Component Analysis

Origin 2020b add 3D Loading Plot , Score Plot and Biplot for Principal Component Analysis.

1518

ORG-19163

Support better way to handle large x in polynomial fit

Mean is subtracted from X before fitting. Not works if Fix Intercept option is checked.

1520

ORG-8015

Support Mean Comparison in 3 Nonparametric analysis tools

Support multiple mean comparison for Kruskal-Wallis ANOVA, Moods Median Test and Friedman ANOVA.

1507

ORG-21274

Support Multiple Dataset Idenifier in analysis result

User can specify more than 1 Dataset Identifiers, e.g. In Statistics on Columns, Fitting, Peak Analysis, etc.

1519

ORG-12333

System variable for number of iteration of fixed center in fitting

System variable @FCI is added in Origin 2020b.

When @PFFC is not set as 0, set @FCI to set the the number of iterations of fixed center in fitting.

1509

ORG-21482

Update button on Batch Processing Summary sheet

User can edit/mask data in Intermediate workbook created by batch process. Then select corresponding row(s) and click Update button on Summary sheet to get recalculated result.

1490

ORG-21435

*.MPR File Import Supported

Biologic file import App.

1467

ORG-21150

Allow more characters for Text format cell

Increase the limitation for a Text format cell, now you can enter up to 799 characters in a cell. (In previous version, the limit is only 252 characters)

If you want to enter more, just use the default Text & Numeric format. For a Text & Numeric format cell, you can enter up to 3799 characters.

1472

ORG-21413

Append Worksheet Improvement

Add Dataset Identifier in result sheet. E.g. if appending worksheets row wise, new column will be added in result sheet to indicate which sheet the rows are from.

Besides, hidden column will be skipped in appending result.

1480

ORG-234

Apply same color palette to all matrix objects if image slider is on

When image slider is on, user can use the color palette toolbar button to apply same color palette to all matrix objects in same sheet.

1465

ORG-21703

Better display of cell contents instead of ####

Origin used to display cell values with #### when text or number are longer than cell width.
In Origin 2020b, it will show whatever fit.

Turn off the feature by system variable @WPE =1

1469

ORG-20651

Better support drag to autofill

• Alt + Enter to auto fill multiple worksheet cells. Highlight block of cells, type something in the first selected cell, then press Alt +Enter will fill all selected cells with same text.

• Support autofill to left or up direction.

1404

ORG-21258

Change data type, display, digits, etc. of multiple matrix objects in same matrix sheet together

Apply to matrices to the right checkbox is added to apply same format to all matrix objects in current matrix sheet.

1493

ORG-21424

Changing Data Source with Data Navigator

Add a LT to check if current book supports multiple data source for data connector.

wbook.dc.mfiles=0; \\0: not support, 1: support

1482

ORG-21338

Connect Multiple Files

Connect to multiple data files at one time. This is only supported for some data types such as CSV, HDF, Excel, Matlab, NetCDF.

1474

ORG-21548

Copy Column Improvement

• Add option to sort output worksheet.

1384

ORG-21107

Copy data (columns or range) from worksheet or matrix and paste as plot in existing graph window.

• Copy for plotting button in column/range level mini toolbar to copy data and then Ctrl+V to paste as a plot in an existing graph window

• LabTalk command to Copy (worksheet mjst be active, with some selection):

  worksheet -cp; paste what was copied above (graph must be active):

  layer -pcp; //paste, CANNOT undo

  layer -pcpu; //paste, CAN undo

1486

ORG-21284

CSV Data Connector supports wildcard in defining Data Block Marker.

User keywords to match Start and End for Data Block Marker in CSV data connector. Now it supports wildcard (*, ?).

1484

ORG-21759

Data Connector related toolbar buttons

3 buttons added at the end of Import toolbar

• Import all connected books in project – it will reimport data in all books with data connection

• Connect to data from web…

• Connect Multiple Files…

1495

ORG-19856

Data Connector to read tables from PDF files

Added Extract PDF Tables app to import tables from PDF files

1488

ORG-21540

Data Connector to support child matrix book

Certain data connectors (NetCDF and HDF5) supports importing matrix data into matrixbooks embedded in workbooks.

1485

ORG-21283

Data Navigator

Data Navigator shows on the left side of workbook/matrix book for applicable data connectors, e.g. Excel, Origin Project, Matlab, NetCDF, etc.

User click right click sheet(s), datasets there to import into new sheet, same sheet, remove, etc.

1505

ORG-20943

Database import supports importing images

Database import now supports importing images into images in worksheet cells. Tested wiht MySQL and SQL Server only.

1504

ORG-20953

Database now supports ODBC-based connection strings.

Can now specify ODBC settings in a connections string. For example:

Driver=SQL Server;
Server=tcp:olab.database.windows.net,1433;Database=sample1;
Uid=blahblah;Pwd=blahblah;Encrypt=yes;
TrustServerCertificate=no;Connection Timeout=30;

1487

ORG-19709

Drag and drop data with Data connector Improvements

• For data type that can be imported by both data connector and old import method, data connector will be used by default.

• When dragging and drop a file into an analysis template with data import settings saved, it will use the old import method.

You can alter this default behavior with a new 2020b system variable, @DDC, which stands for Disable DC (for drag and drop)

1401

ORG-20833

Easy way to go to corresponding graph from result sheet

When user click green lock in result sheet, Go to Graph context menu is added to easily go back to the graph.

1407

ORG-21251

Edit Matrix/Virtual Matrix Z Title in OM

User can right click the plotted matrix data or virtual matrix data in Object Manager to rename Matrix Long Name or Z title of virtual matrix.

1473

ORG-18694

Highlight entire row by condition

Add option Apply Coloring to Sheet to Conditional Formatting tools, include wcolor, wheatmap, and wcolordup XF.
Select it, so you can apply the color to entire row.

1494

ORG-21684

HTML DC Improvements

Added new Options item to HTML Connector sub menu, and system variable @DCW to initialize the options in Options dialog.

@DCW = 0 (default), Cache result of HTTP request and use specified in raw HTML source.

@DCW = 1, Do not cache result of HTTP request.

@DCW = 2, Run javascripts associated with HTML. May provide altered table content.

@DCW = 3, Both above.

1478

ORG-21440

Image slider

When there are multiple images in same matrix sheet, user can drag the image slider to quickly view images. User can toggle between image slider or thumbnail with matrix mini toolbar.

1483

ORG-21384

Import multi-sheets with Excel Connector

Before Origin 2020b, user could only connect to one sheet of Excel file at a time. In Origin 2020b, after connect to an Excel file, all sheets are listed in the Data Navigator on the left of workbook window. User can select sheet(s) there to import.

1502

ORG-21019

Improved database connection options

New Database Connector dialog allows user to use Connection string, an existing ODBC datasource, a custom ODBC connection w/o datasource or an OLE DB connection.

Custom ODBC connection allows choosing driver and basic connection settings. For advanced settings, create a datasource in Windows Control Panel.

1475

ORG-21691

Join Worksheets Improvements

• Origin has X-Function to join worksheets by column or label but no menu for it. They are added under Worksheet menu now:

  • Join worksheet by Column

  • Join worksheet by Label

• More options

  • Simpler syntax. When joining sheets with column A, older syntax [Book1]Sheet1!A=[Book2]Sheet1!A. New syntax: A or Time is time is the long name

  • Sort Output ascending and descending

1501

ORG-20719

Make Database Consistent with Data Connector

• Added Auto Import for Database Connector: Added Auto Import menu item to Database Connector submenu for auto import when open the project with Database Connector.

• Added Graph Import Icon for Database Connector: When make a plot using data from database connector, save the project and reopen, will show an import icon on the Graph page.

1496

ORG-21411

MATLAB and HDF Data Connector Improvements

For MATLAB and HDF connector that import into matrix, added system variable @MSS=10.
If number of matrix > @MSS, then show thumbnail area using slider.

1491

ORG-21176

MATLAB Connector transpose imports 1*N mat data

MATLAB 1 dim matrices shall be transposed in order to fit into a worksheet column.

1383

ORG-21087

Mini toolbar for worksheet and Matrix

• Quick access to common operations on cell, column, row and worksheet

• Toggle display of cell formula, categorical index, column list view, or worksheet organizer

• Toggle matrix view, image slider, or X/Y coordinates in matrix

• Customize Mini Toolbar buttons

• Shift key (Hotkey) to bring up mini toolbar again

1481

ORG-20944

More shrink methods in Matrix Shrink dialog

Before Origin 2020b, user could only reduce the number of rows and columns in matrix by averaging. In Origin 2020b, more shrinking methods are provided such as sum, max, min, sd, keep first cell, keep last cell.

1492

ORG-20224

NetCDF Connector

Added NetCDF Connector app for netCDF file import.

NetCDF Connector supports importing netCDF 4 dimensions one slice as 3D data into Matrixpage, for example:

When a netCDF file have a 4D variable e, give it a selected path: NetCDF/e[x][y][z][1],NetCDF/e[z][1][y][x]etc

1497

ORG-19299

New support for Web Connector

•  Support HTTP Post Requests.

• Improve auto detect for JSON files.

• Support Self-signed SSL Certificates.

1500

ORG-20712

Own C++ code to import MDF4

Added MDF4 Connector for MDF4 files import.

1499

ORG-20993

Pipe bar delimited ASCII

CSV Connector supports import pipe bar delimited ASCII file.

1479

ORG-21258

Quick way to change data type, display, digits, etc. of multiple matrix objects in same matrix sheet.

Apply to matrices to the right checkbox is added in Matrix Properties dialog

1470

ORG-20648

Remove/Combine Duplicated Rows Tool Improvements

• Support Multiple Reference Columns. Values in all reference columns must match to treat as duplicates

• Support Duplication Tolerance. Set duplication tolerance to treat close by values to be duplciates

1476

ORG-21624

SCV data copying and referencing improvements

Can now use offsets from i when copying column data using Set Column Values. Define range to a subset of data in the Before Formual Scripts section, then applit an i=based offset in the Formula. See illustration below.

Last value in column may now be references as A[0] or A[end]. Range to end is A[5:0] or A[5:end].

1503

ORG-19571

Slow database queries can now be aborted.

Slow database queries can now be aborted by clicking Cancel button during import. Includes improved error reporting.

1471

ORG-21041

Split Worksheet Improvements

• Split Worksheet by Reference Column Value speed has been improved by a factor of 10 or more.

Tested with a worksheet with 1.8million rows and 5 columns with a reference column of two categories. The split speed improved from 158 sec in Origin 2020 to 12 sec in Origin 2020b.

• More split options when splitting worksheet by Reference column, such as direction change, direction reset, reference value change. E.g. if X value increase, then decrease, and then increase again, user can split worksheet into 3 sheets so each x part is monotonic.

1477

ORG-20808

Support cell formula update when copy and paste

Example I: Enter formula “=A1/B1” in C1 cell, copy it and paste to C2 cell, formula will automatically update to “=A2/B2”.

Example II: Enter formula “=total(A)” in C1 cell, copy it and paset to D1 cell, formula will automatically update to “=total(B)”.

1498

ORG-20789

Support Import newer IMC Famos File Format

impFamos supports importing the new imc3 format.

1466

ORG-20855

Support keyword "This" for workbook with Spreadsheet cell notation off

E.g. Enter This+1 to F(x) cell.

Enter mean(This) in user-defined parameter row or bottom of the column.

1489

ORG-21494

Support worksheet comments via Origin Connector

Origin DC can now retrieve worksheet comments when using a query. for example:

Select Column From Project Where Sheet_Comments like "Sheet1" and Book_Comments like "Book1"

1468

ORG-19975

Worksheet name improvement

• Change Sheet Long Name to be called Sheet Label.

• Add system variable @SSL to control sheet display name. Default @SSL = 2, Short Name will be shown.

• When loading project previous Origin 2020b, sheet name will be auto rename to original Long Name if name is like "SheetN", and Long Name will be removed.

1448

ORG-21093

3D Vector tab should be always visible

If there is no error enable in any direction, then 3D Vector tab should still show.

When Enable 3D Vector is selected but any one of X/Y/Z End is set to none, it means there is no vector, so error bar tab do not need to hide.

1398

ORG-20663

Add Fill Color button for Area Plot button to plot mini toolbar

Add new Fill Color button for Area plot, Line plot (Fill Color Under Curve is checked)

1397

ORG-21396

Add Rescale Mini toolbar button to axis .

Axis mini toolbar now has Rescale button

1396

ORG-21398

Add Rotation Mini Toolbar button for label

Support single/multiple text label(s) rotation.

1445

ORG-20319

Additional Line for Polar Axis

Add Additional Line branch to Grids tab in Angular Axis.  Fill area under curve and drop line to additional line will work when Additional Line is set to a R value.

1457

ORG-9378

Alignment for multi-line text objects

• Support left, center, right alignment for normal text object and legend object.

• For legend, this option should treat text part and legend symbol as separated columns, and only affect text column.

• Make Alignment buttons on Format toolbar work for multi-line text.

• Add alignment button to mini toolbar of text object but do not need this button for legend.

1400

ORG-20964

Axis mini dialog improvements

• Change direction: X or Y axis switch in mini dialogs: such as axis scale, grid line style, reference lines, etc.

• More… button to open corresponding tab in Axis dialog

• Log checkbox in Axis Scale dialog

1460

ORG-21129

Axis Reference Line Fill Improvements

To add multiple reference line and fill adjacent areas with different color, duplicate reference lines are needed.

E.g. if user wanted to fill from y=0 10 with one color, y=10 to 20 another color, user needed to enter two y=10 reference lines.

It’s improved in Origin 2020b so user can specify fill color between any two reference lines.

1414

ORG-18848

Beeswarm Plot

Basically, Beeswarm plot is a kind of column scatter plot with special data point arrangement. Former Jitter Points checkbox is replaced with Arrange Points dropdown list in box chart. Several data arrangement methods are available.

1450

ORG-19835

Better Radial Grids for Polar

Polar Axis dialog now supports set radial axis' reference line fill to itself. So fill inside circle is available now.

1417

ORG-20552

Bland-Altman Plot

Under Plot: Statistics menu.

1428

ORG-21321

Box Chart Improvements

• Support Plus only, Minus only Whisker in box chart.

• Mean and median symbol for grouped box chart

1412

ORG-21201

Browser Graph in Window View

• Plot: Browser menu to plot data (fast for worksheet with many columns) as Black Line, Colored Line, and Histogram. User can customize in Plot Details for more plot types, e.g. scatter, etc.

• Select plots to show in graph by selecting them on left panel. The left panel columns are customizable and sortable.

• Click the dropdown button on left panel for further options,

• When using Scale in toolbar to create a separate enlarged graph, turning off plots in browser graph will turn off corresponding plots in enlarged graph as well.

1418

ORG-21537

Bullet Chart

Under Plot: Specialized menu

1403

ORG-20834

Change X or Y of plot to column from other worksheet

• Select Columns is added under Change X and Change Y to pick column from other worksheet

• Old Select Columns context menu is renamed to More… to select other column in current sheet when containing multiple columns.

1459

ORG-21106

Color Scale Tick Label Size Affect Bar Width

Changing font size will modify value for Color Bar Thickness so color bar width will not change accordingly.

1430

ORG-21064

Colormap Contour and Worksheet Conditional Format: Heatmap: Allow specifying Middle level value in in 3 color limited mixing

By default when using 3-color mixing for contour plots, the middle color falls on the mid point value of From and To value.

In Origin 2020b, user can specify mid color by Value, Percent or Percentile.

1421

ORG-21204

Common Display Range for plots in layer

Run “layer.commonrange=1” in script window to use common range for all data plots. Then right click any plot to Edit the range. Other plots will show the same range.

1427

ORG-20765

Create Plot with label column designation

In very old version, user needed to set a column as Label to show label of a plot. The label is actually a separate plot entry if you open Plot Details dialog.

We hid it now since in newer versions, after plotting data, user can use mini toolbar or Plot Details to set any column as the plot’s label. See Labels tab of plot level. in Plot Details dialog.

But some user may still use the old way to set a column as Label. In Origin 2020b, even if user set a column as L, we plot it as a property of plot so Labels tab is updated with it.

1452

ORG-18493

Curve Tool

• It draws a smooth line object. When the last point is close to 1st point, it will be connected.

• 1st click on curve will enter edit mode. Drag the solid handlers on cursor to change the shape

• Support fill cuve and polyline objects with pattern and color

1458

ORG-20930

Date Time Stamp use modified date format on new graph

When text object name is timestamp, we support a copy of text object default for this name. Basically, it will need to contain all text, position, frame related format except text content.

When user click Date&Time Stamp button, we create text object with this default.

No matter which layer user selected, we only create Date&Time stamp for 1st layer. Since we will update when there is existing time stamp, so active other layer will just update time stamp of 1st layer.

1456

ORG-21734

Display Filter from Source

User can add label in graph with %(1, @LF, A) to refer to filter condition in source worksheet’s column A.

If user copy columns from source sheet to new book by Copy Columns To tool and plot from the new book, user can use %(1, @LF1) to refer to 1st row of filter condition if there are multiple filter conditions.

1411

ORG-21000

Easy manipulation on Theme Editor dialog

• Press + or - key on numeric keypad to expand/collapse the branch. press * key to recursively expand selected branch and its children. Press Backspace key to go to the parent

• Add 2 context menus:
  Expand Recursively
  Collapse Recursively

1419

ORG-21137

Error Ellipse bubble plot

Make Ellipse plot by running script:

worksheet -p 112 ellipse;

1420

ORG-20318

Fill to relative base in Stack lines by Y Offset graph

In the past, when user fill area under curve in Stacked lines by Y offset graph, they are filled to the same base. See left graph.

In Origin 2020b, on Stack tab of Layer level in Plot Details dialog, a Custom Additional Line by Relative Position checkbox is added. Check it, each curve will be filled to relative additional line. Note: The additional line position is set on Grids tab of Axis dialog. E.g. y=0.

1461

ORG-21310

First Tick in Axis dialog and Color Scale Control dialog is renamed as Anchor Tick

The name First Tick is misleading. It’s actually an anchor location tick must pass. E.g. if axis is from -2.36 to 3.789. Set Anchor Tick as 0 and Increment as 0.5. The major ticks will show at -2, -1.5, -1, … 0, 0.5, 1, …. 2.5

Same for color scale object. By default we only show ticks on major levels. User can set Levels to Custom Levels. And set Anchor Tick as 0 to make sure level 0 shows.

1436

ORG-21363

Heatmap improve to support triangular part and labels follow colormap

• Fill Display Setting to show triangular part of blocks only.

• Label Display setting to show triangular part of labels only.

• Label color set to auto:

  • If there is fill display. show black or white color according to fill color.

  • If there is no fill, follow fill color.

1386

ORG-20169

Layer mini toolbar Improvements

• Layer mini toolbar Improvements: Add Rescale button to show all, Add statistics reference lines, Add plot buttons.

• Move Add plot, Show data plot, Clip data to frame and Layer dialog to 2nd line. Move Rescale button to 1st button of 1st line

1433

ORG-21499

Mask data points in Box Chart

For box chart with data points, user can use Mask tool to mask data points hdining them on the plot and masking the worksheet cells.

1410

ORG-21499

Mask data points in box chart

Mask toolbar button can work to mask points on box plots..

1391

ORG-21255

Mini toolbar button for data points of box chart

Mini toolbar button for data point control of box chart (Box type: Data)

1395

ORG-21581

Mini toolbar buttons to rotate polar plot

Mini toolbar buttons to rotate polar plot.

1429

ORG-21052

More box chart improvements.

• Draw Whisker/Error Bar on Top of Data checkbox is added on Box tab in Plot Details

1405

ORG-21242

More plot type is added under Insert: Plot to Layer sub menu.

Based on active graph window type and last activated worksheet/matrix, applicable plot types show under menu Insert: Plot to Layer sub menus.

E.g. if user plot a 2D graph and then activate a matrix window then go back to Graph window.

Choose Insert: Plot to Layer, contour, image, histogram types show.

1399

ORG-9298

New Axis break mini toolbar

Customize axis break with axis break mini toolbar.

1431

ORG-21666

No longer necessary to also select a luminescence level.

When selecting a color list for a grouped plot, you used to have to select both a color list and a luminescence level. Now you just need to select the color list. You can optionally change the luminescence level separately.

1385

ORG-21169

Page mini toolbar Improvements

Add Window/Page view toggle button (single layer or linked+superimposed layers (e.g double-Y) only), add Fit page to layers button, add Update Page Dimension buttons:

1415

ORG-21315

Plot 3D Bars side by side

Plot: 3D: XYY 3D Side by Side Bars menu to plot such graph.

Side by Side Bar Style checkbox is added on Miscellaneous tab of Layer level of Plot Details dialog

1464

ORG-17619

plot break marker at the axis breaker region

Support a control to plot break symbol for line plot and bar plot.
We can use labtalk to control. For GUI, we only support mini toolbar.

1387

ORG-21110

Plot mini toolbar Improvements

• Add Change Plot To and Edit Range mini toolbar for plot.

• Add Ungroup mini toolbar button for group plot

1444

ORG-21553

Polar Bar Support axopetal gradient fill

Polar bar has two-color gradient fill, with one color to another towards the center of the polar graph. Four options are added:

• Radial Inward

• Radial Outward

• Radial Center Out

• Radial Center In

1443

ORG-21461

Polar Bar Support Label

Change Horizontal Offset and Vertical Offset to Angular Offset, and Radial Offset in Label tab for polar plot. And they work like polar scatter with Position=angular inner/outer.

1416

ORG-20319

Radial Bar Plot and Stacked Radial Plot

User can select multiple Y data to create stacked polar graph, including line, area and column/bar

Under Plot: Specialized Plot menu

1439

ORG-20972

Refresh Issue of OpenGL graph

A new system variable @RUGT is added to control whether a graph should redraw when uncover. @RUGT is in milliseconds, if a graph spends less than that time to finish drawing, then it will redraw itself when being uncovered (regardless of the @NPP). Otherwise, the @NPP would still be effective.

1442

ORG-19513

Rescale Margin General Improvement

Add system variable to control whether layer should round to tick, @RRT
For plot which is not controlled by rescalemargin, we make it not control by @RRT

1446

ORG-20553

Rescale should consider reference line

Rescale button will consider reference line.

1402

ORG-20528

Reverse Plots from Object Manager

In Object Manager window, right click layer node to reverse plot orders.

E.g. after reversing, the graph above will turn into

1389

ORG-20970

Separate Mini Toolbar buttons for X and Y Errors

X and Y Error bars have separate Mini Toolbar controls.

1455

ORG-21583

Set X Y Data Label & Annotation to follow axis tick label display and formula

Origin supports formula for tick labels.

If it’s used and then user adds data label, annotation, and some gadgets to show X, Y value, user can set Custom Format as X, Y, Z to show value based on tick label formula.

For Data Label, when picking Y as Label Form, set Custom Format as Y, Y, .2, Y, *4 to set decimal places and significant digits.

For data annotation, set label form as $(Y, Y), $(Y, Y, .2), $(Y, Y, *4)

This also applies to Vertical Cursor and Quick Peak gadgets.

1424

ORG-20695

Show Drop lines at specified points only

The following syntaxes are supported:

1. 1 3 5 – show at specified row indices.

2. 2:0:5 – starting from 2nd row to end, show 1, skip 5.

3. x=3.5 7.8 – show at specified X

4. [book1]sheet2!col(A) – show at specified rows values read from specified column

5. x=[book1]sheet2!col(A) – show at specified X values read from specified column

1441

ORG-21347

Show Hide Plot with Specified Name

Add a editbox and fly-out button after Show/Hide Plots with Same Name. The fly-out is same as Legend Custom Format fly-out.

1425

ORG-21477

Show Label at Specified Points with new syntax

• Same syntax as Show Drop Lines at specified points only. e.g. x= 2.5 3.5, etc. If corresponding x value doesn’t exist, the label will not show.

• Show labels at drop lines only

1438

ORG-20838

Skew Plots by adjusting Angles between Axes

Skew Coordinates controls on Display/Speed tab of Layer level in Plot Details dialog.

1390

ORG-20171

Special Point Mini Toolbar support

Add mini toolbar for special point for customization, hiding, labeling.

1413

ORG-19927

Streamline Vector Plot

Plot > Specialize: Streamline (when a matrix with two object is the active window)

The two matrix objects are the derivatives of the plotted curve in the (x,y) directions, respectively.

1434

ORG-20650

Support Connect Line for 2d and 3D XYY bars

Display tab is added on Plot level to turn on connect line, symbol and dropline for 2d and 3d XYY bar plots.

1408

ORG-19779

Support Data Highlighter in 3D graph

E.g. plot 3D scatter graph. Click Data Highlighter toolbar button and drag rectangle to select a region. Corresponding data in worksheet and other graphs are highlighted.

1437

ORG-21433

Support displaying area plot’s border line style in legend.

1447

ORG-21320

Support Label each plot of group differently

Show label for each plot differently is now supported.

1393

ORG-21200

Support Mini toolbar for data selector

Mini toolbar for data selector

1394

ORG-20911

Support Mini Toolbar for graph objects

• Mini toolbar for graphic object (Line and Arrow, Rectangle and Other Shape, X/Y Scale, Axis scroll bar, Analysis Marker, select Multiple Objects)

• Mini toolbar to customize multiple objects together

1422

ORG-4523

Support negative value in log plot

When Scale Type is Log10, Ln, Log2, Following options will show in Axis dialog Scale tab under Type:

• Symmetrical Log Scale

• Linear Range Threshold

• Linear Range Length

1423

ORG-19651

Support turning off column/bar baseline

Origin uses the Additional Y= line on Grids tab of Axis dialog to control where column/bar is plotted from. In the past, the baseline can not be hidden. Origin 2020b supports uncheck the checkbox to hide it but still use it as baseline.

1454

ORG-21314

System variables to attach text, rectangle and circle objects to Layer & Scale by default

If text or graphic object is attached to Layer&Frame, the position will stay with axis scale position. If it’s attached to Layer Frame, it will stay where it is even if axis scale changes.

@arx //text object attachment. 1: layer & scale. 0: layer frame (old behavior)

@arr //rectangle & circle attachment 1: layer & scale. 0: layer frame (old behavior)

We already have @ar for line and arrow objects

1440

ORG-21184

Template can't work in Image Profile

• We add following in Default Settings dialog.
  Profile Plot Type --> Line //default
  Scatter
  Line+Symbol

• Add Profile Line Name. Select it will set Legend Custom Format to @LC.

1453

ORG-19962

Text Customization Improvements

• Add Sub- and Superscript for non-consecutive characters

In Text Object dialog, if non-consecutive characters are selected with Ctrl key, set it to superscript or subsript now keep it’s position.

• Select Multi-lines to customize in Text Object dialog

1449

ORG-13618

Theme Editor Improvement

When filter is selected, turn off the filter(select All) should keep the selected option in screen. If there are multiple selection, the first one should be in screen when filter off.

When user select a branch and right click, we should show an option "Collapse All Siblings" in context menu. Select this option means we will collapse all branch with the same level as the current selected one.

1463

ORG-19878

Tick Label related improvements

• Set Rotate (deg.): Auto to auto rotate tick labels to avoid overlapping. Set system varaible @ART=0 to roll back to old way.

• Check Auto Hide Overlapped Labels checkbox when there are many tick labels.

1426

ORG-21358

Transparency for Fill color only

In previous versions, transparency was applied to both fill color and edge. Now transparency can be applied to fill only.

1432

ORG-20927

Transparency option for vector plot

1392

ORG-21470

Wrap text button for legend, axis title and text labels

Wrap text button for legend, axis title and text labels

1451

ORG-9996

Wrap Text in Legend, Axis Title, Text Labels on graph

E.g. click legend, and choose Wrap Text button on mini toolbar. Drag the edge of legend box to resize it. Legend will be wrapped.

A Wrap Text, Adjust Height checkbox is added on Frame tab Text ProObject dialog.

Note: When it’s wrapped, we don’t support resize the text to change font size. Please use mini toolbar or regular toolbar.

1462

ORG-20753

Zero tick label display options on Axis tab of Preference: Options dialog

• add No Trailing Zero checkbox to remove the trailing zero in axis tick label(such as 5.0-->5)

• add Zero is ‘0' checkbox to always show zero value as '0'(such as 0.0E+0 -->0)

• system variable control @tlc (default 3) so both are checked.

  • @tlc & 1: Zero is '0'

  • @tlc & 2: No Trailing Zero

1435

ORG-21375

Zoom and Rescale Hotkeys in 3D graphs

• D key + mouse wheel --- zoom in Z direction

• Z key + mouse wheel --- zoom in X direction

• Shift+Z keys + mouse wheel -- zoom in Y direction

Note: Enable clipping on Miscellaneous tab of Layer level of Plot Details dialog will hide plots outside the axis frame.

1550

ORG-21415

Allow copy paste of images and store them as project attachment

Drag and drop image to notes window/HTML report will create a matrix of image to keep image with project.

1549

ORG-21190

Allow Matlab Console to connect to already running instance of Matlab

If there is already a running Matlab instance existing, Origin will promp a massage asking if you'd like to connect to it. You will need to copy and execute a Matlab cmd in order to enable the connection.

1551

ORG-20873

ASCII Export Speed Improvement

The ASCII Export has been improve a lot.
Suppose to export a worksheet with 10 columns and 100,000 rows of data, the elapsed time can be 6 times faster.

1388

ORG-20527

Customization of Mini toolbar

User can click the … on mini toolbar pop-up to specify the buttons to show.

1409

ORG-21678

Disable all modified system variable values

A user system variable @@ to disable all modified system variables.

• 1 - disable

• 0 - enable

E.g. in Script window, run the following to disable modified system variables to go back to system default.

@@=1 //press Enter key

1552

ORG-21006

Export XML from Worksheet

We should include an XF in product expxml

1553

ORG-21278

LabTalk method to relink broken DDE links

DDE Excel will ask user for file that does not exist.

1547

ORG-21279

Save Separator Settings to Project

File: Properties… menu to save separator settings and then save into project file.

Audit Log and Password protection still needs to be set in Tools menu

1406

ORG-21359

Shift+Up/Down arrow in Object Manager

Quick way to select multiple sheets in Object Manager.

1548

ORG-20696

Show all Pro menu in Regular Origin

OriginPro menus are hidden in the past in Origin regular so many Origin user doesn’t even know they can upgrade to OriginPro to have the feature.

In Origin 2020b,

1. OriginPro menus show in regular Origin, with suffix (Pro) on the menu.

2. Click it will open a message box to let user know it’s an OriginPro feature and consider upgrading.

3. Set system variable @rpm=1 to hide OriginPro menus in Origin.

1537

ORG-21432

Access to name of embedded notes window

With embedded notes sheet active, run the following to pop the notes window open

win -an %@G;

1543

ORG-21022

Add ReorderColWise function for matrixbase class

Added an OC function for matrixbase class:

BOOL ReorderColWise( const vector<UINT> & vnIndices, int nR1 = 0, int nR2 = -1 )

1538

ORG-21409

Connect to Web Support Self-Signed SSL certificate

Many intranets use self-signed SSL certificates. Connect to Web can accept them via Accept self-signed or invalid SSL certificates checkbox. Otherwise there will be an error if not checked.

1542

ORG-21526

Dialog supports multiple columns under the checkbox in branch.

1533

ORG-21202

LabTalk command to open Edit Range dialog

layer -ep to edit display range of plot

1530

ORG-21286

Labtalk function to Join arbitrary ranges as a single dataset

Dataset join(range1, range2, ...)

e.g. =mean(join(A1:A2, C5:D8)

1526

ORG-21065

LabTalk functions to

They are accessible under It’s Function ? Lookup & Reference menu in Set Column Values dialog

• category(vd)$ – e.g. category(A) or category(A)$

• catindex(vd) – e.g. catindex(A)

• catrows(vd)$ – e.g. catrows(A) or catrows(A)$

• cattext(vd, vd)$ – reverse of catindex(), e.g. cattext(E, A) or cattext(E, A)$

1534

ORG-21188

LabTalk property to get plot type info

layer.plot1.pid

1541

ORG-21369

Local Variables should support matrix in Code Builder

When debug in OC, click on the down arrow menu button on the right side of the magnifier icon, and select Object Visualizer to view following data type:
Column
Worksheet
WorksheetPage
MatrixObject
MatrixLayer
MatrixPage
GraphLayer
GraphPage
...
matrix
matrixbase
vector
vectorbase

1532

ORG-21236

More LabTalk function to support partial range as input

Now all LabTalk function is improved to support using partial range as input.
Example,

newbook;
fname$ = System.path.program$ + "Samples\Curve Fitting\Sensor01.dat";
impASC;
col(C) = {1, 2.1, 3.25, 8.8, 9, 10};
range r3A = col(A)[3:17];
range r3B = col(B)[3:17];
col(D) = table(r3A, r3B, col(C));

1527

ORG-21078

New Column Properties

• New Property IsCat to set a column to be categorical or check a column is categorical

wks.col1.IsCat

• New Property EvenX to both get and set a column to be using Sample Interval.

wks.col1.EvenX

1546

ORG-21025

OrgLab Improvements

1.Added these two methods to MatrixSheet:

OODL_PREFIX_METHOD(ODISPID_MLAYER_SET_XYMAP)	HRESULT	SetXY([in] double dXMin, [in] double dYMin, [in] double dXMax, [in] double dYMax, [out, retval] VARIANT_BOOL* RetVal);
OODL_PREFIX_METHOD(ODISPID_MLAYER_GET_XYMAP)	HRESULT	GetXY([out] double *dXMin, [out] double *dYMin, [out] double *dXMax, [out] double *dYMax, [out, retval] VARIANT_BOOL* RetVal);

2. Added these two properties to MatrixObject:

OODL_PREFIX_PROPGET(ODISPID_MOBJ_UNITS)			HRESULT Units([out, retval] BSTR* retvalue);
OODL_PREFIX_PROPPUT(ODISPID_MOBJ_UNITS)			HRESULT Units([in] BSTR value);
OODL_PREFIX_PROPGET(ODISPID_MOBJ_COMMENTS)		HRESULT Comments([out, retval] BSTR* retvalue);
OODL_PREFIX_PROPPUT(ODISPID_MOBJ_COMMENTS)		HRESULT Comments([in] BSTR value);

3. Added the method to PageBase class, which allows moving any PageBase to a PE folder.

OODL_PREFIX_METHOD(ODISPID_PAGEBASE_MOVE_TO_FOLDER) HRESULT MoveToFolder([in] VARIANT fld);

4. Added Comments string property to PageBase class to access WorksheetPage and MatrixPage Comments.

5. Column::SetData, MatrixObject::SetData, Worksheet::SetData, etc will convert 1.#QNAN values to Origin NANUM.

1539

ORG-20879

Page Control Pane Framework

Support LT for Page Control Pane.

page.cp.Add();//add a control pane to the left with default

page.cp.Add(2 40 DataConnector 3);

//First parameter: 1=left, 2=top,3=right,4=bottom

//Second parameter: window width(%)

//Third parameter: control pane type

//Four Parameter: APPLY Button = 1, Hide Show Pane Button=2

page.cp.Remove();//Remove control pane

page.cp.Show = 0;//to hide it, and =1 again to show it

1529

ORG-21288

Sem() function to calculate standard error of dataset

• Syntax Sem(A) in cell formula or set column values dialog or Sem(col(A)) in Script window and code.

• Available under Under Function ? Statistics menu in Set Column Values dialog.

1536

ORG-21671

Set Order for Worksheet column labels quickly

wks.Labels(@);

Reset current worksheet column label row to default order.

1528

ORG-21127

Split Text Cell / Text to Columns tool like Excel

Add xfunction text2cols.OXF and put it under : ..\Origin\X-Functions\Data Manipulation\Worksheet\text2cols.OXF

In Script window, type text2cols -d to open the dialog

1544

ORG-19973

Support button in HTML report

See example when Note window active, HTML: Load Samples: Combo and Button.html

1540

ORG-19463

Support for Python PIP

python.exe is shipped with Origin, use LabTalk method InstallPythonPackages() to install package.

E.g. InstallPythonPackages(1, "scipy scikit-learn scikit-image");

1545

ORG-21472

Support OC function to set structure LROptions to default values when using ocmath_linear_fit

OCMATH_API void ocmath_init_linear_fit_options(LROptions* psLROptions);

1531

ORG-20706

Support returning vector result to LT StringArray

Following usage is now supporting.

StringArray sa;
sa = unique(col(A));
sa.getsize() =;

1535

ORG-21674

Unix timestamp conversion function

New function to convert to and from Unix timestamps.

double UnixTime(d1[, d2, n])

Where d1 is a Unix timestamp or Julian date, d2 is a timezone offset (default 0), if n=0 (default) convert from Unix time stamp to Julian date. If n=1 it convert from Julian date to Unix timestamp. Supports vectors for SCV usage.