Data Handling
Column/Cell Value Formula
...
JIRA | SUMMARY | Description | DETAILS |
---|---|---|---|
Connect to NI TDMS file. | TDMS Connector App is not pre-installed with Origin. To install, click Data: Connect to File: Add New.... The App Center opens listing only Connector Apps. Click the Download and Install button beside TDMS Connector to install the App. |
| |
Connect to a Yokogawa WDF file. | Yokogawa WDF Connector App connects the Origin project to Yokogawa WDF files. Yokogawa WDF Connector App is not pre-installed with Origin. To install, click Data: Connect to File: Add New.... The App Center opens listing only Connector Apps. Click the Download and Install button beside Yokogawa WDF Connector to install the App. |
| |
Import tables in the pdf file. | Import PDF Tables app can be used to import tables in the pdf file. | Download Import PDF Tables app from the page and install the app. This app requires embedded Python in Origin, Media Feature Pack from Microsoft and Ghostscript. Operation:
| |
Better support of *.dat file with CSV Connector | Drag and drop of *.dat files will use CSV Connector if no Import filter is checked for Drag and drop of that file type. | Drag and drop *.dat file will use CSV Connector if no Import filter is checked for Drag and drop | |
Matlab DC supports opaque variable like date time in v6/v7 version files | Matlab DC supports opaque variable such as date, time, duration, or table in Matlab v6/v7 version files. | import opaque type variables: Date, Time, Duration, Table, etc. | |
new TDMS Connector | A new NI TDMS Connector has been created. | can contact us to get the app to try import NI TDMS file using connector app | |
import Bruker DQL/RAW files | A new DC DC to import Bruker DQL/RAW files has been created. | Add DIFFRAC Connector app to import Bruker DQL/RAW files | |
Data; Connect Multiple Files improvement | Data: Connect Multiple Files… a Source drop-down list has been added that allows for Specified Files or all Files in Specified Folder. | Menu Data: Connect Multiple Files… adds a Source drop-down list that allows Specified Files or all Files in Specified Folder. | |
Re-import Web DC should re-download the data | Re-import of Web DC now re-downloads the data based on the value of the @CFDT System Variable. |
| |
Move Legacy Import menu to bottom | Legacy Import from File menu moved to lower position in the Data menu. | Push the "Import from File..." menu item to be after the DC menu items under Data menu. | |
MATLAB connector supports Tables | MATLAB connector supports importing tables from .MAT files. | MATLAB Connector supports importing tables from .mat files. | |
CSV Connector allows Append Rows | CSV Connector now permits appending rows to columns. | Set | |
DC Connected Sheet remembers customized sheet name | A DC-connected worksheet now remembers a customized sheet name and does not change its name. | Added LT access User-Sheet-Name property This applies only to those connectors that are using the Tree framework, so besides Matlab, it will affect JSON, netCDF, etc. | |
Clone Import for Data Connector | Clone Import for Data Connector-based imports is now supported. | Support Clone Import for Data Connectors. | |
Yokogawa Binary WDF File Connector | New Yokogawa Binary WDF File DC has been created. |
| |
Import Menu Customization - Make it easier to find more Import Apps | Import Menu Customization via Customize… menu- makes it easier to find more DC Apps | Added "Customize..." item under “Data: Connect to File“ menu. | |
@ISC=0 did not work | @ISC=0 System Variable fixed and a wks level control “ | Added a wks level control “ default = 1 means it will follow @ISC, and if =0, it means do not resize column width after import. | |
ISO Date-Time Format More Issues | CSV Data Connector now supports Zulu Time (UTC). | CSV Connector Supports Zulu Time (UTC), the | |
Import entire folder fails – Beta6 | Failed to import entire folder when using Import Filter connector | Select Data->Connect Multiple Files menu and pick Import Filter as Data connector. Then specify a folder to import failed. |
Worksheet
JIRA | SUMMARY | Description | DETAILS |
---|---|---|---|
Mini toolbar for label rows in worksheet | Easier way to turn on rich text , insert user-parameter, hide label row, move up and down, etc. | When right click a label row, mini toolbar shows for quick access of some userful operations, such as turn on rich text so user can type superscript, subscript, greek letters, etc. | |
Data Display Format buttons on Column Mini toolbar | Use mini toolbar to customize date and time display or numeric digits | Add new mini toolbars for easily customize the number of digits, date, and time format. | |
Change Column (Cell) Format on Pasting Date Time Data | Check if copied data is date and time and paste accordingly |
| |
Better Handling of Time Data that Wrap Around Midnight | Mini toolbar buttons is added to handle date/time data what wrap around midnight | User sometimes has time data that missing day info. When plotting with such data as X range, the plot may jumps back to beginning of axis at midnight.
| |
Redo Worksheet Transpose Tool | There were many issues when using transposed data as input of further analysis. | In the past, output of wtranspose maybe problematic when directly use as anlaysis input. Now, this should not be a problem anymore. | |
Support Color Column in Worksheet | New column type is added to support HTML color code. User can save the colors in the column as a color list or palette for other uses. User can use it to color plots. | In Column Properties dialog, set column format as Color.
| |
Allow setting HTML color code in colors popup. | Entering HTML color code to create color | In Color Popup, add HTML edit box allowing copying/pasting HTML color code. | |
Support mask column based on Outlier by IQR | Support mask column based on Outlier by IQR | Select Column: Mask Cells by Condition… menu. Outliers by IQR is added in Condition dropdown | |
Alt+Enter for new line | We used to use Ctrl+Enter for new line. Changed to Alt+Enter to be consistent with other softwares | Use Alt+Enter for new line instead of old Ctrl+Enter. System variable @FCA =1 to roll back to old way. This also applies to adding mult-line text in graph and script window | |
Missing Value NANUM for numeric column which is not double(8) | When data type isn’t double(8), we used to show 0 as missing values. Now user can specify what value to show as missing value -- | When column format is set to Numeric and Data Type is set to other options e.g. Real(4) instead of the default Double(8), user can assign a custom value as missing value, such as: wks.col1.missing = 0/0 //turn the feature off This property is saved with the column. | |
Aligning on decimal character in column | Numbers are usally right aligned. Now you can align numbers by decimal points in a column | In Column Properties dialog, set Numeric Custom Display as e.g. .3? | |
Paste space separated text into one column in worksheet | By default, space separated text will be pasted into multiple columns. A context menu Paste (Keep Spaces) is added to pasted text into one column | It will paste space separated text in one column | |
Easier way to select highlighted columns in worksheet in Worksheet Query dialog | Newly added checkbox Check all Selected Columns Extract to quickly select highlighted columns only | By default when opening Worksheet Query dialog. All columns are checked so when extracting data, all columns will be extracted. A new context menu Check all Selected Columns Extract is added. Check it, only columns highlighted in worksheet will be checked and extracted. | |
paste report sheet table will set 1st row to long name | origin will set 1st row as long name when paste report sheet table since Origin2021, it will provide better format style look, also can easily change table style will mini toolbar. |
...