Error - "ImportException at Spotfire.Dxp.Data: Font 'Calibri' does not support style 'Regular'. (HRESULT: 80131500)" when opening any *.xlsx file in a Spotfire client.

Error - "ImportException at Spotfire.Dxp.Data: Font 'Calibri' does not support style 'Regular'. (HRESULT: 80131500)" when opening any *.xlsx file in a Spotfire client.

book

Article ID: KB0082192

calendar_today

Updated On:

Products Versions
Spotfire Analyst All Versions

Description

Description:
The error message is received when trying to open a *.xlsx Excel file in Spotfire. If you manually convert the format of an existing Excel file from *xlsx to *.xls then, it opens without issues in the Spotfire client.
 
See the attached files (Filename:Error_Message.txt) and screenshot (Filename:Excel_Error.JPG) for the full error trace.

Symptoms:
Unsupported Excel workbook version. Make sure that the file is saved in Excel 97 format or newer.

TargetInvocationException at Spotfire.Dxp.Framework:Exception has been thrown by the target of an invocation. (HRESULT: 80131604)

Stack Trace:
   at Spotfire.Dxp.Framework.ApplicationModel.ProgressService.ExecuteWithProgressCancelable(String title, String description, ProgressOperation operation, Boolean showCancelButton)
   at Spotfire.Dxp.Framework.ApplicationModel.ProgressService.ExecuteWithProgress(String title, String description, ProgressOperation operation)
   at Spotfire.Dxp.Application.RichAnalysisApplication.Open(String filePath, DocumentOpenSettings documentOpenSettings)
   at Spotfire.Dxp.Forms.Application.FileUserActions.LoadFileCallback(LoadCallbackParameters parameters)
   at Spotfire.Dxp.Forms.Framework.Utilities.LoadFileHelper.LoadFile(LoadCallback callback, LoadCallbackParameters parameters, Form owningForm)

ImportException at Spotfire.Dxp.Data:
Failed to execute data source query. (HRESULT: 80131500)

Stack Trace:
   at Spotfire.Dxp.Data.DataSourceConnection.<GetPromptModels>d__2.MoveNext()
   at Spotfire.Dxp.Data.DataSource.Connect(IServiceProvider serviceProvider, DataSourcePromptMode promptMode, Boolean updateInternalState)
   at Spotfire.Dxp.Application.AnalysisApplication.<OpenDocumentFile>d__f.MoveNext()
   at Spotfire.Dxp.Forms.Application.FormsApplicationThread.<>c__DisplayClass5.<ExecutePromptingOperation>b__4()
   at Spotfire.Dxp.Forms.Application.FormsProgressService.ProgressThread.DoOperationLoop()

ImportException at Spotfire.Dxp.Data:
Font 'Calibri' does not support style 'Regular'. (HRESULT: 80131500)

Stack Trace:
   at Spotfire.Dxp.Data.Import.OutOfProcessDataSourceConnection.TryExecute(Action f)
   at Spotfire.Dxp.Data.Import.OutOfProcessDataSourceConnection.TryExecute[T](Func`1 f)
   at Spotfire.Dxp.Data.Import.OutOfProcessDataSourceConnection.<GetPromptModelsCore>d__24.MoveNext()
   at Spotfire.Dxp.Data.DataSourceConnection.<GetPromptModels>d__2.MoveNext()

ImportException at Spotfire.Dxp.Data:
Font 'Calibri' does not support style 'Regular'. (HRESULT: 80131500)

Stack Trace:
   at Spotfire.Dxp.Data.Import.Excel2DataSourceSettings.<OpenWorkbook>d__13`1.MoveNext()
   at Spotfire.Dxp.Data.Import.Excel2DataSourceSettings.<ApplyHeuristics>d__0`1.MoveNext()
   at Spotfire.Dxp.Data.Import.Excel2FileDataSource.<GetPromptModels>d__3`1.MoveNext()
   at Spotfire.Dxp.Data.Import.DataSourceOutOfProcessConnection.CallbackConnection.<GetPromptModelsCore>d__0.MoveNext()
   at Spotfire.Dxp.Data.Import.OutOfProcessDataSourceConnection.SubprocessImpl..ctor(String[] args)

.....Full Error Trace (Filename:Error_Message.txt) is attached.

Cause:
Calibri font has been corrupted.

Issue/Introduction

Error - "ImportException at Spotfire.Dxp.Data: Font 'Calibri' does not support style 'Regular'. (HRESULT: 80131500)" when opening any *.xlsx file in a Spotfire client.

Environment

All Supported Operating Systems

Resolution

1) Either install the Calibri font from another machine in which that particular .xlsx file is opening using Spotfire client and restart your machine.
2) You can also run Window updates to fix the issue.   
3) You can also purchase the desired font and then install it.

Attachments

Error - "ImportException at Spotfire.Dxp.Data: Font 'Calibri' does not support style 'Regular'. (HRESULT: 80131500)" when opening any *.xlsx file in a Spotfire client. get_app
Error - "ImportException at Spotfire.Dxp.Data: Font 'Calibri' does not support style 'Regular'. (HRESULT: 80131500)" when opening any *.xlsx file in a Spotfire client. get_app