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 | 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-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 | Code Cleanup with regard to worksheet print/export settings |
|
...
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. |
...
JIRA | SUMMARY | DESCRIPTION | DETAILS |
---|---|---|---|
ORG-24718 | Normalize Columns Improvements | Normalize Columns within group defined in other columns | In the following example, there is an ID column with group information. Highlight column B and choose Analysis: Mathematics: Normalize Columns… menu Specify Column A (ID) as Group column and choose Normalize Methods as Divided by Max. See the output column C. Origin finds the max B within each group defined by A and divides each value in that group with the group max. |
ORG-22711 | Reduce XY by Group Improvements | Reduce XY data by group defined in other columns | Select Analysis: Data Manipulation: Reduce by Group… menu. By Reference Column(s) option is added in SubGroup method dropdown list. Choose it and specify Reference Columns Check Output Group Info. See the output columns from E to H. E&F are averages of XY data within each group. Column G&H are group information. |
ORG-25523 | Use Group, etc. variables from same sheet as input data | When changing parameters and change input data to be from a different sheet, group list, etc. should provide way to pick group from new sheet | E.g. do statistics on columns with data from Partial sheet with group information specified. To later modify the statistics to be based on another sheet e.g. All:
This applies to other analysis dialog with such list view box like Group List box here. |
ORG-25254 | Convert multiple Z data to matrix together | Convert XYZZZ columns into multiple matrix objects in same matrix sheet | Support multiple Z in Worksheet: Convert to Matrix: XYZ Gridding and Worksheet: Convert to Matrix: XYZ Log Gridding tools For XYZZZZ… data, highlight all of them and choose Worksheet: Convert to Matrix: XYZ Gridding… or XYZ Log Gridding…. The result will be put to different matrix objects in same matrix sheet for easy use in future graphs and analyses. Previously, these tools only accepted one set of XYZ. |
ORG-25242 | Output comments in Analysis | Result Sheet Column output changed in some types of analysis tools | Statistics-> Descriptive Statistics-> Discrete Frequency : Result Sheet Column should use Long Name directly if there is no duplicate long name in source sheet. Short Name + “Long Name” used to only show “Long Name“ For Smooth, rnormalize, vnormalize, interp1, interp1trace, interp1xy, reducedup, reducexy, reduce_ex : Create system variable @CLL(carry column label, default @ccl=1) to add label row Method to show method information. Long name/Units in result sheet is the long name/Units in the source sheet |
ORG-25415 | Statistics on Columns output improvements | Options to show histogram as count, relative frequency or density, improve axis title of graphs when doing statistics by group, and Dataset Identifier improvements in report sheet. |
2. Replace Y-axes titles from "Range" to LN (unit) for stats with group 3. Dataset ID label in DescStatsCurves1 sheet issue was fixed |
ORG-20760 | Improve Power result in Two Sample t-Test |
|
|
ORG-25645 | Input Improvements in Analysis tools | All Columns context menu in more tools to easily pick all columns as import and more… |
|
...