Back to SPR List Previous Next
Undefined and Missing are displayed the same way in spreadsheet
Minor Closed - Fixed Found:XS.01.12 09 SEP 2009 Fixed:XS.01.13 12 SEP 2009

DETAILS
 Undefined (system missing), and valid missing values are all displayed as
 NULL in the spreadsheet.

 This has been fixed to show the actual missing value or keyword BLANK in
 grey or the word "undefined" in light red. You can set a variable to BLANK
 (if blank is a valid missing value) by entering a string containing zero or
 more blanks and no other character. You cn set a variable to undefined by
 pressing the Nullify button or Ctrl+U.
EXAMPLE PROGRAM
WORKAROUND
Use PQL or Forms to see the missing values
Back to SPR List Previous Next