Basic Matrix Book and Matrix Sheet Operations

The matrix book can contain between 1 and 255 sheets. If you delete all sheets, the matrix book is deleted. Sheets may be rearranged or renamed. Sheets can also be "torn out" and added to other matrix books or dropped onto an empty portion of the workspace to create a new matrix book. Each sheet can contain up to 75 million matrix columns. Each matrix column can have up to 900000 cells. Though, in practical terms, the maximum number will be likely be determined by available system resources.

Opening a new matrix book

To open a new matrix book:

1. Click the New Matrix button on the Standard toolbar.

To create a new matrix window from an existing matrix sheet:

1. Point to the matrix sheet tab, hold down the left mouse button and drag the matrix sheet to an empty portion of the Origin workspace.

Adding a sheet to the matrix book

To add a new sheet to the matrix book:

1. Right-click on a sheet tab and choose Insert, Add, or Duplicate Without Data.

To add an existing sheet to another matrix book:

1. Point to the matrix sheet tab, hold down the left mouse button and drag the sheet to the new matrix book.

Adding a matrix object to the matrix sheet

To add a new matrix object to the sheet:

1. Click on the object icon in the upper-right corner of the sheet and choose Add from the shortcut menu.

To insert a new matrix object ahead of the current matrix object:

1. Click on the object icon and choose Insert from the shortcut menu.

Modifying the appearance of matrices via the Properties dialog box

Some modification of the appearance of a matrix can be done using the Matrix Properties dialog, which can be opened by selecting Matrix: Set Properties from the Origin menu.

In this dialog, you can enter the width for the columns in the dialog and set the display format, digits and data type for the matrix data. Note that these settings are applied only to the active matrix object. To customize another matrix object in the same sheet, you can use the Previous button or the Next button to go to the object and then change the settings for it.

Modifying the appearance of matrices using the Format and Style toolbar buttons

Some matrix customizations can be made using certain Format and Style toolbar buttons. First, select that portion of the worksheet that you want to modify.

• To modify the font, point size, etc, use the buttons on the Format toolbar.
• To modify the font color, use the Font Color drop-down on the Style toolbar.
• To modify the cell or column color, use the Fill Color button on the Style toolbar.
• To add borders to (or remove borders from) the matrix cells, use the Borders button on the Style toolbar.

Saving matrix books

To save a matrix book, including its data, as a separate file:

1. With the matrix active, select File: Save Window As. This action opens the Save As dialog box. Matrix (*.ogm) is selected (by default) from the Save as type drop-down list. Type the file name in the File name text box and select the desired destination folder.

Matrix book templates

Matrix book customizations can be saved for later use by saving the customized window as a template file.

To find out how more matrix templates, see:

• Matrix Templates
• What is Saved with a Matrix Template?