This options enables the standardization of cell formats within Microsoft Excel files. KeyView formats any cell where a number has been entered according to the following rules.
These include:
Numbers are printed to the maximum length entered–that is, the full number put into the cell, without any rounding. Negative numbers are printed with a dash in front of them (as opposed to, for example, bracket form).
All text that is part of the format string is stripped, including currency symbols.
All dates are printed in full ISO-8601 format (that is YYYY-MM-DDTHH:MM:SS
). There are two exceptions to this rule:
"[h]"
, "[m]"
, or "[s]"
). In this case, the time is displayed as an interval, which is the number of days (where a day is defined as a period of 24 hours). The time is printed in the ISO-8601 time interval form, for example P1.234D
.Cases where the absolute value of the cell is less than 1.0
, and the date format contains only time components. In Excel, values between 0.0
and 1.0
correspond to the fictional date 1900-01-00
, and are used to express times without an associated date. For example:
Value | Date format | KeyView output |
---|---|---|
0.5
|
hh:mm:ss
|
12:00:00
|
0.5
|
dd hh
|
1900-01-00 12:00:00
|
1.5
|
hh:mm:ss
|
1900-01-01 12:00:00
|
1.5
|
dd hh
|
1900-01-01 12:00:00
|
You can enable this option by adding the following to the formats.ini
file:
[Options] StandardizeCellFormats=TRUE
Alternatively, iyou can enable this option programatically by passing KVFLT_STANDARDIZECELLFORMATS
to fpFilterConfig
.
|