Page Comparison

0

ORG-17657

Allow importing data directly into embeded matrix in worksheet when performing batch processing

If the embeded matrix exits in the analysis template, batch processing support importing data or image to the embeded matrix. Besides,  drag and drop to import data or image to opened analysis template is also supported.

0

ORG-17656

Batch Plot dialog now combines options for Book, Sheet and Column into one dialog

Batch Plotting GUI Improvements

• Combine Batch Plot with Book, Sheet and Column into one dialog. There is Batch Plot with dropdown list on the top of the dialog.

• Matching conditions to filter book/sheet are moved on top of the book/sheet list.

• Batch plotting menus and toolbar buttons also combine into single button and menu.

Image Removed

Image Added

0

ORG-16656

New App to distribute multiple files across multiple cores for faster Batch Processing

Select the Analyis Template and data files. Then specify how many cores to be used. The files will be distributed to multiple instances of Origin running on each core. App can be used to monitor progress. Once all tasks are finished, a consolidated summary report can be created with results from each core combined into one table.

0

ORG-17383

Save Batch Processing dialog settings into Analysis Template

When using an Analysis template in Batch Process dialog, the batch processing dialog settings will be saved into the analysis template so that the next time this analysis template is loaded in Batch Process dialog, no need to set batch processing setting again. 

A system variable @bst is used to control the behavior.

0 : always no save settings;
1 (default): always save settings;
-1: pop up msg to ask.

0

ORG-17526

Some rule changes to batch processing

We tend to have no dialogue, no interaction, in batch process. So the rule of batch process now becomes to:

1. Before doing any batch process, user must make sure the input files format should be match with the last import settings in .ogw or filter in UFF.

2. Last import setting must be used when check on "Use Import Setting in Workbook". filter file will be used when uncheck "Use Import Setting in Workbook".

3. when filter is used, the proper filter should match: a. input file extension must be match with filters setting. b. filter file format must be match with last import settings in ogw.

Once user make analysis template with import ASCII, that means the template is only used for ASCII file. If user want to it for other type file, they must import another file from MENU and save analysis template again.

0

ORG-15328

Support to add data from many sheets/books into a combined graph or an existing graph

• Add data from many different sheets/books into an existing graph

  • E.g. After plotting a multiple panel graph with data in one worksheet/book, user wants to add data from other sheet/book to same graph. 

• Add data from many sheets/books into a combined graph.

  • After plotting a complicated graph with data in one book with several sheets, user wants to create a similar new graph with all data in another book with different number of sheets

Image Modified

0

ORG-17701

ASCII Import:

Origin's auto determine header line may not work well for all user's data.

One example is user wants to import files by removing all lines that start with # character.

In sush case, uncheck Auto Determine Subheader lines and then choose By Leading Character option and specify a leading char under Header Lines node in ImpASCII dialog. This option is also available on Header page of Import Wizard.

Image Modified

0

ORG-17763

Improvements to labels in ASCII import dialog

S1: Some label on ASCII dialog were changed:
1. Show blue hint "each character is treated as one delimiter" when the number of "Other Delimiters” is more than 1.
2. Multiple Delimiters --> Multiple Characters
3. Combine Delimiters as one Delimiter --> Treat Consecutive Delimiters as One (use a same label as ImpWiz)
4. Move "Header Lines" branch node above "File Structure" node, to be consistent with ImpWiz.

S2: Restrict editbox to allow single character input

On Import Wizard dialog, Data Columns page, the "Other" editbox is not allowed to enter more than 1 char.

0

ORG-16604

CSV Import: Added option for starting new rows when importing multiple files

0

ORG-17562

impcsv always import data from specific columns range since Origin2018

Added a system variable @IAR for  impCSV and impMSExcel import tools, when Highlight a column to import CSV or Excel file:

@IAR=1(default): Import data from CSV or Excel file from the first column.

@IAR=0: Import data from CSV or Excel file into the highlighted column.

0

ORG-17662

MDF Import: Significant improvement to speed of MDF Import

Tested with very large MDF file provided by user. It used to take more than 1 hour to import the data. In Origin 2018b, it takes only about 1 minute.

0

ORG-6175

More wav format wanted

1. impWav supports importing 24bit .wav file.

2. impWav supports importing multi-channel .wav file.

