• State Suggested Answer
  • Replies 18 replies
  • Answers 5 answers
  • Subscribers 434 subscribers
  • Views 9359 views
  • Users 0 members are here
Options
Related

Object reference not set to an instance of an object when exporting excel files

Sandra Iannotti

Dear all,

 

I am using a Pro license of Studio and all of a sudden, I can no longer export target files when the working format is Excel.

I have Windows 10 and the Office 2016 - Studio 2015. It was working fine for the last year and a half but now I am getting this error. When I received the update message, I thought it would solve the problem but it didn't.

Regarding the file type settings, I tried everything: moving settings up and down, ticking/unticking.

Only saving in xls does work SOMETIMES. Still, this is not an option for me as I use Studio as a PM and cannot waste all this time saving files in a different format.

Can someone please advise?

Ps. I am not sure this can be related but I first experienced the issue after I installed the Plug in "xliff convert". I deactivated it though.

Best regards,

Sandra
Rate translation
×
Suggest better translation
×
Moderator UI
×
  • Get AI Suggestion
Parents
  • 0
    I'm wondering what "update message" which you thought would fix the issue are you talking about... last Studio 2015 update was released in June 2017...
  • 0 in reply to Evzen Polenka
    I wouldn't be able to tell you what update message it was in detail. But the system asked me to update, switched off and restarted. My colleague had an update on his 2017 on the same day.
  • 0 in reply to Sandra Iannotti

    Hello Sandra,

    I think the updates you are referring to are quite possibly one of the multitude of Windows 10 updates in the last couple of weeks.

    If you could post the full error stack please, this may help us identify the issue easier.

     

    I notice that you mentioned you are working as PM and as I cannot find a license under your name, would I be correct in assuming you are working for a company as an internal translator/PM (using a Studio 2015 Pro)?

    If so, you may want to ensure you have ADMIN rights, then delete the previously installed app and reset Studio-

    A very easy way of resetting your Studio application, would be via the following (free) app on the SDL App store- SDL Freshstart

    https://appstore.sdl.com/language/app/sdl-freshstart/876/ (again- admin rights are required).

    Lydia Simplicio | 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

  • 0 in reply to Lydia Simplicio

    Fullscreen sdlerror-2018420-16h41m28s.sdlerror.xml Download 
    <SDLErrorDetails time="20/04/2018 16:41:37">
  <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>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>BLOCKS\Sandra</LoggedOnUser>
    <DotNetFrameWork>4.0.30319.42000</DotNetFrameWork>
    <ComputerName>BLOCKS</ComputerName>
    <ConnectedToNetwork>True</ConnectedToNetwork>
    <PhysicalMemory>8217732 MB</PhysicalMemory>
  </Environment>
</SDLErrorDetails>
  • 0 in reply to Sandra Iannotti
    Hi Steven,

    I cannot say if it was a Windows update but I remember Trados restarting due to this update message. Anyway, it doesn't matter if we find a solution :)
    My license was indeed purchased by my company. If I use this Freshstart app, will all my settings go lost? That is the reason why I would prefer not to uninstall Studio.
    Thanks,
    Sandra
  • 0 in reply to Sandra Iannotti

    Hi there, I'm actually having exactly the same issue as Sandra:

    I'm using SDL Trados Studio 2015 on a Mac (osSierra 10.12.6) with Parallels Version 11.2.3 (32663) and Windows 10, MS Excel Version 11.2.3 (32663).

    For a few days now, Studio won't save any target file when it comes to translating MS Excel files. I always get the error message "Zieltext konnte nicht gespeichert werden. Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt." (Target text could not be saved. The object reference has not been set to an object instance).

    As a matter of fact I cannot translate any Excel files anymore. Maybe this is down to some recent update of Office not being compliant with Studio? My computer says I have the latest versions of Studio and MS Excel...

    Does anyone have a solution to this issue? It is pretty annoying, since I'm blocked for Excel for no clear reason.

    Update: I've run SDL FreshStart as suggested above, however, it still won't save my target XLS file...

    Thank you
Reply
  • 0 in reply to Sandra Iannotti

    Hi there, I'm actually having exactly the same issue as Sandra:

    I'm using SDL Trados Studio 2015 on a Mac (osSierra 10.12.6) with Parallels Version 11.2.3 (32663) and Windows 10, MS Excel Version 11.2.3 (32663).

    For a few days now, Studio won't save any target file when it comes to translating MS Excel files. I always get the error message "Zieltext konnte nicht gespeichert werden. Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt." (Target text could not be saved. The object reference has not been set to an object instance).

    As a matter of fact I cannot translate any Excel files anymore. Maybe this is down to some recent update of Office not being compliant with Studio? My computer says I have the latest versions of Studio and MS Excel...

    Does anyone have a solution to this issue? It is pretty annoying, since I'm blocked for Excel for no clear reason.

    Update: I've run SDL FreshStart as suggested above, however, it still won't save my target XLS file...

    Thank you
Children