Spotfire Analyst: Resolving Missing First Column in Spotfire Analyst 14.0 Excel Exports

Description:

This article addresses a known issue in Spotfire 14.0 where the first column of a cross table is missing when exported to Excel, and provides solutions to resolve the problem.

Solution:

Identify the Issue:

When exporting a cross table from Spotfire 14.0 to Excel, the first column may be missing in the exported file.
Excel file displays data starting from Column B instead of Column A.

Temporary Workaround:

1. Open the exported Excel file.
2. Select the apparently missing column (Column A) using cursor keys.
3. Go to the Home tab in Excel.
4. Click on Format > Hide & Unhide > Unhide Columns.
5. The previously invisible first column should now be visible.

Permanent Fix:

Install Spotfire Hotfix HF-008 for version 14.0.
Steps to install the hotfix:

1. Log in to the Revvity Signals download site.
2. Navigate to the Spotfire Hotfixes section.
3. Download the appropriate hotfix for Spotfire 14.0.
4. Unzip the downloaded file.
5. Follow the installation instructions provided within the hotfix package.

Verifying the Fix:

After installing the hotfix, create a new cross table and export it to Excel.
Confirm that all columns, including the first one, are correctly exported.
Additional Notes:

Always keep Spotfire updated with the latest hotfixes to avoid similar issues.
If the problem persists after applying the hotfix, contact Revvity Signals Spotfire support for further assistance.

By following these steps, users can resolve the issue of missing first columns in Excel exports from Spotfire 14.0 and ensure all data is correctly exported.