2020.2

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225.)
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.
l
Add : Add a new external library. Use the standard Open dialog to browse and open
the .js file.
l
Delete : Remove the currently selected library from the data mapping configuration.
l
Replace : Open a library and replace it with the contents of a different js file.
Page 328