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
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
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.