0

ORG-17648

Partial Column Import in impBRUKER dialog

Partial Import node is added in BRUKER OPUS import dialog to import part of columns.

Image Modified

0

ORG-17036

Support the import Excel theme created from old version

Support using import Excel themes from old versions in Origin 2018b, before using the old theme, need to run some scripts to convert it.

run.loadoc("originlab\theme_convert.cpp", 16);//Run this script to load the convert theme function.

and then:

1. theme_file_convert_for("impExcel", "impMSExcel", "import_injekt_excel") //Convert single impExcel theme to impMSExcel theme.

2. theme_file_convert_for("impExcel", "impMSExcel") ortheme_file_convert_impexcel_to_impmsexcel() //Convert all impExcel themes to impMSExcel themes.

0

ORG-17477

Copy and paste entire worksheet across multiple Origin sessions.

Right-click on the sheet tab, two new context menu items are available.

• Copy Sheet

• Paste as New Sheet

Use Copy Sheet to copy current sheet with all information(including the header lines and structure) into the clipboard, and then use Paste as New Sheet to paste it as a new sheet from the clipboard into a new layer or new window.

LabTalk command is also provided,

clip -cs; /// copy active sheet

clip -ps; /// paste sheet to active book from clipboard, if possible

clip -psn; /// paste sheet to new book from clipboard, if possible

0

ORG-17790

Export ASCII to support ignore empty columns

Add a checkbox named as "Ignore Ending Empty Columns", to control ascii export, to ignore empty columns from the end, with the following options:

0 = no ignore (current way, default)

1 = ignore all empty columns after the last column with data, meta data not considered, and column with all missing values are considered empty.

This is used only if export selection is not chosen.

0

ORG-16407

Stack Columns tool check numeric for group identifier label row

In Stack Columns, choose a label row as Group Identifier, then Origin will check if all value is numeric and not set it as categorical in the result.

0

ORG-17796

Stack Columns tool will maintain column plot designation for Other columns

Keep column plot designation for other columns in the Stack Columns result.

0

ORG-16882

Support Excel column notation in condition string for Counif() function

For Averageif(), Countif(), and Sumif() function, you can use Excel column name in condition string argument now. E.g,

countif(a, "A>0") //Before Origin 2018b, must use countif(a, "col(A)>0")

Also, the performance of these functons is improved.

0

ORG-16509

Support for custom formatting of User Parameter rows in Worksheet

From Origin 2018b, user is allowed to set data format for a Parameter row or a User-Defined parameter row. This option is provided in Worksheet Properties dialog.

0

ORG-17976

Support more numeric format like Excel

• #5

• Percent: #%, #.00%

• Proper fraction # ##/##, # #/8, # #/4, # #/10, etc. and Improper fraction #/#, #/4, #/10, #/100. ##/##, etc.

• Degrees, minutes, seconds (DMS), D MS, DM, DMF

0

ORG-17285

Support more options when Copy Columns to

Copy Columns to is a useful way to copy columns from one sheet to other sheets and keep the linking. But some settings in source columns are not copied. Added in Origin 2018b.

Image Modified

0

ORG-17157

Hotkey Ctrl+Shift+Drag to duplicate the annotation object to another data point and add visual feedback when moving annotation

Annotation object can be applied to another point by Ctrl+Shift+Drag

0

ORG-17284

Support for label to be attached to data or error bar

Support for label to be attached to data or error bar

We add an option "Error Bar" to "Attach to" combo in Label tab. For Y error bar, it will take effect when position is Above or Below.
For X error bar, it will take effect when position is Left or Right.

0

ORG-17627

Improve Handling of Date/Non-Categorical Grouping Data in Indexed Group Box Plot

Better support Date/Non-Categorical Grouping Data in Indexed Group Box Plot

Better support Date/Non-Categorical Grouping Data in Indexed Group Box Plot

0

ORG-16895

Support Box Chart in Trellis Plot to provide easier way for controlling box charts arrangements from grouped data.

Support Box Chart in Trellis Plot

• Support Box Chart with Panel

• Enable By Point tab for box chart color and pattern

• Add Box Chart to Plot Type combo of plot_group

0

ORG-17058

Support for Stacked Column and 100% Stacked Column plot types in Trellis Plot

