Improve Worksheet Cell Substitution Format


Version: 2023

Type: Features

Category: Graphing

Subcategory: Text, Legend and Annotation

Jira: ORG-25512


When referring to a worksheet cell in a text label in a graph

  1. Keep display format in column label cell: e.g. using %([Book1]Sheet1,@WL, B[D1],W), to show user-defined parameter 1 in column B as label, where last argument is w, it will keep display format in that cell

  2. Keep display format when using plot index to specify a worksheet cell. E.g.

  • Using %(1, @WT, 2, 4, W) - 1st plot’s worksheet, 2nd column, 4th cell, using display format.

  • Using %(1@W,2,D1,W) or %(1@W,2,D”mean”,W) - 1st plot’s worksheet, 2nd column’s 1st user-defined parameter, or user-defined parameter row which is named “Hello”, where last argument is w. It will keep display format.