“Object reference not set to an instance of an object.” when trying to finalize Excel files in Trados 2017 SR1 14.1.6284.6

Hello!

I am asking the following for a freelancer we work with in Japan: he has Trados Studio 2017 SR1 14.1.6284.6 (the latest version, right?) and always get the “Object reference not set to an instance of an object.” (“Sdl.FileTypeSupport.Filters.Excel.PluginFilter.FlieWriterAndPreviewFileWriter.ExcelWriter” and “Generate Target Translations” in two rows) error when trying to finalize Excel files (xlsx) that he has imported and prepared from English to Swedish via “Batch Task -> Prepare -> Finish” and translated.

This happens both with xlsx files from clients that he has prepared “manually” (removed unnecessary rows and columns) and with xlsx files he creates himself containing only the word “Hi” in the top left cell as a test. I am able to finalize the same Excel files from our clients that I have prepared, imported and translated, using Trados 2017 14.0.5889.5 (the same problem happened to my colleague in Japan with that version, so he upgraded to 14.1.6284.6). I work on a Swedish PC, and he works on a Japan-bought PC with Windows 10. He has changed all Windows’s language settings to English, re-installed Office with English language settings and made sure that Office does not have Japanese “configuration” (the icons are different in the Japanese version) and has removed the Japanese Office language pack altogether. His Office version is: “Version 1707 (Build 8326.2096 Click-to-Run)” (should be the latest).

Any thoughts on how we can solve this problem? His error details are below. Unfortunately, I do not know how to “embed” these details in the post and have only copy-and-pasted.

Thank you in advance!

