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 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-25385 | Folder and Window Navigation | Added features to folder management to make it easier to navigate folders, Seesaw (toggle folders) and add shortcuts, etc. | Folder & Windows toolbar added
Menu and context menu added
|
ORG-25422 | Folder Notes | Add Notes for a folder in Project |
|
ORG-25498 | Mini toolbar on folders in Project Explorer | Mini toolbar on folders on top panel of Project Explorer for common manipulation | If not current folder, click either folder icon or folder name will show the mini toolbar. If it’s current folder, please click the folder icon part to show the mini toolbar. Click folder name will enter the rename folder mode. The three buttons on the Mini toolbar are:
There are context menu for these as well when right clicking a folder. |
ORG-25451 | Default toolbar layout in Origin 2023 |
| |
ORG-25253 | Arrange Window Improvements | More improvements are added such as include minimized window or exclude pinned window in window arrangement |
|
ORG-24746 | Improve Shortcuts to Show Pages from two folders | Add shortcuts of windows in another folder to activate the folder for comparison | Only windows in active folder show in workspace. To compare windows in active folder with some windows in other folder:
|
ORG-25423 | More on Improve Shortcuts 2023 | Window menu add new items for Shortcuts |
|
ORG-25343 | Restore window size | Window: Restore Window Size to restore window size and positions | After arranging window layout in a folder, a window may be temporarily or accidentally, moved or resized. To return to the previous arrangement, select Window: Restore Window Size: (Ctrl+Shift+Z) to restore the window to original size and positon. This also works to restore maximized or minimized child windows |
ORG-25372 | Tooltip on Menu Items | Show menu hint as tooltip and F1 for Help |
|
ORG-24937 | Easier hot keys to zoom and scale in | Hold Z key, right-click and drag to change the scale. | Hold Z key, right-click and drag to change the scale.
|
ORG-25453 | Easier way to save window to project folder | Provide <Project Folder> in built-in File Path list of Save Window As… dialog | In the Save Window As dialog, click File Path list. Two extra paths are added related to Project Path to easily save a window to same folder as the project file or a subfolder based in Project Explorer structure. |
ORG-25448 | Recent Project History | OriginProjHistory.txt in UFF | OriginProjHistory.txt created to list recent Origin files, e.g. project, graph, workbook, etc. System variable @MHF=1000 (default) : max number of entries to keep Set it to 0 or less to stop adding entries. |
ORG-25528 | Stop saving project as OPJ format | Only support saving as OPJU format | OPJ files saved in Origin 2023 will not be able to be opened in older versions that don’t support OPJU. So we removed saving OPJ files from the menu and OriginC. Old OPJ files can still be opened in 2023. |
ORG-25442 | Support decimal place customization of the result label of Graph Maker | Implemented support for adding number after * to set decimal places | |
ORG-25756 | Add App Tutorial web page for app | add context menu for user to open App Tutorial web page |
|
ORG-25432 | Change OPJU File Type to Origin Project | Change OPJU File Type to Origin Project | In Origin 2022b and earlier versions, File>Open dialog, users are not sure which file type is the Origin project file because currently OPJU files are listed as “Unicode Origin Graph”, which is confusing. In Origin 2023 version, opju and oggu show as “Origin Project”; while opj and ogg still shows as “Origin Graph“. |