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

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)

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'

Additional Information

External: Change Regional Language Format
Powered by Wolken Software