User manual

Using@aGlancewithExcelA-14
SIMATIC PCS 7 OSx 4.1.1 @aGlance
Using the @aGlance C old LInk Functions (continued)
Null2Blank Excel reads a null text string as no change and does not
update the cell. For example, if the value of a TEXT tag changes from
“Boiler 1 On” to null (empty), then Excel sees no change and continues to
display “Boiler 1 On” in the cell. The
Null2Blank command replaces the null
value with blanks that Excel can read as a changed value. Whenever you
intend to request data from a tag attribute that is a text string for either a
hot or a cold link, run the
Null2Blank command from the Command function
first (Figure A-9).
 ServerName field — the prefix osx must appear in front of the OSx
station name.
 Command field — enter null2blank in this field.
 InputRange field — OSx does not use this field for this function.
 OutputRange field — OSx does not use this field for this function.
osxstation1
A
BC D E F
GH
1
2
3
4
5
6
7
8
9
10
@aGlance/IT Macro Tool
AAG Functions...
ServerName....
Command...
[InputRange]...
T
ry-it Paste-it Help Close
P
aste-it Cell...
Pause
[OutputRange]....
=$A$3
=“null2blank”
“Command”
11
12
Figure A-9 Null2Blank Function