...
JIRA | SUMMARY | DESCRIPTION | DETAILS |
---|---|---|---|
ORG-22637 | Banded Rows or Columnsin 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. Labtalk property for worksheet: wks.band=0 - off, or 1 - on System variables to control banding color and if it shows on odd or even rows: @WBC - RGB color @WBE=0 -odd rows, or 1 - even rows |
ORG-22868 | Freeze Panes | Freeze rows and columns in worksheet | Freeze row or column makes navigating worksheet much easier.
|
ORG-23417 | Protect Worksheet | Disable Editing of worksheet by adding a lock on sheet |
Lock icon shows in front of sheet name
|
ORG-14088 | Worksheet Cell Rich Text and Wrapping | Wrap and Rich Text can be enabled at the same time | Enable context menu item Wrap text when Rich Text enabled, as well as in the Worksheet Properties on Format tab. When in-place editing Origin Text in cell with wrapping enabled, no wrapping allowed; however, it will wrap when drawn in cell for display (i.e. not for editing). Messages in Worksheet Properties dialog is corrected. |
ORG-25184 | Drag and drop multiple sheets | Move multiple sheets to another book or new book by drag and drop | Shift+select or Ctrl+click sheet tabs to select multiple sheets. Then
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 of disabling it. |
Reduce/Combine Duplicated Rows Improvement | Select multiple reference columns added | Select multiple reference columns for row sum. X-Function: wdeldup | |
ORG-25249 | Better default setting when export GeoTIFF files | We have a default geo information setting in the exporting matrix as image dialog when it is tif type. | default settings of exporting GeoTIFF, from both matrix and image window, are updated as following:
|
ORG-25395 | Autofill for Column Formula Improvements | Enumerate column part with Ctrl+drag | E.g. 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, …. |
...