Support for Stacked Column and 100% Stacked Column plot types in Trellis Plot

Add Stacked Column, Stacked Bar,100% Stacked Column, 100% Stacked Bar to Trellis plot xf dialog Plot Type drop-down list.

0

ORG-17882-17882

Better legend position when Fitting Layers to Page

Better legend position when Fitting Layers to Page

Add the option -L to the page -FLS command

page -FLS -L; //fit layers to page so as to leave room on the right side for the legend. No gap between layer and legend.

page -FLS -L 0.03 -m 0.04 //fit layers to page, with space (3% of page) btween layer and legend, margin on edge of page is 0.04.

To use the -L option, the following must be true:

• Graph contains a single layer.

• There is one (and only one) legend object.

• Scale Elements (Format: Layer Properties > Display tab) must be Fixed Factor.
  
  

0

ORG-16780

Customize Layer/Plot/Axes properties across all layers

Customize Layer/Plot/Axes properties across all ayerslayers

By checking what you want to customize together on Layers tab of Page level of Plot Details dialog, and then go to a layer to customize settings, all layers will be customized together.

Image Modified

0

ORG-17570

Easier notation for adding labels when merging multiple graphs, including support for Roman numerals

Easier notation for adding labels when merging multiple graphs

Set Label Text as Custom and click the dropdown list to see Custom notations.

Notations can be combined, e.g. h$n$ to show #1, #2, ....

a$ (default) – enumerate lower case letters
A$ – enumerateupper case letters
r$ – enumerate lower case roman numerals 
R$ – enumerate upper case roman numerals 
n$ or # – enumerate numbers
h$ – represent #

Graph## – Graph01, Graph02, ...

hsn$ means #1, #2, ....

Labtalk Script example:

merge_graph labeltext:=custom labelcustom:=h$n$;

Tip: Click the > button next to Dialog theme and choose Generate Script, executable Labtalk script will be created.

0

ORG-17426

Easier way to show/hide error bars and data labels from Object Manager

Easier way to show/hide error bars and data labels from Object Manager

0

ORG-17052

Enlarged graph using scale-in tool supports multiple overlapped layers

Enlarged graph using scale-in tool supports multiple overlapped layers

If layers are linked with 1:1 X axis and area, choose Scale In toolbar button and click in graph to create enlarged graph. Plots in all linked layers show in enlarged graph.

0

ORG-17707

Fit all layers to maximum available page area, including option for margins.

Margin control to fit all layers in graph into page area nicely.

Margin control to fit all layers in graph into page area nicely.

User stories:

• There are too much white space outside the layer. User wants to make the margin tigher.

• Some text, axis title, or layer shows in gray area, so they will not be printed/exported. Use this tool to fit them into page siie.

Image Modified

0

ORG-17617

Improve the assignment of columns to layers for multi-panel plots

Improve the assignment of columns to layers for multi-panel plots

When number of x cols <= number of layers, use x col as separator to plot into layers; When number of x cols > number of layers, pop up error message： When number of x cols > number of layers, pop up error message. Add X Column" to the "Group By" combo in Multiple Panels by Label tool dialog.

For example, if data is organized as XYYYXYY and user asks for a 2-panel plot, the first three Y columns will be plotted in layer 1, and the last two Y colums will be plotted in layer2.

0

ORG-16861

Integrate Gadget now supports marking of Fill Area under multiple curves

0

ORG-17823Integrate Gadget now supports marking of Fill Area under multiple curves

0

ORG-17823

Keep Aspect Ratio check box at Page level, to resize page

Keep Aspect Ratio check box at Page level, to resize page

This allows user to specify desired page width for publishing, and Origin can then scale the height accordingly to keep the aspect ratio, if this check box is checked.

All elements in the graph will be scaled such that they "appear" the same in the final graph in terms of relative dimensions such as font size etc. MAY NOT work fully yet for elements such as color scale, and for 3D graphs.

0

ORG-17749

New LT command to force all layers to have scale factor fixed but keep the look

New LT command to force all layers to have scale factor fixed but keep the look

Select menu Graph: Fix Scale Factors...to open dialog, and you will allow to set all layers to fixed scale factor value and maintain current look.

Image Removed

Image Added

LabTalk command is also available,

0

ORG-17840

Page size change to keep same look

Page size change to keep same look

