Best Practice: Using named ranges when programming Symphony spreadsheets

As described in the wiki article for using the Symphony Spreadsheet container you can reference cells and cell ranges many different ways.  I would argue that you should use named ranges all of the time.  This will create a virtual reference to the spreadsheet so if the cell or ranges get moved or the editor inserts rows or columns before the range the reference in the CA container will not be broken.

You can create named ranges under the Create menu item:

ss-namedranges1

You then use the dialog to define/edit the named ranges:

ss-namedranges2

Once you create the named range it will then be available in the Composite Application Editor tooling as an entry in the drop down menu from the component toolbar:

ss-namedranges3

As you can see from the wiki article you can use various methods to reference cells but I would stick to named ranges:

Fields are essentially absolute or named cell ranges. The container supports the following formats:

  • $<Column>$<Row> – E.g. $A$1
  • $<Column>$<Row>:$<Column>$<Row> – E.g. $A$1:$B$10
  • !<Sheet name>$<Column>$<Row> – E.g. !MySheet$A$1
  • !<Sheet name>$<Column>$<Row>:$<Column>$<Row> – E.g. !MySheet$A$1:$B$10
  • #<Named range> – E.g. #MyRange

One thought on “Best Practice: Using named ranges when programming Symphony spreadsheets

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s