<SDLErrorDetails time="9/7/2017 11:42:10 AM">
  <ErrorMessage>Object reference not set to an instance of an object.</ErrorMessage>
  <Exception>
    <Type>System.NullReferenceException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</Type>
    <HelpLink />
    <Source>Sdl.FileTypeSupport.Filters.Excel</Source>
    <HResult>-2147467261</HResult>
    <StackTrace><![CDATA[   at Sdl.FileTypeSupport.Filters.Excel.FilterControllerFramework.OfficeController.UpdateDocumentFile(XsltArgumentList argsList, XslCompiledTransform xslTransform, XPathNavigator child)
   at Sdl.FileTypeSupport.Filters.Excel.FilterControllerFramework.OfficeController.IterateXsltFiles(XsltArgumentList argsList, FileMap rule, XPathNodeIterator iter, Boolean isUpdate, String targetFilePath)
   at Sdl.FileTypeSupport.Filters.Excel.FilterControllerFramework.OfficeController.IterateContentType(String xslFileNamesPath, Boolean isUpdate, String filePath, String filterStr, String targetFilePath, Boolean isCalledByRelsTableIteration)
   at Sdl.FileTypeSupport.Filters.Excel.FilterControllerFramework.OfficeController.serviceBackward()
   at Sdl.FileTypeSupport.Filters.Excel.PlugInFilter.FileParser.DocumentParser.Update()
   at Sdl.FileTypeSupport.Filters.Excel.PlugInFilter.FileParser.DocumentExtractImpl.Update(DocumentCollection srcCollection, String filename, String tgtFilePath)
   at Sdl.FileTypeSupport.Filters.Excel.PlugInFilter.FileWriterAndPreviewFileWriter.WriterImpl.EndOfInput()
   at Sdl.FileTypeSupport.Filters.Excel.PlugInFilter.FileWriterAndPreviewFileWriter.ExcelWriter.EndOfInput()
   at Sdl.FileTypeSupport.Framework.Integration.NativeWriterMessagesProxy.EndOfInput()
   at Sdl.FileTypeSupport.Framework.Integration.FileGenerator.CallEndOfInput()
   at Sdl.FileTypeSupport.Framework.Integration.FileGenerator.FileComplete()
   at Sdl.FileTypeSupport.Framework.BilingualApi.AbstractBilingualContentProcessor.FileComplete()
   at Sdl.FileTypeSupport.Framework.Integration.AbstractBilingualProcessorContainer.FileComplete()
   at Sdl.FileTypeSupport.Framework.Integration.MultiFileConverter.FileComplete()
   at Sdl.FileTypeSupport.Framework.BilingualApi.AbstractBilingualContentProcessor.FileComplete()
   at Sdl.FileTypeSupport.Framework.Integration.AbstractBilingualProcessorContainer.FileComplete()
   at Sdl.FileTypeSupport.Bilingual.SdlXliff.XliffFileReader.OnEndFile()
   at Sdl.FileTypeSupport.Bilingual.SdlXliff.SdlXliffFeeder.<ContinueScanning>b__2(ISdlXliffStreamContentHandler handler)
   at System.Collections.Generic.List`1.ForEach(Action`1 action)
   at Sdl.FileTypeSupport.Bilingual.SdlXliff.SdlXliffFeeder.ContinueScanning()
   at Sdl.FileTypeSupport.Bilingual.SdlXliff.XliffFileReader.ContinueParsing()
   at Sdl.FileTypeSupport.Bilingual.SdlXliff.XliffFileReader.ParseNext()
   at Sdl.FileTypeSupport.Framework.Integration.FileExtractor.ParseNext()
   at Sdl.FileTypeSupport.Framework.Integration.MultiFileConverter.ParseNext()
   at Sdl.FileTypeSupport.Framework.Integration.MultiFileConverter.Parse()
   at Sdl.ProjectApi.AutomaticTasks.NativeFileGenerator.GenerateFiles(ContentRestriction restriction, Boolean preview, Int32 filePercentBase, Int32 filePercentFactor)
   at Sdl.ProjectApi.AutomaticTasks.GenerateTargetTranslation.GenerateTargetTranslationTask.ProcessFile(IExecutingTaskFile executingTaskFile)
   at Sdl.ProjectApi.AutomaticTasks.AbstractFileLevelAutomaticTaskImplementation.Execute()]]></StackTrace>
  </Exception>
  <Environment>
    <ProductName>SDL Trados Studio</ProductName>
    <ProductVersion>14.0.0.0</ProductVersion>
    <EntryAssemblyFileVersion>14.1.6284.6</EntryAssemblyFileVersion>
    <OperatingSystem>Microsoft Windows 10 Home</OperatingSystem>
    <ServicePack>NULL</ServicePack>
    <OperatingSystemLanguage>1041</OperatingSystemLanguage>
    <CodePage>1252</CodePage>
    <LoggedOnUser>ASUS\OWNER</LoggedOnUser>
    <DotNetFrameWork>4.0.30319.42000</DotNetFrameWork>
    <ComputerName>ASUS</ComputerName>
    <ConnectedToNetwork>True</ConnectedToNetwork>
    <PhysicalMemory>4077288 MB</PhysicalMemory>
  </Environment>
</SDLErrorDetails>

Parents
  • Hi  

    Unknown said:
    Unfortunately, I do not know how to “embed” these details in the post and have only copy-and-pasted.

    You just add the xml error stack after saving it to your desktop.  I edited your post and you can see the forum automatically renders it nicely.

    Unknown said:
    Any thoughts on how we can solve this problem?

    I would start by making sure he is using the new XLSX filetype.  There are two for XLSX and I think the old one is the default.  So uncheck the old one and check the new one, then prepare the project again and pretranslate from the TM.

    That may do the trick.

    Regards

    Paul

    Paul Filkin | RWS Group

    ________________________
    Design your own training!

    You've done the courses and still need to go a little further, or still not clear? 
    Tell us what you need in our Community Solutions Hub

Reply
  • Hi  

    Unknown said:
    Unfortunately, I do not know how to “embed” these details in the post and have only copy-and-pasted.

    You just add the xml error stack after saving it to your desktop.  I edited your post and you can see the forum automatically renders it nicely.

    Unknown said:
    Any thoughts on how we can solve this problem?

    I would start by making sure he is using the new XLSX filetype.  There are two for XLSX and I think the old one is the default.  So uncheck the old one and check the new one, then prepare the project again and pretranslate from the TM.

    That may do the trick.

    Regards

    Paul

    Paul Filkin | RWS Group

    ________________________
    Design your own training!

    You've done the courses and still need to go a little further, or still not clear? 
    Tell us what you need in our Community Solutions Hub

Children