Object reference not set to an instance of an object, Studio 2015, XLSX

Hello there,

I'm currently afflicted by the perennial "Object reference not set to an instance of an object" problem during attempted conversion to an XLSX target file in Trados Studio 2015. I've scoured the forums and attempted all the suggested fixes and workarounds, but to no avail. Already missed a deadline because of this problem, so any help would be appreciated. Below is the error file. Thanks!

Fullscreen sdlerror-2018828-20h53m3s.sdlerror.xml Download

<SDLErrorDetails time="28/08/2018 20:53:11">
  <ErrorMessage>Failed to save target content: 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.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.Tmfc.TmfcReaderImpl.vv_Visit(TmfcReaderImpl* , FrameworkFileContainerField* field)
   at FrameworkFileContainerField.vv_AcceptFrameworkVisitor(FrameworkFileContainerField* , FrameworkFieldVisitor* visitor)
   at Sdl.FileTypeSupport.Bilingual.Tmfc.TmfcReaderImpl.vv_VisitStartEndField(TmfcReaderImpl* , StartEndField* startEnd)
   at Sdl.FileTypeSupport.Bilingual.Tmfc.TmfcReaderImpl.b_VisitNext(TmfcReaderImpl* )
   at Sdl.FileTypeSupport.Bilingual.Tmfc.TmfcReader.ParseNext()
   at Sdl.FileTypeSupport.Framework.Integration.FileExtractor.ParseNext()
   at Sdl.FileTypeSupport.Framework.Integration.MultiFileConverter.ParseNext()
   at Sdl.FileTypeSupport.Framework.Integration.MultiFileConverter.Parse()
   at Sdl.TranslationStudio.Editor.TranslationEditor.TranslatableDocument.SaveMonolingualAsJobRequest.Execute(IJobExecutionContext context)
   at Sdl.Desktop.Platform.Implementation.Services.Job.<_worker_DoWork>b__3()
   at Sdl.Desktop.Platform.Implementation.Services.Log.Resources(Object message, Action action)
   at Sdl.Desktop.Platform.Implementation.Services.Job._worker_DoWork(Object sender, DoWorkEventArgs e)
   at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
   at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)]]></StackTrace>
  </Exception>
  <Environment>
    <ProductName>SDL Trados Studio</ProductName>
    <ProductVersion>12.0.0.0</ProductVersion>
    <EntryAssemblyFileVersion>12.3.5281.10</EntryAssemblyFileVersion>
    <OperatingSystem>Microsoft Windows 10 Home</OperatingSystem>
    <ServicePack>NULL</ServicePack>
    <OperatingSystemLanguage>2057</OperatingSystemLanguage>
    <CodePage>1252</CodePage>
    <LoggedOnUser>DESKTOP-RGQUOPU\Kenny</LoggedOnUser>
    <DotNetFrameWork>4.0.30319.42000</DotNetFrameWork>
    <ComputerName>DESKTOP-RGQUOPU</ComputerName>
    <ConnectedToNetwork>True</ConnectedToNetwork>
    <PhysicalMemory>16617644 MB</PhysicalMemory>
  </Environment>
</SDLErrorDetails>

Translate

Rate translation

Suggest better translation

Moderator UI

