User Tools

  • Vistasource Document Library

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
rtw_4.5:cell_status_messages [2013/04/03 19:07]
cjaeger [Cell Status Messages]
rtw_4.5:cell_status_messages [2018/08/04 20:09] (current)
Line 4: Line 4:
 When a record has no value, the cell displays #N/A. When an Excel spreadsheet file containing RTD formulas is opened, all values display as #N/A until the cells are updated. ​ When a record has no value, the cell displays #N/A. When an Excel spreadsheet file containing RTD formulas is opened, all values display as #N/A until the cells are updated. ​
  
-The same is true for RTSHARE, when an Excel spreadsheet file containing RTS_SHARE and RTINSERT_SHARE formulas is opened, all values display as #N/A until the cells are updated.+In RTSHARE, when an Excel spreadsheet file containing RTS_SHARE and RTINSERT_SHARE formulas is opened, all values display as #N/A until the cells are updated.
    
 Similarly, when editing, copying or cutting/​pasting a real-time or RTSHARE formula, the cell displays #N/A until the value of the cell changes and the cell is updated. A cell which references a cell with a #N/A status message also displays #N/A. Similarly, when editing, copying or cutting/​pasting a real-time or RTSHARE formula, the cell displays #N/A until the value of the cell changes and the cell is updated. A cell which references a cell with a #N/A status message also displays #N/A.
    
-If a cell displays #VALUE!, the formula is incorrect. For instance, if an invalid field name is entered, the cell displays #VALUE! and the [[status window]] displays information from the data distribution system. When using RTSHARE, the  status window ​for RTSHARE Client ​displays information about the error. A cell also displays #VALUE! if it references another cell which contains #VALUE! or #N/A or no data.+If a cell displays #VALUE!, the formula is incorrect. For instance, if an invalid field name is entered, the cell displays #VALUE! and the [[status window]] displays information from the data distribution system. When using RTSHARE, the status window displays information about the error. A cell also displays #VALUE! if it references another cell which contains #VALUE! or #N/A or no data.