Viewing data in a spreadsheet

Working with a spreadsheet

The spreadsheet is composed of a toolbar, column headers, row headers, and cells.

Toolbar

The spreadsheet toolbar provides shortcuts for common actions taken while using the spreadsheet. All of these commands are also available in the Spreadsheet menu.

Insert

This button will insert a new row into the spreadsheet.

Delete

If you have selected a row (or multiple rows) by clicking in the row headers, this button will mark those rows to be deleted.

Set to Null

This button will set all the selected cells to be NULL.

Rollback

This button will rollback all changes you have made to the spreadsheet and restore the cells to the values as originally fetched from the database.

Commit

This button will cause MacSQL to commit all the changes you have made to the database.

Column Headers

The column headers can be clicked on to sort the data by that column. If you click on the same column again, the sort order will be reversed.

You can resize the width of each column by placing the mouse between two column headers and then dragging the column to the desired width.

You can reorder the columns by clicking and dragging the column header.

Row Headers

Each row is preceeded by a row number. This number is arbitrary and has no relationship to the actual data. You can select an entire row by clicking on the row number.

Cells

The actual data from the database is displayed in cells. You can edit a cell by double clicking on it. When finished, press Return. The spreadsheet only allows selecting entire rows. When you are done editing a cell, you can press tab to move to the next editable cell, or shift-tab to move to the previous editable cell.

Related topics

Editing spreadsheet values

Missing Columns

Some data types might not be supported in the spreadsheet, such as BLOBs. If a data type can not be displayed in the spreadsheet, it will not appear.