Automatically scale all elements similar to the work with fix scale factor.

System variable @PSM controls the minimum change to trigger size update.  Set @psm=100, elements will not resize when changing page size.

0

ORG-14451

Rename Plot Groups instead of just using g1, g2, ... in Object Manager

Rename Plot Groups instead of just using g1, g2, ... in Object Manager

Right click g1, g2, ... node in Object Manager to give a meaningful group name. 

Such group name will show in

• Layer Contents dialog as tooltip

• Data menu

• Context menu when right clicking on graph

0

ORG-17402

Support for grouping and ungrouping of data plots in Object Manager

Support for grouping and ungrouping of data plots in Object Manager

In Object Manager,

• Right click group node, e.g. g1 to Ungroup.

• Right click a plot that doesn't belong to any group and Set as Group Begin. Then Origin will find all consecutive plots below it that have same plot type and group them.

0

ORG-17878

Support Tagging Sheet as Exclude from Plotting Dialog

Support Tagging Sheet as Exclude from Plotting Dialog

Some users have a lot of worksheets in project. And it's hard to select which sheet to plot.

In Origin 2018b, User can exclude some worksheets from showing in Plot Setup and Layer Contents dialogs by right clicking worksheet(s) and tag as "Exclude from Plotting Dialogs". 

Image Modified

0

ORG-17704

Support line style customization for vector graph

Support line style customization for vector graph

Support Line Style option for vectors in polar graph. You can customize the line style through Plot Detail or button.

0

ORG-17377

More controls added to Bubble Scale

Add Bubble Edge Thickness control

Add Bubble Edge Thickness in Layout tab.

0

ORG-17496

More flexible color scale object, including arbitrary color scale

More flexible color scale object, including arbitrary color scale

• show color scale for 2d plots colors.

• show an independent color scale.

0

ORG-17379

Scale factor for fill pattern entries in legend. Applies only to Geology patterns.

Scale factor for fill pattern entries in legend. Applies only to Geology patterns.

For example, code

 \L(1, PatternScale:p200) 

means set both X scale and Y scale of pattern to 2. 

0

ORG-17094

System variable to control double-click legend behavior

System variable to control double-click legend behavior

0

ORG-17078

Allow using English date format in Chinese/Japanese language setting

This will be useful for user who want to keep using English date format in C/J version

• rename current "Use English in Reports" into "User English in Reports and Graphs" in change Language dialog

• Add User English in Reports and Graphs checkbox in Numeric Format tab of tools options dialog

0

ORG-17633

Extra large icon view for workbooks and matrices in Project Explorer and Windows File Explorer

• Extra large icon view and Preview of workbook in Windows Explorer.

• In Project Explorer, Extra large icon view and tooltip.

0

ORG-17431

Fix Window Properties dialog, GetN Graph preview dialog, and Peak Analyzer dialog show incompletely in High DPI or low resolution

0

ORG-17947

Hide preview of OPJU with password protection

If user uses Tools: Password Protection to set password and then save the OPJU, preview of the OPJU will be hidden in Windows Explorer.

0

ORG-17615

Hotkey Ctrl+D to control show tooltip or not

0

ORG-17775

How to control which window display in File Explorer thumbnail and Preview

System Variables:

@SPM=1, PriorityMatrix

@SPM=2, PriorityWorksheet

@SPM=3, PriorityHolderImage

@SPM=4, PriorityMatImage

@SPM=5, PriorityHolderGraph

@SPM=6, PriorityGraphNotOpen

@SPM=7, PriorityGraph

where "Holder" refers to a Graph or Matrix added to a Workbook as a Sheet, and if a Matrix, View must be Image Mode (View: Image Mode).

The variable determines if a given window type will be elevated to "Must Use if Active".

The value of @SPM is stored in the Windows registry and will persist across Origin sessions until it is again changed.

0

ORG-17854

Improvements on Converting to Scientific Notation

Some improvements are made:

• Suppose Upper Threshold to convert to scientific notation is 6. In the past, 1000000 displays as 1000000, while 2000000 displays as 2E6. In Origin 2018b, 2000000 will still display as 2000000. Only values equal or bigger than 1E7 will convert to scientific notation.

