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.

or

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

or

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

or

  • Press the shortcut key F3 in Origin project file.

or

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


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


Project Browser 01.png

Drop-Down List

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

Project Browser 02.png

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:
Project Browser 03.png

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:
Project Browser 07.png
  • If it shows the Notes, you can customize the column headers as:
Project Browser 08.png
  • If it shows the Sheets, you can customize the column headers as:
Project Browser 04.png
  • If it shows the Columns, you can customize the column headers as:
Project Browser 05.png
  • If it shows the Folders, you can customize the column headers as:
Project Browser 06.png

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.

Rename dialog.png


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

Rename dialog for Sheet.png


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.

Bulk Rename dialog.png
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:

  1. 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.
    Bulk Rename Sample1.png

  2. 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.
    Bulk Rename Sample2.png

  3. 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.
    Bulk Rename Sample3.png


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.

Change Column Formula.png
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.

PB Show Source Path.png


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.

Search in Project Browser.png

Case Sensitive button

Use this button to specify whether or not the search is case-sensitive.

Column to Search filter

Specify the columns (metadata) to be searched.

Enter Box

Specify the string or numeric data to be found. The wildcards (* and ?) are supported, such *abc to find a the end.