Vous êtes ici: Help Topics > Customization > Calculation > Link Cell Action

Link Cell Action

Event Function: Link Cell

The Link cell action allows the user to link a cell to an existing labeled cell by providing a popup display of available cells. It could be used, for example, to navigate through a large document or to access the information from a set of financial statement notes, if the cells in the notes were labeled.

Using the Events tab

Under	Enter	Example
Run Skip Condition	If desired, enter skip conditions for the event. When the "Run Skip Condition" is evaluated to be true, the action is not performed.
Cell Number	Destination cell	Cellno()
Title	Title for the interface	"Note Link"
Identifier	Leave blank. This option is intended for internal use/ future expansion.
Label Group	Label group associated with the cell label (as defined in the Cell General settings.) If selected, only cells with the appropriate cell label group display in the dialog. Note: To display all the cells, regardless of their cell label, leave this option blank. To display only cells without cell labels, enter " ".
Sort by	Select either "Cell Label" or "Cell Value"	"Cell Label"
Order	Select either Descending or Ascending	"DESCENDING"
Close Automatically	Select this option to launch the calculation editor where a case-insensitive value of yes, true, or 1 will cause the linkage window to close after the first link is created. Otherwise the window will remain open until the X is clicked. Note: Yes or True must be enclosed in double-quotes as in the example. 1 does not require quotes.	"YES"

Syntax (if entering it in the Equation bar)

ACTION("Link cell",expr2,expr3,expr4,expr5)

Where

expr1 = entry under Cell Number

expr2 = entry under Title

expr3 = entry under Label Group

expr4 = entry under Sort by

expr5 = entry under Order

How the example will appear in the Equation bar

ACTION("Link cell",cellno(),"Note Link","Cell Label","DESCENDING")

Notes

Using the link function will override the existing contents of the cell, even if those contents are a calculation.
In the interface, all the labeled cells are displayed. There are three buttons in the top row (the UpLink button, the CellLabel button, and the CellValue button). The CellLabel and CellValue buttons servers as indicators for the underneath columns. They also provide a sorting functionality when they are clicked. The button with a triangle (upward/downward) on indicates the current sorted field (Ascending/Descending). The UpLink button (the top left most one in the interface) is used for user to jump to the destination cell in the text window.

Users can jump to a labeled cell in the text window by clicking the label field of the labeled cell in the interface.
The minimal number of the parameters required for this event is one ("Cell Number:").

Link Cell Action

Cookie Notice