Values tab
You can define the handling of invalid values of the source file using the Values tab of the configuration dialog.
Invalid value handling
| Setting | Description |
|---|---|
|
Import as void |
Invalid values will be imported as empty values. |
|
Import as void and mark as technical outlier |
Invalid values will be imported as empty values and marked as technical outliers. |
|
Import invalid value |
Invalid values will be imported without any changes. Floating-point handling settings apply. |
|
Import invalid value and mark as technical outlier |
Invalid values will be imported without any changes, but marked as technical outliers. Floating-point handling settings apply. |
|
Skip value |
Invalid values will be skipped. |
Floating point handling
| Setting | Description |
|---|---|
|
Import unmodified value |
Imports the original value. |
|
Round value to Microsoft Excel® precision |
Imports the rounded value (max. 15 significant digits). |
