Graphing
New Graph Types
...
JIRA | SUMMARY | DESCRIPTION | DETAILS | ||
---|---|---|---|---|---|
ORG-22637 | Banded Rows in Worksheet | Alternate row column fill color | Click on upper-left corner of worksheet to turn on/off banded rows and set Banded Rows Color and show color on even or odd rows. Set Default Banded Row Colors. LabTalk property for worksheet:
| ||
ORG-22868 | Freeze Panes | Freeze rows and columns in worksheet | Freeze up to 10 beginning rows and columns to keep them visible while scrolling in worksheet
Ways to freeze/unfreeze
| ||
ORG-23417 | Protect Worksheet | Disable Editing of worksheet by adding a lock on sheet |
@WPO = 0 will lock up all except to change filled color etc. WPO_COLOR_AND_RESIZE = 0x01, | ||
ORG-25445 | Hide Sheets | Hide sheets in Workbook |
| ||
ORG-25593 | Stack Worksheets Improvements | Skip Hidden Sheets when stacking worksheets | Skip Hidden Sheets checkbox is added in Stack Worksheets dialog. | ||
ORG-14088 | Wrap rich text in worksheet | Allow wrapping rich text in worksheet cell | In previous versions, rich text in worksheet cells couldn’t be wrapped. It can be wrapped in Origin 2023 and is set as default. Ways to set as rich text and wrap/unwrap
Note: When double clicking text to edit (in-place edit mode), text will not be wrapped In Data cell area, if rich text and wrap are both checked, the text will be center aligned vertically. Adjust the height of the cell to see the effect. System variable @DCWRVC=1 Set @DCWRVC=0 so text is top aligned. | ||
ORG-25184 | Managing Sheets in Workbook Improvements | Make moving sheets in book easier. |
Drag them to another book to move them there.. Drag to workspace to move them to a new book. There is also Move to New Book or Selected Book in Navigate Worksheets dialog. Set system variable @SDMS=0 to roll back to old behavior so multi-sheet will not be allowed to drag.
| ||
ORG-25467 | Support Deselect Cells with Ctrl Key | Hold Ctrl key and click on those already selected cells to deselect them | Ctrl+Click the already selected cells will unselect the cells. Previously, there was no way to unselect already highlighted cells. | ||
ORG-25458 | Ctrl+Shift+Arrow keys for column/row selection | Support Ctrl+Shift+ Arrow key for whole row or column selection similar to Excel | Select a cell in worksheet and choose:
With Ctrl+Shift pressed, press right arrow first and then down arrow to select from current selection all the way to bottom-right corner. | ||
ORG-25349 | Alignment of URL Linked Cells | Alignment toolbar buttons are enabled for hyperlink cells | E.g. enter http://originlab.com homepage in a worksheet cell. Select the cell and set alignment on Format toolbar. It’s also supported in other url links, e.g.
| ||
ORG-19861 | More Merge by options for reduce columns | Support merge columns by median and also support output multiple quantities |
| ||
ORG-25402 | Intellisense/Auto complete improvements | Shows Auto Complete hint for the syntax of function argument. | When typing function formula in cell, Set Values dialog, or Command window, the auto complete hint will show the parameters of the function for ease of use. | ||
ORG-25395 | Autofill for Column Formula Improvements | Enumerate column part with Ctrl+Drag | Example 1: Enter B-B1 as formula in column E. Ctrl+Drag the F(x) cell corner to the right will fill C-C1, D-D1 Drag without holding Ctrl key, it will fill with B-B2, B-B3 (only incrementing number at the end) Example 2: In Book3, set column B’s F(x) as [book1]1!B+[book2]1!B, then Ctrl+Drag the tiny bottom-right corner of the F(x) cell to the right, it will column C, D, … 's formula as [book1]1!C+[book2]1!C, [book1]1!D+[book2]1!D, …. | ||
ORG-25475 | Show stats of column label row selection | On Status bar, show statistics when doing selection in column label area | Select cells in column label area, statistics such as count, average, sum, min, max, etc. show on Status bar. This used to only work for selections in data area. | ||
ORG-25548 | Improvement to Cell URL Link notation | New notations are added to execute LabTalk script, open external file. |
The
Also, support Alt + Double click to edit URL link in cell. | ||
ORG-20565 | Select Column… Improvements | Select columns by LabTalk Script | Support select/hide columns by running some conditions defined by LabTalk Script Examples: x refers to column, j refers to column index
Other minor improvements:
| ||
ORG-25549 | Worksheet cell insert Image from files supports direction | Right-click a worksheet cell and choose Insert Images from Files to open insertImag dialog, a new option Insert Direction is added to choose the direction to insert images. | Default Horizontal First will insert images row-wise, which works same as before. The Vertical First will insert images column-wise. | ||
ORG-25450 | Unstack columns Improvements | When unstacking columns, choose Custom option to specify where each grouping info. is output to | This feature is useful when there are multiple group columns. When unstacking, there is an option specify where each grouping info. should be output to. E.g. in the following example, age is output to User Defined Parameter (D1), while gender is output to Long Name (L) | ||
ORG-25616 | Move rows in worksheet | Mini toolbar to move row(s) up or down | Click mini toolbar buttons to move selected rows up or down LabTalk Script
Note: For data imported by data connector, choose Unlock Imported Data to temporarily unlock data so you can edit or move data. For analysis output sheets with locks, this will not be allowed either. You can set Recalculation mode to None to move data. But the result sheet will not be updated if input data is updated. | ||
ORG-25657 | Improvements on Cell Formula Cache | Improve the handle of cell fomula cache for better performance | Cell formula would be calculated from time to time in the previous versions, so if the source data is huge, it will be slow. There is a value cache for cell formula though, but it will be cleared after time limit is reached, which is control by @SCNT (time interval as milliseconds, default is 5000). So if your project is slow with cell formula, can set @SCNT to be a huge number to avoid recalucation. Since Origin 2023, cell formula will keep using cache result until data change, so it will not recalculate frequently. And then if you want to force clear the cache to force cell formula values to update, press F5 to refresh or set @SCNT = -1 to do it. | ||
ORG-25251 | Improvements autofill for cell formula with row index | Improve autofill behavior for cell formula with row index | For cell formula like “=A[1]”, “=sum(A)[1]“,
| ||
ORG-25719 | Insert Worksheet into Layout Improvements | Improvements when inserting workbook into layout window |
| ||
ORG-25628 | Copy Worksheet as HTML/EMF | Support copy whole sheet as HTML table or EMF image without any selection | New menu Edit: Copy: Copy Sheet as HTML/EMF is added for Worksheet. Also, Frame Thickness and Margin options are provided in Worksheet Properties: Print/Export page for copy as EMF usage. | ||
ORG-25634 | Worksheet Print, Export and Copy EMF Improvements | Improvements on Print/Export tab of Worksheet Properties |
|
...
JIRA | SUMMARY | DESCRIPTION | DETAILS |
---|---|---|---|
ORG-25249 | Better default setting when exporting GeoTIFF files | Default GEO information setting Export image dialog when exporting as TIF file type | Default settings of exporting GeoTIFF in Export image dialog from both matrix and image window:
|
ORG-25047 | Matrix Export to Image to better support GeoTIFF | There is an option in the dropdown list and default to it if we detect matrix has that info. | Besides geo info, Origin will check file extension as well: i.e. import *.jpg into image window, export dialog will default to jpg too. while matrix window does not now. |
ORG-25589 | Export Worksheet as Image Improvements | Ignore hidden rows, show border, etc. |
|
ORG-24994 | Preview button in Simple Graph Export dialog | Add preview button in expG2img dialog | Click the button will open the graph in internal preview tool.
It does not support for SVG. |
ORG-25269 | Raster Export Misinterprets Middle Colors of Colormap Temperature Palette | Higher default color depth on export | BMP, PSD, TGA: from 256 colors to be 24-bit color. PDF (Basic Object - Resolution): from 72 to be 96. |
ORG-25240 | Support export image, graph window as Video, GIF, TIFF |
|
|
ORG-25398 | Excel Export supports cell formatting | Add checkbox “Export Cell Formats” in expExcel dialog | The following formats are included:
Note: Excel and Origin has different syntax. For those not matching, it will not be supported. E.g. fraction in Origin will show as decimal in Excel. |
Import Export Issues with GeoTIFF in Image Window | Support export Multiframe TIF with GeoTIFF info | Export multiple frames tif file from image window will also export the GeoTIFF info like XY mapping. |
...
JIRA | SUMMARY | DESCRIPTION | DETAILS | ||
---|---|---|---|---|---|
ORG-25759 | Improved Script Window | Improved Script Window with Unicode Support, etc. |
| ||
ORG-25804 | Range notation Improvements | Window long name search to favor same folder | When using window long name in range, etc. definition, it will favor the same folder. If user later duplicate such folder, or save the folder as opju and append to other project, etc. the script will still work fine since window long name will be kept when duplicating folder, window or appending project. If using window short name, e.g. Book in definition, since short name must be unique in a project, the script/formula may not work well. Example 1: Column B in Book1’s calculated by interpolate A,B in Reference book, using new X in A of Book1. Duplicate the folder and modify reference book data, the calculation will update based on the Reference book in new folder. Example 2: In Book2’s B1 shows x value of vertical line in graph window with long name KZ LL Duplicate the folder. The graph window in new folder will have same long name. Therefor the var:// link refers vertical line in graph of same folder. Move vertical line. Press F5 to see update in workbook. | ||
ORG-25114 | Relative Position Improvement for Linked Objects | To connect a text object to another object with the relative position method, LabTalk support was added to specify which anchor, and a way to control anchor on text frame | When connecting a Text object to a Line Object in previous versions, we used Line.connect(Text,0,17,nTargetRefPt,35), nTargetRefPt=0. Now Origin supports value = 26~34 to specify the 9 anchor for text object LabTalk method to control anchor on text frame, text.anchorontextframe=0/1, when 0, Text Object dialog: Position tab: Anchor on Text Frame is clear, when 1, Text Object dialog: Position tab: Anchor on Text Frame is checked | ||
ORG-25024 | Provide a LabTalk local function to generate a Range variable | Predefine mkrng function in ORGSYS.CNF file | Note: This can only be used in cell formula, not column formula. Some functions don’t support using range string. e.g. Can’t use total(A$ + “!” + B$). In such cases, first call mkrng() to generate a range variable and then use it as an argument in a function. mkrange() is defined as follows in ORGSYS.CNF
| ||
ORG-25680 | Add a LabTalk method to add button in the gap area | A new method adds to wks object to add button in the gap area | Syntax: wks.AddButton(objName text label for button)
| ||
ORG-25733 | LabTalk command to convert non-SCN column formula | A new command is introduced to convert non-SCN column formula to use SCN notation | Usage: work -cof Run this command will convert non-SCN column formula in active sheet to use SCN notation, like wcol(2)-col(C) will become B-C. | ||
ORG-25366 | Axis Arrow control from LabTalk | Add LabTalk properties to control axis arrow and grid |
| ||
ORG-25307 | LT string object to load from text file | Add a method for LabTalk String object to load from text file | Syntax: int nRet = str.FromFile(fname$)
|
Python
JIRA | SUMMARY | DESCRIPTION | DETAILS | ||
---|---|---|---|---|---|
ORG-24891 | Certain Apps fails to work due to Python package version incompatibility. | Some Apps need the same Python Package, but one needs the latest version and another one needs an older version. If both versions are in the same folder, e.g. C:\ProgramData\OriginLab\PyPackage, it will cause compatibility issues. Origin now supports multiple PyPackage folders by setting the System Variable @PYP. | An example for installing two Apps needing the same Python Package— do the following:
If you want to use the SVM Classification app, need to set @PYP=0, and restart Origin | ||
ORG-25456 | Add python interface for LabTalk set command for plot | Add method |
| ||
ORG-25659 | Duplicated Column Long Name Issue in python to_df() | Improve the “head“ variable of to_df() function to support getting column short name |
| ||
Better error check on Python functions | 1.Import op.save() function to return true/false. 2.Added
|
|
...