1.4. Working with Ranges

1.4.1. Demo

In addition to binding an individual cell to a DataHub point, you can also bind a range of cells. Here is a brief demo of how to work with ranges:

  1. Select a range and enter some data into it.

  2. In the Data Points tab, select or enter a DataHub point name. For the purposes of this demo, this should be a data point that you can write to.

  3. In the Direction option, choose Write.

  4. Click the Add button to create the binding. This will act as your data source.

  5. You can check your DataHub Data Browser to see that the point exists, that it is bound, and that it is a range.

  6. Now you can create a second range to receive the data. Ensure that you still have the same Selected Point, and then in the worksheet select a single cell.

  7. Click the the range size icon . The one-cell selection should expand to the size of the bound range.

  8. In the Direction option, choose Read.

  9. Click the Add button.

    The range should fill with the data from the data source range. Now, whenever any value in data source range changes, this range will update with the same values.

  10. What happens if the size of the source range gets changed? You can configure this target range to automatically change as well. While the target range is still selected, check the Auto box, and then click Update.

  11. Now change the size of the source range, say by adding an extra row. First, select the source range.

    [Note]

    An easy way to select a range is from the Bindings tab.

  12. With the source range selected, click the new range icon .

  13. Enter the coordinates for the new range, click OK.

  14. Click Update.

    The target range should update as well.