3.7 Project Browser

Origin supports a Project Browser tool to navigate Workbooks, Graphs and Sheets. Also, you can search for the string or numeric data in the project, including to the metadata, data cells and graph object.

To open the Project Browser dialog:

Select Edit: Project Browser... in the Origin main menu.

In the Project Explorer, click the Search icon on top of Project Explorer.

In the Project Explorer, right-click and choose Project Browser in the context menu.

Press the shortcut key F3 in Origin project file.

Press Ctrl key and double-click on Origin gray area workspace

Note: Double-click on empty space of this dialog to close it.

Drop-Down List

Use the drop-down to specify the Windows/type of Windows/Sheets/Columns/Folder to list in the Project Browser.

Drop-Down List for the range

Use the drop-down to filter range of the Windows/Columns/Folders.

Entire Project	List the Windows/Columns/Folders in the entire project.
Folder and Subfolders	List the Windows/Columns/Folders in the active folder and its subfolders.
Folder	List the Windows/Columns/Folders only in the active folder.

Advanced Find button

Click the Advanced Find... button to open the Find dialog.

List Box

Customize the Columns for the list

Right click on the column header area of this list to view a context menu:

If it shows the Windows/Graph, you can customize the column headers as:

Column headers:

Dependents: Shows whether a window is independent or not.
View: Shows a window/sheets in normal displaying or minimized or hidden state.

If it shows the Books, you can customize the column headers as:

If it shows the Notes, you can customize the column headers as:

If it shows the Sheets, you can customize the column headers as:

If it shows the Columns, you can customize the column headers as:

If it shows the Folders, you can customize the column headers as:

Active the Window/Sheet/Column/Folder

Double-click on a Window in the list, it will go to the folder with this Window and the Window is activated.
Double-click on a Sheet in the list, it will go to the folder, active the Worksheet.
Double-click on a Column in the list, it will go to the folder, active the Worksheet with the Column, and highlight that Column.
Double-click on a folder in the list, it will go to the folder.

Context Menu of the Row

Show

Show the selected Windows/Columns when it is hided.

Hide

Hide the selected Windows/Columns.

Delete

Delete the selected Windows/Sheets/Columns/Folders.

Rename

Rename the Long Name of the Window/Sheet/Column

Name and Comments

Open the Rename dialog. For the Window/Column, you can customize the Short Name, Long Name and Comments for the selected window.

For the Sheet, you can customize the Name, Label, Notes and Tab Color

For the Folder, it will open the Folder Properties dialog.

Bulk Rename

Select multiple rows and right click to select Bulk Rename to open the dialog. You can rename the multiple Windows/Sheets/Columns/Folders by this dialog.

Change	For the windows, you can select to change Long Name or Short Name. For the columns, you can select to change Sheet Name or Sheet Label.
Replace Entire Name	Replace the entire name of the Windows/Sheets/Columns/Folders.
Find and Replace	Find the specified string in the name of the Windows/Sheets/Columns/Folders, then you can replace the specified string.
Find	When Find and Replace option is checked, this edit box will show in the dialog. Specify the string to be found. Note: Wildcard(?) can be used. abc: from abc till the end; *abc: from beginning until abc
Case Sensitive	Specify whether or not the search is case-sensitive. For example, when enabled searching for ABC returns ABC but not abc.
Replace with	If Replace Entire Name option is checked, specify new string to replace the entire name of the selected Windows/Sheets/Columns/Folders. If Replace Entire Name option is checked, specify new string to replace the found string. Note:%(), $(), %Y, %@F etc supported.

Samples of Bulk Rename with meta data:

Rename graphs Short Name as selection order:
Select the rows and right-click to open the Bulk Rename dialog, then enter Graph$(i) in the Replace With edit box.

Rename graphs Long Name be the corresponding worksheet name:
Select the rows and right-click to open the Bulk Rename dialog, then %(1, @WS) in in the Replace with edit box.

Rename all workbooks Long Name as current folder name:
Select the rows and right-click to open the Bulk Rename dialog, then enter %@F in in the Replace with edit box.

Change Formula

When select shows Columns in this dialog, choose right click on the row(s) in this dialog and right-click to selectChange Formula, you can change the formula for the selected Columns.

Replace Entire Formula	Replace the entire formula by the new formula entered in the Replace with edit box.
Find and Replace	Find the specified part in the formula, then use the new script entered in the Replace with edit box to replace it.
Find	Enter the specified part in the formula that you want to find.
Replace with	Enter the new formula (script) for replace the formula or the specified part in the formula.

Remove Operations

Set recalculation to None for the columns in the Worksheet (Remove the green lock). And the Recalc Mode will show None.
In this dialog, you can select multiple rows (multiple columns in the Worksheet) to remove their operation together.

Keep Dialog Open on Double-click

When double click on the row to active the Window/Sheet/Column/Folder, this Project Browser dialog keeps to open.

Hide Embedded

Hide the embedded windows in the list.

Hide Result Sheets

When show the Sheets in the Project Browser, check this option to hide the analysis result sheets.

Show Source Path

When showing the Books/ Sheets in the Project Browser and the Data Source in the column header, check this option to show the source path in Data Source.

You can use Ctrl+A key to select all rows in the list. In this dialog, Origin also supports to use Ctrl+Z and Ctrl+Y hotkey to undo and redo operation.

Edit Name by Hotkey

Select a Window(Book/Graph/Note)/ a Sheet/ a Column in the list and press the key F2, you can enter in-place edit state to edit the Name for it.

If it shows the columns of Long Name and Short Name, you just can edit the Long Name. If it only shows the columns of Short Name, you can edit the Short Name.

Search in Project Browse

Type string or numeric data in the box to search the Windows/Sheets/Columns/Folder listed in the Project Browser. Not only the name you can search the metadata of them.