TOP FEATURES SUMMARY - Beta3 (Feb 1st, 2019)
...
Feature | Brief Description | Where to find it in Origin |
---|---|---|
Data Connector |
|
Sample URLs for testing Data Connector with web-based file: CSV: This blog has an example. HTML: Try wikipedia page such as: JSON: This blog has an example of importing web-based JSON file. MATLAB: Works with older version .MAT files. Supports both worksheet and matrix as active window. NEW in Beta3: For importing from Web file: For ALL Data Connectors:
|
Exclude Imported Data when Saving Project |
|
Blog: http://blog.originlab.com/data-import/exclude-imported-data-when-saving-project |
HTML Reports |
| Blog: http://blog.originlab.com/publishing/creating-html-reports-and-documents-in-origin-2019b |
Copy-paste Folders | Copy an entire Origin Project Folder and paste it within the same project or even to another Origin session running on the same PC | Right-click on Folder/subfolder in Project Explorer and select Copy, or do CTRL-C and then CTRL-V |
Add Rugs to Axes | Add Rug marks to axes to indicate data density |
|
Export Worksheet or Book to Excel File.. | Added support for exporting multi-sheet workbook as a multi-sheet Excel file. | File: Export: Excel Sheets can be excluded by right-clicking on tab and selecting "Exclude from Excel Export" context menu |
Improved/Reorganized Menus | More first level menus to avoid too many entries in each menu
The Plot menu reorganization
Some context menu changes. |
...
JIRA | SUMMARY | DETAILS |
---|---|---|
Menu Reorganization |
| |
Copy and paste folder in Origin |
| |
Appending Projects Improvements | If user's projects
then when appending project files, and you choose No to not create subfolders for each project, all windows will be put together to current folder. | |
HTML Report in Notes Window |
HTML field codes:
| |
ORG-19156 | Recently Used Fonts | Recently used fonts show on the top of the font dropdown list |
Font control for Notes window | Change Font and Font Size from Format toolbar for Notes window. It applies to all Notes window. | |
Reset all dialog custom positions on new Origin session | There are cases user moved some dialog, script window, etc. to other location .e.g. another monitor and when restarting Origin, user couldn't find them. So in Origin 2019b, by default the dialog locations will reset. Set System variable @RDP=0 to go back to old behavior. | |
Copy cell and paste to a range | E.g. Select A1 cell and copy (Ctrl+C). Select B1-B3 and paste. B1 -B3 will be filled with A1 value. Select A1 - A3 cells and copy (Ctrl+C). Select B1-B6 and paste. B1-B3 will be filled with A1-A3, B4-B6 will be filled with A1-A3. Set System variable @CPNB=0 to roll back to old behavior. | |
Reorganization of some controls on Layer level of Plot Details dialog |
| |
Group Folder Sharing Improvements |
|
...
JIRA | SUMMARY | DETAILS |
---|---|---|
ORG-15634 | Data Connector | Connect to various data types (CSV, JSON, OPJ, OPJU, Matlab, Excel, HTML Table, XML, etc.) from web or on hard-drive. One workbook can only connect to one type of data. Different sheet can connect to different file of that type Icon is added to upper-left corner with context menu to change Data Source, select different node to import, exclude data when saving, reimport (Alt+4), etc. Exclude imported data when saving project to make project file size smaller. |
Export Worksheet or Book to Excel File | File: Export: Excel menu is added to export multi-sheet workbook as a multi-sheet Excel file.
| |
Replace existing data from Mulitple files Importing | New option 3 is added to System Variable @ISE. When setting it to 3 and import multiple data files to a book with multiple sheet, no matter the sheet is empty or not, data will be imported to existing sheet first. Suppose there is a workbook with 3 sheets. There are data in them. Select 3 other files to import with Multi-file Import mode as Start New Sheet. Data will be imported to the 3 sheets, instead of creating 3 more sheet and import them. |
Worksheet
JIRA | SUMMARY | DETAILS |
---|---|---|
Exclude Imported Data when Saving Project | With ANY data import (not just Data Connectors), user can opt to clear the imported data when saving project. This allows for your "analysis project" to stay small in size. You simply re-import the data, when needed, to perform further analysis
| |
ORG-18313 | Filtering Columns based on Column Label Row | Show worksheet in Column List View (Ctrl+W or View: Column List View). Then add filter to the column that corresponds to the column label row. You can then choose Ctrl+W to switch back to normal view. |
ORG-14328 | More ways to Split Columns | Split Columns by a reference column is supported in Origin 2019b. |
ORG-19072 | Use Column Short Name directly in Worksheet Query | To define conditions for worksheet query in the past, user had to use Alias in the past. In Origin 2019, user can directly use column short name. E.g. B="Drug 2" to find all rows with B column cell value "Drug 2" |
Extraction of worksheet rows by Random sampling | ||
Reduce by Group should support X as Corresponding X | When reduce data by group, user can set merge X by X of Min Y or Max Y. So the output X will be X value of found Y. | |
Support recalculation in Split Worksheet | Auto recalculation wasn't supported for Split Worksheet tool till Origin 2019b. |
...
JIRA | SUMMARY | DETAILS |
---|---|---|
Multi-sheet range support | This is supported in many tools that supports multi-sheet range. E.g. if user wants to do statistics in same range of data on multiple sheets, user can specify the input as [book1](1:5)!1[89]:17[95]
| |
Improvements on IF() and IFNA() functions |
| |
ORG-19284 | New Object is wbook but can be abbreviated as wbk |
...