Opening xlsx files in TIBCO Spotfire installed client fails with error '1 is not a supported code page'

Opening xlsx files in TIBCO Spotfire installed client fails with error '1 is not a supported code page'

book

Article ID: KB0080800

calendar_today

Updated On:

Products Versions
Spotfire Analyst 7.14 and lower

Description

On a Windows 10 machine, if the Region "Format" setting (Control Panel > Clock, Language and Region > Region) is set to European English, when opening .xlsx files in the TIBCO Spotfire installed client, the following error may be returned:

ImportException at Spotfire.Dxp.Data:
1 is not a supported code page.
Parameter name: codepage (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__4`1.MoveNext()
   at Spotfire.Dxp.Data.Import.DataSourceOutOfProcessConnection.CallbackConnection.<GetPromptModelsCore>d__0.MoveNext()
   at Spotfire.Dxp.Data.Import.OutOfProcessDataSourceConnection.SubprocessImpl..ctor(String[] args)
 
 
ArgumentException at mscorlib:
1 is not a supported code page.
Parameter name: codepage (HRESULT: 80070057)
 
Stack Trace:
   at System.Text.Encoding.GetEncoding(Int32 codepage)
   at Syncfusion.Compression.Zip.ZipArchiveItem.ReadCentralDirectoryData(Stream stream)
   at Syncfusion.Compression.Zip.ZipArchive.ReadCentralDirectoryData(Stream stream)
   at Syncfusion.Compression.Zip.ZipArchive.Open(Stream stream, Boolean closeStream)
   at Syncfusion.XlsIO.Implementation.XmlSerialization.FileDataHolder..ctor(WorkbookImpl book, Stream stream, String password)
   at Syncfusion.XlsIO.Implementation.WorkbookImpl.ParseExcel2007Stream(Stream stream, String password)
   at Syncfusion.XlsIO.Implementation.ApplicationImpl.CreateWorkbook(Object parent, Stream stream, ExcelVersion version, ExcelParseOptions options)
   at Syncfusion.XlsIO.Implementation.Collections.WorkbooksCollection.Open(Stream stream, ExcelVersion version, ExcelParseOptions options)
   at Syncfusion.XlsIO.Implementation.Collections.WorkbooksCollection.Open(Stream stream, ExcelOpenType openType)
   at Spotfire.Dxp.Data.Import.Excel2DataSourceSettings.<OpenWorkbook>d__13`1.MoveNext()

For example: If Format is set to English (Switzerland), then the exception above will be seen

Issue/Introduction

On a Windows 10 machine, when you try to open xlsx files in the TIBCO Spotfire installed client, it may fail with an error '1 is not a supported code page'

Environment

Microsoft Windows 10

Resolution

To resolve the issue, you can apply the following TIBCO Spotfire client hotfixes when using Spotfire version 7.11 or 7.14:
  • TS 7.11 HF-010
  • TS 7.14 HF-002
For other versions, to avoid the issue instead of setting language to European English, set the Format to either a Non-European English or the regional language. For example, if region is Switzerland, set Language to English(US) or German(Switzerland) instead of English(Switzerland)

Additional Information

External: Change Regional Language Format
Powered by Wolken Software