Thread Subject & Description
Object reference not set to an instance of an object, Studio 2015, XLSX Hello there, I'm currently afflicted by the perennial "Object reference not set to an instance of an object" problem during attempted conversion to an XLSX target file in Trados Studio 2015. I've scoured the forums and attempted all the suggested fixes and workarounds, but to no avail. Already missed a deadline because of this problem, so any help would be appreciated. Below is the error file. Thanks! .code-editor .code-editor-heading{border-top:1px solid #eaeaeb;border-left:1px solid #eaeaeb;border-right:1px solid #eaeaeb;background-color:#fbfbfb;border-radius:3px 3px 0 0;font-size:12.6px;display:flex;justify-content:space-between;align-items:center;overflow:hidden}.code-editor .code-editor-heading .icon{width:32px;height:32px;display:block;overflow:hidden;text-indent:-3000em;background-repeat:no-repeat;background-size:80%;background-position:center}.code-editor .code-editor-heading .fs{background-image:url('https://community.rws.com/cfs-filesystemfile/__key/defaultwidgets/547b4cbb4efb4c3d83533f8f35fb4b7b-1a84591e31034fac832d29ed8584666c/fullscreen.svg?_=637923381702208350')}.code-editor .code-editor-heading .dl{background-image:url('https://community.rws.com/cfs-filesystemfile/__key/defaultwidgets/547b4cbb4efb4c3d83533f8f35fb4b7b-1a84591e31034fac832d29ed8584666c/download.svg?_=637923381702118315')}.code-editor .code-editor-heading .filename{padding:10px;display:block;white-space:nowrap;overflow:hidden;text-overflow:ellipsis}.code-editor .code-editor-heading a{color:#3e414a}.code-editor .code-editor-heading a:hover{color:teal} https://community.rws.com/# https://community.rws.com/cfs-filesystemfile/__key/communityserver-discussions-components-files/90/sdlerror_2D00_2018828_2D00_20h53m3s.sdlerror.xml?_=636711044597237671 https://community.rws.com/cfs-filesystemfile/__key/communityserver-discussions-components-files/90/sdlerror_2D00_2018828_2D00_20h53m3s.sdlerror.xml?_=636711044597237671 <SDLErrorDetails time="28/08/2018 20:53:11"> <ErrorMessage>Failed to save target content: 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.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.Tmfc.TmfcReaderImpl.vv_Visit(TmfcReaderImpl* , FrameworkFileContainerField* field) at FrameworkFileContainerField.vv_AcceptFrameworkVisitor(FrameworkFileContainerField* , FrameworkFieldVisitor* visitor) at Sdl.FileTypeSupport.Bilingual.Tmfc.TmfcReaderImpl.vv_VisitStartEndField(TmfcReaderImpl* , StartEndField* startEnd) at Sdl.FileTypeSupport.Bilingual.Tmfc.TmfcReaderImpl.b_VisitNext(TmfcReaderImpl* ) at Sdl.FileTypeSupport.Bilingual.Tmfc.TmfcReader.ParseNext() at Sdl.FileTypeSupport.Framework.Integration.FileExtractor.ParseNext() at Sdl.FileTypeSupport.Framework.Integration.MultiFileConverter.ParseNext() at Sdl.FileTypeSupport.Framework.Integration.MultiFileConverter.Parse() at Sdl.TranslationStudio.Editor.TranslationEditor.TranslatableDocument.SaveMonolingualAsJobRequest.Execute(IJobExecutionContext context) at Sdl.Desktop.Platform.Implementation.Services.Job.<_worker_DoWork>b__3() at Sdl.Desktop.Platform.Implementation.Services.Log.Resources(Object message, Action action) at Sdl.Desktop.Platform.Implementation.Services.Job._worker_DoWork(Object sender, DoWorkEventArgs e) at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e) at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)]]></StackTrace> </Exception> <Environment> <ProductName>SDL Trados Studio</ProductName> <ProductVersion>12.0.0.0</ProductVersion> <EntryAssemblyFileVersion>12.3.5281.10</EntryAssemblyFileVersion> <OperatingSystem>Microsoft Windows 10 Home</OperatingSystem> <ServicePack>NULL</ServicePack> <OperatingSystemLanguage>2057</OperatingSystemLanguage> <CodePage>1252</CodePage> <LoggedOnUser>DESKTOP-RGQUOPU\Kenny</LoggedOnUser> <DotNetFrameWork>4.0.30319.42000</DotNetFrameWork> <ComputerName>DESKTOP-RGQUOPU</ComputerName> <ConnectedToNetwork>True</ConnectedToNetwork> <PhysicalMemory>16617644 MB</PhysicalMemory> </Environment> </SDLErrorDetails> jQuery(function(j){ var fullScreenToggle = j('#fragment-1a84591e31034fac832d29ed8584666c87351211_code-editor-fs'); var codeEditor = j('#fragment-1a84591e31034fac832d29ed8584666c87351211_code-editor'); fullScreenToggle.on('click', function(){ if (codeEditor.evolutionCodeEditor('fullscreen')) { codeEditor.evolutionCodeEditor('fullscreen', false); } else { codeEditor.evolutionCodeEditor('fullscreen', true); } return false; }); });
Get AI Suggestion

AI Reply

Accept answer Reject Answer

0 Oana Nagy over 7 years ago

Hello Kenneth Hermse

It would be helpful if you could let us know exactly what you have tried so far.- Which workarounds etc.

Have you changed the order of the filters before creating/opening the excel file that needs to be translated?

The following article explains this error in much more detail and would seem to replicate your error stack preet much exactly.

https://gateway.rws.com/csm?id=kb_article_view&sysparm_article=KB0031066

Has changing the order helped?

If not- are you able to share the file? (swhale@sdl.com)

Oana Nagy | 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

Generated Image Alt-Text
[edited by: Trados AI at 2:08 PM (GMT 0) on 28 Feb 2024]
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel

Share
Documentation Survey: help us offer you better documentation! Translate
0 Kenneth Hermse over 7 years ago in reply to Oana Nagy

Hi Steven,

Many thanks for your response. I've tried changing the filter order (as you suggested); closing and reopening Trados; resetting window layout; repairing the Trados install; and saving the source file as XLS instead of XLSX.

I'd be happy to send you the file if that would be helpful to you.

Best,
Kenneth
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Share
Documentation Survey: help us offer you better documentation! Translate
0 Oana Nagy over 7 years ago in reply to Kenneth Hermse

Hello Kenneth Hermse ,

Please send the file over (swhale@sdl.com) or via dropbox if you prefer and will have a look for you.

Oana Nagy | 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
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel

Share
Documentation Survey: help us offer you better documentation! Translate
0 Kenneth Hermse over 7 years ago in reply to Oana Nagy

Thanks Steven. Just sent it to you.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Share
Documentation Survey: help us offer you better documentation! Translate
0 Oana Nagy over 7 years ago in reply to Kenneth Hermse

Hello Kenneth Hermse ,

I have just returned the file to you. Thank you.

Indeed I had the same issues in 2015 and could not save as- which generated the same error.
I also had issues even opening the file in the first place on my desktop.
However when I re-saved and renamed the file- this worked without a problem.

Incidentally, I tried the original file in 2017 and 2019 and both worked without a problem.

Hope this now works for you.

Oana Nagy | 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
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel

Share
Documentation Survey: help us offer you better documentation! Translate
0 Kenneth Hermse over 7 years ago in reply to Oana Nagy

Hello Steven,

Works a treat now. Strange, as I also tried renaming and resaving myself. Thanks for your help!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Reject Answer

Cancel

Share
Documentation Survey: help us offer you better documentation! Translate

Trados Studio > 1. Trados Studio

Object reference not set to an instance of an object, Studio 2015, XLSX