XDataLayout

Introduction

XDataLayout returns a value from the record associated with the formula cell in a named XLGL free-form data layout. The same formula can return different records at different positions in the layout. It was tested in refreshed Canadian and US Ready-to-Use Reports with XLGL version 1.0.9691.27981.

Syntax

=XDataLayout(layout, expression)

Parameters

layout [Required] — Name of the XLGL data layout in the calling workbook, not a worksheet or company name.

expression [Required] — Expression evaluated against the layout's underlying query. In the examples below, this is a query field name supplied in quotation marks. There are no optional parameters.

How it works

The function uses the calling cell's row and column to select a record in the named layout, then evaluates the expression for that record. It returns one value, not a table or spilled list. An unrelated cell outside the layout is not a reliable place to test it. The function uses the layout's existing dataset; evaluating the formula is not itself a fresh company download.

Examples

Canadian Trial Balance: =XDataLayout("Chart of Accounts1","Account_Name") returns the account name for the current layout row.

Canadian Income Statement by Projects: =XDataLayout("Projects1","Project_Name") returns the project name for the current record.

US Customer Standard Form: =XDataLayout("DataLayout2","Quantity") returns the quantity for the current invoice line.

The Canadian Trial Balance refresh populated 288 XDataLayout cells; the US Customer Standard Form refresh populated 30. Changing two field-name expressions in each test returned the corresponding account numbers or quantities, and the original formulas were restored. Use layout and field names defined in your own workbook: Canadian and US templates may have different names and schemas.

Troubleshooting

Blank or unexpected value: Check the exact layout name, query field, available records, the formula cell's position, and whether XLGL Refresh successfully populated the layout. Excel recalculation or an old nonblank value does not prove a current company refresh.

Unrecognized function: Check that XLGL is loaded in Excel. A missing layout or invalid expression can fail differently; exact Excel error displays for those cases were not live-verified. The inspected implementation can return an empty string for an absent usable dataset or record mapping.

References

Logicim XLGL worksheet functions

Logicim XLGL free-form layout