2.1.17 Folder and Window Properties Dialog


Window Properties dialog Folder Properties dialog
Window Properties dialog.png Folder Properties dialog.png


Contents

Open The Dialog

Folder Properties can be opened in any of the following ways:


Window Properties dialog could be open in any of the following ways:

Buttons

The following buttons are near the top of the dialog.

Button Previous.png

Button Next.png

The Previous and Next buttons allow you to switch from one folder/ window to another.

Button Window.png or Button Folder.png

The Window.../ Folder... button allows you to switch between the Properties dialog of the folder and windows under that folder.

Note: If there is no child window in the folder, the Window button is grayed out.

The Properties tab

Folder Properties dialog

Window Properties dialog

  • From version 2017, by default, Origin names and reorders column Short Names automatically and alphabetically when you insert or move a column within worksheet. Column Short Name can therefore be used as notation in column formula, such as A+1 instead of col(A)+1.
  • In this default mode, you are not allowed to change or edit a column Short Name. To enable editing, uncheck this checkbox or run page.xlcolname=0 in Script Window to turn off the Excel-like column Short Name restriction behavior. For more information, see FAQ-849 Can I turn off or selectively control use of spreadsheet cell notation in my workbooks?.
  • From Origin 2017, when Spreadsheet Cell Notation (SCN) was introduced, through Origin 2019, this icon Spreadsheet cell notation mode.png in the upper-left corner of the worksheet indicated that SCN was ON. Beginning with Origin 2019b, the icon is hidden, but SCN is still ON, by default, for new workbooks.
  • If you see this icon Button SCN OFF.png in a recent version, SCN is turned OFF in the workbook. You can verify this by checking the status of the Spreadsheet Cell Notation check box.
Worksheet unused cells are shaded.png

Note that shaded cells are always empty but unshaded cells may also be empty if they fall between cells that contain something -- even if that something is only a missing value symbol ("--").

You can control the degree of shading by changing the value of LabTalk System Variable @COR.

  • General File Import tools - most menu items under Data: Import from File
  • Data Connectors - access by Data: Connect to File/Connect to Web
  • Database Import - access by Data: From database

Note: for data imported from data connectors, this checkbox is equivalent to Exclude Imported When Saving menu item accessed by clicking the data connector icon.


The User Tree tab

User Tree tab of the Folder/ Window Properties dialog allows you to view and edit the user tree associated with the current folder/ window. It is not applicable to Notes windows.

To edit the user tree, right-click on a tree or a node and then select a desired command from the short-cut menu:

Rename Rename and re-label the current tree or node. Opens the Rename Tree Node dialog box. Note that the tree or node name only supports letters and numbers and the first character should be a letter.
Delete This command deletes the current tree or node.
Add Tree This command adds a user tree in this tab.
Add Node Select this to add a new node under the current tree or node. It opens the Add Tree Node dialog box and allows you to specify the name, label and type of the node. Available types include Numeric, Text and Branch.

Note: The values of some nodes are not editable, for example those added automatically on import. In these cases, values display in blue.

The Info tab

Info tab of the Folder/ Window Properties dialog shows the basic information of the current folder/ window, including type, size, contains, created date, location and the template of Graph/Workbook etc.

Info Tab.png

Note: You can add the sheet name and comments in Name and Notes dialog for Sheet.