Expand or Collapse Row for a GXL Formula

The Expand GL Row feature allows users to expand the balances for GXLs in a single row, or for all GXLs in the worksheet to individual account details. During the process, the system expands data and/or formulas in the columns to the right or left of the GXL formulas. This process is similar to the GXE formula, but expands into additional rows in the current worksheet, rather of to another designated workbook location. A maximum of 80 columns may be expanded. The detail rows will expand up or down, convert null segment values to an asterisk ( * ) or empty cell, and exclude zero balance accounts based on options in the user's Spreadsheet Server Settings

Note:

For the Expand GL Row to function properly, all parameters must be in a column, at least one account segment must be in the row, and a description field should follow the last account segment in the row, or a blank column should exist between the last account segment and the GXL formula.
Expand GL Row will not function if a GXL formula references a hardcoded segment value.
If the original GXL contains an @ field, the expanded rows display the appropriate account segment and associated @ field value; calculated amounts may be overstated and not foot to the original GXL-calculated amount, however.
If a SUM formula uses a range to reference cells to be totaled, this calculation will be incorrect when expanding GL rows, whether up or down.

Expand a Single GL Row

In the desired row to be expanded, select any cell containing a GXL formula, then, from the Spreadsheet Server Ribbon, select Expand GL Row, or, right-click and select Spreadsheet Server> Expand GL Row. The system adds additional rows to the spreadsheet, listing the account details of the selected GXL(s). The expanded data appears in blue italics.

Selected GXL Formulas

Expanded Row Results

Expand All GL Rows

Select any cell in the worksheet, then, from the Spreadsheet Server Ribbon, select Expand GL Row > Expand All GL Rows. The system adds additional rows to the spreadsheet, listing the account details for all GXLs in the worksheet. The expanded data appears in blue italics.

Collapse GL Rows for a Single Expansion

Select any cell in the expanded rows section, then, from the Spreadsheet Server Ribbon, select Collapse GL Row, or, right-click and select Spreadsheet Server > Collapse GL Row. The system removes the expanded GL rows in the selected section.

Collapse GL Rows for All Expansions in the Worksheet

Select any cell in the worksheet, then, from the Spreadsheet Server Ribbon, select Collapse GL Row > Collapse All GL Rows (Worksheet). The system removes all expanded GL rows in the worksheet.

Collapse GL Rows for All Expansions in the Workbook

Select any cell in the worksheet, then, from the Spreadsheet Server Ribbon, select Collapse GL Row > Collapse All GL Rows (Workbook). The system removes all expanded GL rows in the workbook.