Excel export - operational boundaries

Inforiver offers a vast range of formatting and visualization options within the Matrix, some of which are not supported in Excel exports. The Inforiver features that cannot be captured in Excel exports have been listed in this section.

1. Formatting

1.1. Custom thousand and decimal separators can be enforced from display settings. These cannot be exported to Excel.

1.2. You cannot blend columns in exports.

1.3. Export to Excel does not support hatched formatting.

1.4. Signed row headers that are enabled by turning on the Sign in Headers display setting will not be captured.

2. Display and themes

2.1. Pinned rows are not supported in Excel.

2.2. You can enable Rails for ease of selection and formatting but cannot export them.

2.3. Row-level charts cannot be exported.

2.4. Themes cannot be applied for Excel exports.

2.5. Display padding is not supported in Excel.

3. Annotations

3.1. When you add notes, Inforiver automatically assigns a serial number. Excel exports cannot capture the number, only an indicator will be exported.

3.2. Comments cannot be exported. Excel only supports notes - hover over the note indicator to view the content.

3.3. You can enable marker mode for highlighting data points. Markers however cannot be captured in exports.

4. Data volume

4.1. A maximum of 30k records can be exported to Excel.

5. Visual measures and columns

5.1. Single/multi-select dropdowns are not supported in Excel.

Last updated