Using Named Cells

Using Named Cells

The add-in allows using named cells in the following scenarios:

  • Setting ribbon parameter values using named cell values.
  • Updating named cells using ribbon parameter values.
  • Updating named cells using query properties.
  • Using named cells to show and edit active row values (aka form fields).

To insert named cells, use the Formulas, Define Name Excel menu.

Use the sheet scope for most cases except the named cells for global parameters.

To insert form fields, you may use the Add Form Fields button of the Form Wizard.

Below is a specification for named cell names:

Named Cell NameDescription
A cell with a parameter nameThe add-in updates the cell with a changed ribbon parameter value and updates query parameters with the changed cell value.
A cell with a parameter name and
the __name suffix (two underscores)
The add-in updates the cell with a changed ribbon parameter value and updates query parameters with the changed cell value.
However, it uses names of values loaded using the ValidationList handlers.
A cell with a parameter name and
the global_ prefix
The add-in updates the cell with a changed ribbon parameter value and updates query parameters with the changed cell value.
The add-in applies these changes to all queries in the active workbook.
A cell with a parameter name and
the global_ prefix and
the __name suffix
The add-in updates the cell with a changed ribbon parameter value and updates query parameters with the changed cell value.
However, it uses names of values loaded using the ValidationList handlers.
The add-in applies these changes to all queries in the active workbook.
field_<ListObjectName>_<ColumnName>The add-in updates the cell with a value of the specified column and updates the cell of the table on the named cell changes.
This behavior allows using named cells as a current row field editor.
Once you have created such cell, the add-in tracks ListObject name changes and renames the cell automatically.
SaveToDB_ElapsedMillisecondsThe add-in updates the cell with the query execution time, in milliseconds.
SaveToDB_ConnectionStringThe add-in updates the cell with the query connection string.
SaveToDB_CommandTextThe add-in updates the cell with the query command text.
SaveToDB_ObjectThe add-in updates the cell with the query object name like <schema>.<name>.
SaveToDB_NameThe add-in updates the cell with the value of the TRANSLATED_NAME field if it has the value; otherwise, it has the same value as SaveToDB_Object*.
SaveToDB_DescThe add-in updates the cell with the value of the TRANSLATED_DESC field*.
SaveToDB_CommentThe add-in updates the cell with the value of the TRANSLATED_COMMENT field*.

* The add-in loads these values from the object translation configuration table or view.
The values depend on the data language selected using the Options dialog box.
You may use these named cells to make report headers and descriptions.

This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.