• There was some round off error in the past. To see the problem: Suppose Lower Threshold Power to convert to scientific notation is -3. In the past if the axis is from 0.001 on 10, it will display as 0.001 fine. If axis is from 10 to 0.001 (axis decreases), 0.001 showed as 1E-3. Fixed in Origin 2018b now. Shows 0.001.

0

ORG-17202

Installed Apps can be updated automatically to make sure they are always the newest version

To make sure the installed Apps are always the newest version, user can turn on App Auto updating by setting @AUA = 1 in system variable dialog.

0

ORG-17804

Plot menu icon size can be scaled by a factor from 0.5 to 2

Use system variable @pps to set scale from 0.5 to 2, zoom in or out the Plot menu icon size

0

ORG-14705

Set Group Folder Location should not require run as admin

0

ORG-17929

Show both Long Name and Short Name in List and Icon Views in Project Explorer

In the past, if there was long name in window, only long name showed in List or Icon views of Project Explorer. In Origin 2018b, you can check Show Long and Short Names to both names. 

Image Modified

0

ORG-17378

Support for naming of custom colors

In Colors dialog which is used to create custom color, a Name box is added to allow user to give the color a name.

Image Modified

0

ORG-17419

OC: Added a parameter for specifying the title of dialog created by "okoc_folder_browser"

Added a new parameter "lpcszInitTitle" to the OC function okoc_folder_browser, and the new parameter is used to specify the title of dialog box, now the function is:

int okoc_folder_browser(LPCSTR lpcszInitDir, StringArray* saFolders, LPCSTR lpcszInitTitle)

The new parameter "lpcszInitTitle" is used to specify the title of dialog box, and its default value is NULL.

Example:

#include <Origin.h>
#include <okocUtils.h>
void folder_browser_ex1()
{
	vector<string> vsFolders;
	int nRet = okoc_folder_browser("C:\\test", &vsFolders,"Folder browser");
	printf("%d folders selected!\n", nRet);
	for ( int ii = 0; ii < nRet; ii++ )
			printf("Folder%d: %s\n", ii + 1, vsFolders[ii]);        
	return;
}

0

ORG-17369

OC: Better default for index in  GetParameterResults

The default value of second parameter of OC function GetParameterResults() was changed to 0.

0

ORG-17817

OC: function for Code Builder File Access

Added a new OC function:

BOOL CBFileOpen(LPCSTR lpcszFileName, LPCSTR lpcszSectionName=NULL, int nCntrl = CBF_OPEN);

lpcszFileName: File path and name.

lpcszSectionName: Specify a section you want to go.

nCntrl:

• CBF_OPEN: Open the file in Code Builder.

• CBF_TEST_IS_OPEN: Check if the file is opened in Code Builder.

0

ORG-17722

OC: Need better support for accessing embedded matrix via LabTalk and OriginC

Added a new OC function:

int Worksheet::IsHolderSheet(PageBase& pg = NULL);

Check if the Worksheet is embedded page.

0

ORG-16946

OC: Access to get and set LabTalk LT properties of Origin Objects

S2: Support accessing page properties by OC functions:Pagebase::SetProp() and Pagebase::GetProp(), for example:

void test_Graph_Set_and_Get_Properties()
{
	GraphPage gp;
	gp.Create("origin");
	gp.AddLayer("Test");
	double vv;
	gp.SetProp("active", 2);
	gp.GetProp("active", &vv);
	
	return;
}

0

ORG-17066

OC: Functions for  Batch Plotting

Added three oc functions:

1. int GraphPage::CanDuplicate(int nWith = CAN_DUP_WITH_ANY);
Suppose a graph is active, use this OC function to tell if this graph is possible to duplicate with new columns, sheets, books.

2. int GetDuplicateWithCols(StringArray &saItems, DataPlot &dataPlot = NULL, int nModifier = PMMT_IGNORE);
Assume a graph is active, use this OC function to get the list of columns which can be used to batch plot the graph.

3. int GetDuplicateWithBooks(StringArray &saItems, int nModifier = PMMT_OFFSET, int nMatchCol = MATCHCOLUMN_INDEX, int nMatchSheet = MATCHSHEET_INDEX);
Assume a graph is active, use this OC function to get the list of sheets or books which can be used to batch plot the graph. If nMatchSheet == MATCHSHEET_IGNORE then Range is Sheet, else Range is Book.