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
Advertisements

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

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.