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
rtw_4.5:cell_status_messages [2013/04/03 19:07]
cjaeger [Cell Status Messages]
rtw_4.5:cell_status_messages [2013/04/03 19:09]
cjaeger [Cell Status Messages]
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.