Error Behavior
This allows you to set how the DDE server should send values if the underlying VisXpert variables enters in the Error State. This might happen for example, if the connected PLC is disconnected from the network. In that case you can chose the option that best fits your application:
- Replace Value: an user defined replacement text is sent. This is by default <ERROR>, but can be changed to any other string
- Send Null: Sending null, will cause Excel to display an Cell Value Null error on the Cell, and all Calculations referencing this cell will also result in Null values
- Last Value: The DDE Server does not inform excel about the Error, and just keeps sending the last valid value
Null Value Behavior
This allows you to set how the DDE server should send values if the underlying VisXpert variables return Null Values. This usually happens rarely, but may happen at the startup of Drivers, when they do not yet have data available. In that case you can chose the option that best fits your application:
- Replace Value: an user defined replacement text is sent. This is by default <ERROR>, but can be changed to any other string
- Send Null: Sending null, will cause Excel to display an Cell Value Null error on the Cell, and all Calculations referencing this cell will also result in Null values
Topics and Items
Topics and Items allow you to create “Aliases” to VisXpert variables, that can then be used in Excel. This is mainly be used if you have very long Variable Names, and you want to make them available under shortened names.
