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'

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 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) External: Change Regional Language Format

• https://www.sevenforums.com/tutorials/3527-format-regional-language-change.html