Black Box ICOMP, User Manual

Page: 25 / 92

Copyright (c) 2009 - 2012 Black Box Corporation
724-746-5500 | blackbox.com 25
Building a Connection
2.3.6.3 Advanced Settings
Specifying how Dates and Numbers are processed
For some applications, it is necessary to provide hints to the iCompel Data Engine (iDE) about how dates and
numbers are represented in the Microsoft
®
Excel
®
spreadsheet. This is particularly important when the file contains
values whose interpretation is language specific, or where the Time Zone component must be honored in times. For
example, the date
1/4/1972
could be interpreted as 1st of April (in the UK), or the 4th of January (if in the US).
The Processing setting specifies the culture setting used when processing dates and numbers.
Note this setting does not control how date and number values are presented by the media - see the following
section for more information.
If Data Processing is enabled, then a summary of the current setting will be shown the Text page.
Specifying how Dates and Numbers are written
To ensure the widest possible compatibility with media, by default, the iDE will write all numbers and dates in a
general, non-locale specific manner. However, in some instances, particularly when using the native iCOMPEL
features, it will be necessary to write data values using a specific locale representation.