Row Functions Menu

The Row Functions Menu Contains all of the functions that affect rows (as opposed to columns) in any given grid. Because all of the grids work exactly the same, these functionalities are available anywhere you see the round red button on the bottom right of a grid.

To begin click the round red button on the lower right of the grid. The red button will turn green and the Grid Functions Toolbar will appear.

We will examine each of these functions below and explain what they do and why you would want to use them.

Max Lines

You can make columns wrap text when the text is very long which will take up just the width of the column and then cause the row to get larger to show all of the text in the cells. When you are dealing with a large amount of text (say the scope of work of a project), the rows can become so large that you can't easily scroll through them. In this case, you can set the maximum number of lines you want a row to be able to wrap. Items with more than the set maximum of lines will show the remainder of the text in a Tool Tip when you hover over the cell.  To change the number of maximum lines in wrapping, simply change the value from -1 (-1 means that there is no limit) to the number of lines you want (in general, 5 lines should be plenty to see what you need to see) and press enter. The default setting for this property is the no limit (-1).

Open

Size All Rows at Once

This option lets you size one row to a certain size and all of the other rows become that size as well.

Size Rows Based on Content

This option dynamically sizes the rows based on any columns having the wrap text option set.

Size Rows Individually

This option lets you size each row independently of every other row. This is useful when you have wrap text, and also have a Max Lines set to a number that doesn't allow you to see all of the text of a cell  without hovering and viewing it via the tool tip

Toggle Auto Size

This function turns the auto-sizing of rows (based on content) on or off.

Allow Row Freezing

Row Freezing allows you to "Pin" rows to the top or bottom of the grid so they stay in view and the rest of the rows scroll through the list of rows normally while the pinned rows stay fixed. You will see a pushpin appear on every row. Pushing the pushpin will Freeze the row at the top or bottom of the grid. Pushing the pushpin again will Un-Freeze it.