Each Spreadsheet.com worksheet starts with a sheet view. Unlike the traditional spreadsheet grid, Spreadsheet.com's sheet views allow you to include unique data types (like attachments), create many different views of the same data, and work collaboratively in real-time, in addition to the spreadsheet features you expect.
Sheet View Actions
All sheets, including brand new ones, include some key features to customize your view.
These features are all represented by buttons next to the sheet selector, and include:
- Filters - Filter down to the most important data for that view by selecting a column and some conditions to determine the data shown.
- Sorts - Rearrange the data in your view by applying a sort on a column.
- Hide Columns - Choose which columns your view will show.
- Row Height - Change the default height of your rows. This feature is especially useful when your rows include images, files, or long strings.
- Locking Views - Lock views so that other users cannot change the filters, sorts, hidden columns, and other aspects of the view configuration. When a view is locked, other users who are not Owners of the workbook still can open the filters, sorts, hide columns, and other view configuration dialogs, but they cannot make changes.
- View Permissions - Limit access to certain views in a worksheet to a specific group of people. Set views to Public for all who have access, Private to just a few users, or Private just to you.
- And the Rename, Copy, and Delete view actions.
Other Notable Sheet Features
The Table Header Row
Unlike traditional spreadsheets, in Spreadsheet.com, all rows in a worksheet are also considered records in a database table. The table header row determines where the table region starts—in other words, which rows should be treated as records. By default, the table region starts at the first row, and the column headers serve as the table header row. When you set a row as the table header row, all rows below that row are considered records. Filtering and sorting only affect rows below the table header row. Only rows below the table header row are shown in Kanban views. Meanwhile, all rows above the table header row are not considered records and instead are considered part of the header region. Rows in the header region are always shown and not affected by filtering and sorting.
The Primary Column
The primary column is used to refer to rows by name. The values of cells in the primary column determine the display name for rows in the table region. For example, when rows are shown as cards in Kanban views, the title of these cards is the cell value in the primary column for each row. Similarly, when you use the Related Row data type to establish relationships between rows in different worksheets, the name of related rows is determined by the cell value in the worksheet's primary column. You can always change which column is the primary column in a worksheet, but it's important to know that this change will apply to all views.
Sheet views allow you to edit your data just like a traditional spreadsheet. But unlike traditional spreadsheets, in Spreadsheet.com you can open your rows in a form view, allowing you to work with rows like records in a business application. To open a row, use the expand row button in the row header. This will open the row in a dialog where you will see input fields corresponding to each cell in the row. You will also see an activity channel allowing you to add and respond to comments on that row. The activity channel also shows the full change history for that row.
Our templates feature sheet views used in many unique ways and are a great place to start for ideas on how to best customize your sheet views.