• State Suggested Answer
  • Replies 18 replies
  • Answers 4 answers
  • Subscribers 435 subscribers
  • Views 7387 views
  • Users 0 members are here
Options
Related

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

Andreas Pajarinen

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!

Fullscreen 0361.errorstack.xml Download 
<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>
Rate translation
×
Suggest better translation
×
Moderator UI
×
  • Get AI Suggestion
Parents Reply
  • 0 in reply to Paul
    Thank you very much for this most helpful guidance, Paul.

    When doing exactly as instructed in this video, it works completely fine for him, both with checking the right file types and saving the file using F12. However, when opening the file in an existing project (with a TM) via "Add File" and then using "Batch Tasks" -> "Prepare", translating the word "Hi", and then using "Batch Tasks" -> "Finalize", the error message originally explained in this post appears.

    The error seems to be this: when translating the file with "Batch Tasks" -> "Prepare" in an existing project with TM, "Excel 2007 v 2.0.0.0" is shown as the tag in the bottom of the translation segment (in the translation window), but as "SpreadsheetML v. 1" for the same file when opening it as you showed. This is with all correct file types checked in "Options". In other words, he does not get the "SpreadsheetML v. 1" when adding the file to an existing project and open it with "Batch Tasks" -> "Prepare".

    Do you happen to know why this is? Sorry if this is confusion on our part.
Children