# Convert Spreadsheet Files

Export has special configuration options that allow greater control over the conversion of spreadsheet files.

## Convert Hidden Text in Microsoft Excel Files

Normally, Export does not convert hidden text from a Microsoft Excel spreadsheet because it is assumed that the text should not be exposed. You can change this default behavior and convert text in hidden rows, columns, and sheets by adding the following lines to the `formats_e.ini` file:

    [Options]
    gethiddeninfo=1

## Convert Headers and Footers in Microsoft Excel 2003 Files

Normally, Export does not convert headers and footers from Microsoft Excel 2003 spreadsheets. You can change this default behavior and convert headers and footers by adding the following lines to the `formats_e.ini` file:

    [Options]
    ShowHeaderFooter=1

## Specify Date and Time Format on UNIX Systems

In Microsoft Excel you can choose to format dates and times according to the system locale. On Windows, KeyView uses the system locale settings to determine how these dates and times should be formatted. In other operating systems, KeyView uses the U.S. short date format (mm/dd/yyyy). You can change this by specifying the formats you wish to use in the `formats.ini` file.

To specify the system date and time format on UNIX systems

- In the `formats.ini` file, specify the following options:

  - `SysDateTime`. The format to use when a cell is formatted using the system format including both the date and the time.
  - `SysLongDate`. The format to use when a cell is formatted using the system long date format.
  - `SysShortDate`. The format to use when a cell is formatted using the system short date format.
  - `SysTime`. The format to use when a cell is formatted using the system time format.

  NOTE: These values cannot contain spaces.

  For example, if you specify `SysDateTime=%d/%m/%Y`, dates and times are extracted in the following format:

  28/02/2008

  The format arguments are the same as those for the `strftime()` function. Refer to the following web page for more information.

  See http://linux.die.net/man/3/strftime for more information.

## Convert Very Large Numbers in Spreadsheet Cells to Precision Numbers

You can export numbers in Microsoft Excel files and write them to the output without formatting. By default, numbers are exported in the format specified by the Excel file (for example, General, Currency, and Date). Spreadsheets might contain cells that have very large numbers in them. Excel displays the numbers in a scientific notation that rounds or truncates the numbers.

To export numbers without formatting, add the following options in the following lines to the `formats_e.ini` file:

    [Options]
    ignoredefnumformats=1

## Extract Microsoft Excel Formulas

Normally, the actual value of a formula is extracted from an Excel spreadsheet; the formula from which the value is derived is not included in the output. However, KeyView enables you to include the value as well as the formula in the output. For example, if Export is configured to extract the formula and the formula value, the output might look like this:

    245 = SUM(B21:B26)

The calculated value from the cell is `245`, and the formula from which the value is derived is `SUM(B21:B26)`.

NOTE: Depending on the complexity of the formulas, enabling formula extraction might result in slightly slower performance.

To set the extraction option for formulas, add the following lines to the `formats_e.ini` file:

    [Options]
    getformulastring=option

where `option` is one of the following:

Option | Description
--- | ---
`0` | Extract the formula value only. This is the default. Set this option if formula extraction is enabled, and you want to return to the default.
`1` | Extract the formula only.
`2` | Extract the formula and the formula value.

NOTE: If a function in a formula is not supported or is invalid, and option 1 or 2 is specified, only the calculated value is extracted. See the following table for a list of supported functions.

When formula extraction is enabled, Export can extract Microsoft Excel formulas containing the functions listed in the following table:

Supported Microsoft Excel Functions

`=ABS()` | `=ACOS()` | `=AND()` | `=AREAS()`
`=ASIN()` | `=ATAN2()` | `=ATAN2()` | `=AVERAGE()`
`=CELL()` | `=CHAR()` | `=CHOOSE()` | `=CLEAN()`
`=CODE()` | `=COLUMN()` | `=COLUMNS()` | `=CONCATENATE()`
`=COS()` | `=COUNT()` | `=COUNTA()` | `=DATE()`
`=DATEVALUE()` | `=DAVERAGE()` | `=DAY()` | `=DCOUNT()`
`=DDB()` | `=DMAX()` | `=DMIN()` | `=DOLLAR()`
`=DSTDEV()` | `=DSUM()` | `=DVAR()` | `=EXACT()`
`=EXP()` | `=FACT()` | `=FALSE()` | `=FIND()`
`=FIXED()` | `=FV()` | `=GROWTH()` | `=HLOOKUP()`
`=HOUR()` | `=ISBLANK()` | `=IF()` | `=INDEX()`
`=INDIRECT()` | `=INT()` | `=IPMT()` | `=IRR()`
`=ISERR()` | `=ISERROR()` | `=ISNA()` | `=ISNUMBER()`
`=ISREF()` | `=ISTEXT()` | `=LEFT()` | `=LEN()`
`=LINEST()` | `=LN()` | `=LOG()` | `=LOG10()`
`=LOGEST()` | `=LOOKUP()` | `=LOWER()` | `=MATCH()`
`=MAX()` | `=MDETERM()` | `=MID()` | `=MIN()`
`=MINUTE()` | `=MINVERSE()` | `=MIRR()` | `=MMULT()`
`=MOD()` | `=MONTH()` | `=N()` | `=NA()`
`=NOT()` | `=NOW()` | `=NPER()` | `=NPV()`
`=OFFSET()` | `=OR()` | `=PI()` | `=PMT()`
`=PPMT()` | `=PRODUCT()` | `=PROPER()` | `=PV()`
`=RATE()` | `=REPLACE()` | `=REPT()` | `=RIGHT()`
`=ROUND()` | `=ROUND()` | `=ROW()` | `=ROWS()`
`=SEARCH()` | `=SECOND()` | `=SIGN()` | `=SIN()`
`=SLN()` | `=SQRT()` | `=STDEV()` | `=SUBSTITUTE()`
`=SUM()` | `=SYD()` | `=T()` | `=TAN()`
`=TEXT()` | `=TIME()` | `=TIMEVALUE()` | `=TODAY()`
`=TRANSPOSE()` | `=TREND()` | `=TRIM()` | `=TRUE()`
`=TYPE()` | `=UPPER()` | `=VALUE()` | `=VAR()`
`=VLOOKUP()` | `=WEEKDAY()` | `=YEAR()` |

## Set Minimum Image Size

You can set a minimum size limit for the images to export from spreadsheet files. This option can improve performance for documents that have lots of very small images.

To set the minimum image size, add the following lines to the `formats_e.ini` file:

    [ss_flags]
    process_images_with_min_width=N
    process_images_with_min_height=M

where `N` and `M` are the minimum image dimensions, in pixels. For example:

    [ss_flags]
    process_images_with_min_width=150
    process_images_with_min_height=250

© Copyright 2006-2020 Micro Focus or one of its affiliates | Send documentation feedback Close Send documentation feedback To open the configured email client on this computer, open an email window. Otherwise, copy the information below to a mail client, and then send this email to swpdl.idoldocsfeedback@microfocus.com. We appreciate your feedback! Product: Topic Title: Help Topic: Feedback:

_FT_HTML5_bannerTitle.htm