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 choose Center in Horizontal alignment dropdown list set alignment on Format toolbar.→ The hyperlink will be center aligned. 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. |
...