# Widget cell references

As an extension to widget references, widget cell references are used in formula to retrieve the content of certain widget cells. 

**Syntax**: <mark style="color:blue;">#pageName.widgetName!A1:B2</mark>

with

* <mark style="color:blue;">#pageName.widgetName</mark> - Reference of the widget (see previous chapter)
* <mark style="color:blue;">A1</mark> - starting cell of the cell range, with
  * <mark style="color:blue;">A</mark>: column 1, <mark style="color:blue;">B</mark>: column 2, ...
  * <mark style="color:blue;">1</mark>: row 1, <mark style="color:blue;">2</mark>: row 2, ...
* <mark style="color:blue;">B2</mark> - ending cell of the cell range

**Selecting cell references in the formula editor**

While holding down the CTRL key, either a reference to a widget or to cells of a table widget can be inserted into the formula editor:

<figure><img src="/files/HVkKnPk9RPSe9IYSgFZb" alt=""><figcaption></figcaption></figure>

#### Remarks

* Single cells can be referenced by a single click on an already selected widget reference (identified by a dotted frame).
* Multiple cells can be referenced by drag & drop across multiple cells.
* After clicking on a widget reference in the formula editor, the corresponding widget or widget cell(s) is marked by a dotted marching frame.&#x20;

**Examples**

* <mark style="color:blue;">#table1!B3</mark> - returns the cell content of column 2 and row 3, of the widget with name table1
* <mark style="color:blue;">#table1!E</mark> - returns the content of the whole column 5
* <mark style="color:blue;">#table1!3</mark> - returns the content of the whole row 3
* <mark style="color:blue;">#table1!B3:D5</mark> - returns the cell range between column 2, row 3 and column 4, row 5.
* <mark style="color:blue;">#H5</mark> - returns the content of column 8, row 5 of the widget that executes the current formula.
* <mark style="color:blue;">#me!H5</mark> - returns the same as the previous example


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.nedyx.com/version-1.52-preview/clearlines-functions/general-aspects/widget-cell-references.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.