2020.1

l
Reload : Reload the currently selected Data Sample and any changes that have been
made to it.
l
Set as Active : Activates the selected Data Sample. The active data sample is shown
in the Data Viewer after it has gone through the Preprocessor step as well as the Input
Data and Boundary settings.
Editor Data Format
The Editor Data Format setting is only available for Excel files.
l
Date Display Format: This setting specifies how dates must be displayed in the Data
Viewer. Note that extracting a Date value will only be successful if the expected date
format matches the actual format of a date in the Data Viewer (see: "Data format settings"
on page223.)
l
Excel Default Format: Displays dates and times the way they would be displayed
in Excel, using the specified locale. For date formats without a locale, the US
English locale is used. (In the format selection dialog in Excel, these date formats
are marked with an asterisk.) Values can show a date, or a time, or both.
Connect always uses this setting when opening an Excel file.
l
Current Locale Settings:Shows dates and times as formatted by Windows using
the current Locale of the system on which Connect runs. All values are shown as a
date including a time.
l
ISO 8601 (UTC):Uses the ISO 8601 (UTC) format to display dates and times. All
values are shown as a date including a time, taking the time zone into account. Note
that when no time was specified with a date in the original file, the default time
(12.00 AM) is used and converted; this may influence the displayed date.
Note
Some Korean and Chinese date formats can't be parsed yet, and won't display
correctly with any of these settings.
External JS Libraries
Right-clicking in the box brings up a control menu, with the same options as are available
through the buttons on the right.
Page 324