Spreadsheet

The Spreadsheet editor is used to inspect geometry attributes.

../_images/editors_spreadsheet_interface.png

The Spreadsheet editor.

Header

Object Evaluation State

Display the data of an object at different states of its evaluation.

  • Evaluated:

    Display data from the object with all modifiers applied.

    Original:

    Display data from the original object without any modifiers applied.

    Viewer Node:

    Display data from the active Viewer node of the active object.

Breadcrumbs

The breadcrumbs show three key parts of the path the evaluated object takes before showing the information in the Main Region. In the order from left to right, the first item displayed is the Active object. The next two items are displayed when the Viewer node evaluation state is chosen. The first of these next items is the name of the Geometry Nodes modifier, the last item shown is the name of the active Viewer node.

Clicking the arrow between items hides the name of the active modifier.

Toggle Pin

Usually, the editor displays data from the active object. When an object is pinned, its data remains visible, even if another object becomes active.

Selected Only

This option is only available if the object is in Edit Mode. When checked, only data for the selected mesh elements is shown.

Main Region

The main view allows you to view the actual spreadsheet. Row indices and column names remain visible when scrolling down or to the side.

Note

Byte color attributes are displayed as scene linear floats. The actual byte values are displayed in a tooltip when hovering over the float values.

Data Set Region

With the Data Set region on the left you can choose which geometry component and geometry domain to view. For each attribute domain its size is displayed, for example the number of faces.

Mesh

Mesh component containing point, corner, face and edge data.

  • Vertex:

    Display attributes that are stored per vertex.

    Edge:

    Display attributes that are stored per edge.

    Face:

    Display attributes that are stored per face.

    Face Corner:

    Display attributes that are stored per face corner.

Curve

Display curve data which are the attributes on splines and control points.

  • Control Point:

    Display attributes that are stored per control point.

    Spline:

    Display attributes that are stored per spline.

Point Cloud

Point cloud component containing only point data.

  • Point:

    Display attributes that are stored per point.

Volume Grids

Display OpenVDB volume grid data, each grid will be represented with the Grid Name, the Data Type, and the Class. The class can be either of: Fog Volume, Level Set, or Unknown.

Instances

Display which objects and collections are instanced and their transforms.

Sidebar

The Sidebar contains row filters, which allow not including rows based on their value. The Add Row Filter button adds a new row filter.

Enabled

Each row filter can be enabled or disabled. Disabled row filters are grayed out, and aren’t used for filtering.

Column

Row filters hide rows based on the values of the selected column. The choice of name in the Column field determine which column is chosen. If the column is not currently available, the row filter will be grayed out.

Operation

For spreadsheet column types besides Boolean columns and name or “string” columns, it is possible to choose which operation to filter with.

  • Equal To:

    Display the row when data values are within the provided threshold from the row filter’s value.

    Greater Than:

    Display the row when data values are greater than the row filter’s value.

    Less Than:

    Display the row when data values are less than the row filter’s value.

Threshold

The distance from the row filter’s value for the equality operation.

Status Bar

The status bar shows how many rows and columns there are and how many have been filtered out.