Microsoft Excel file of over 18000 cells from Japanese to English. "Object not set to an instance of an object." Error

I am translating a large Microsoft Excel file of over 18000 cells from Japanese to English. When trying to view the Preview window or exporting the document to a finished Excel file in the target language, I am given an error "Object not set to an instance of an object." The file was originally *.xls and I converted it into an *.xlsx file thinking this was the problem, but this still resulted in the same error message. Any tips?

Translate

Rate translation

Suggest better translation

Moderator UI

Thread Subject & Description
Microsoft Excel file of over 18000 cells from Japanese to English. "Object not set to an instance of an object." Error I am translating a large Microsoft Excel file of over 18000 cells from Japanese to English. When trying to view the Preview window or exporting the document to a finished Excel file in the target language, I am given an error "Object not set to an instance of an object." The file was originally *.xls and I converted it into an *.xlsx file thinking this was the problem, but this still resulted in the same error message. Any tips?
Get AI Suggestion

AI Reply

Accept answer Reject Answer

Parents

0 Paul Filkin over 6 years ago

Don Cerny

Can you provide the details of the error message and not just the title?

Paul Filkin | RWS

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 Don Cerny over 6 years ago in reply to Paul Filkin

Paul,

Thanks for getting back to me so fast.

Of course.

I thought sending the error file itself might be the fastest way.

See attached.

Fullscreen sdlerror-2020223-18h15m26s.sdlerror.sdlerror.xml Download

<SDLErrorDetails time="2/23/2020 6:15:33 PM">
  <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.MicrosoftOffice.Core</Source>
    <HResult>-2147467261</HResult>
    <StackTrace><![CDATA[   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Core.Infrastructure.Extensions.EntityExtensions.CollectTagContent(IEnumerable`1 entities)
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.Writer.Cells.StringCellWriterRoute.GetOriginalSharedString(Int32 originalSharedStringIndex)
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.Writer.Cells.StringCellWriterRoute.GetNewSharedStringIndexForCellValue(String cellValue)
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.Writer.Cells.StringCellWriterRoute.Handle(Entity entity)
   at lambda_method(Closure , IMessage )
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Core.Infrastructure.Dispatcher.Publish(IMessage message)
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Core.Services.ParserService.Publish(Entity parsedEntity)
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Core.Services.ParserService.Parse()
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Core.Parser.DispatchingParserService.Process(Func`1 inputStreamFactory, IDispatcherConfiguration dispatcherConfiguration)
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.Writer.Worksheet.WorksheetParser.Process(String relativeSheetPath)
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.Writer.Worksheet.WorksheetWriter.Execute()
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.Writer.Archive.ArchiveWriter.WriteArchiveParts()
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.Writer.Archive.ArchiveWriter.Process(WriterInformation writerInformation)
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.XlsxWriter.FileComplete()
   at Sdl.FileTypeSupport.Framework.BilingualApi.AbstractBilingualContentProcessor.FileComplete()
   at Sdl.FileTypeSupport.Framework.BilingualApi.AbstractBilingualContentProcessor.FileComplete()
   at Sdl.FileTypeSupport.Framework.BilingualApi.AbstractBilingualContentProcessor.FileComplete()
   at Sdl.FileTypeSupport.Framework.BilingualApi.AbstractBilingualContentProcessor.FileComplete()
   at Sdl.FileTypeSupport.Framework.BilingualApi.AbstractBilingualContentProcessor.FileComplete()
   at Sdl.FileTypeSupport.Framework.BilingualApi.AbstractBilingualContentProcessor.FileComplete()
   at Sdl.FileTypeSupport.Framework.Integration.AbstractBilingualProcessorContainer.FileComplete()
   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.Previews.GeneratePreviewJobRequest.CreatePreviewFile(IFileTypeManager fm, IAbstractGenerator generator, GenerateType generateType)
   at Sdl.TranslationStudio.Editor.Previews.GeneratePreviewJobRequest.Execute(IJobExecutionContext context)
   at Sdl.Desktop.Platform.Implementation.Services.Job.<_worker_DoWork>b__47_0()
   at Sdl.Desktop.Logger.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>15.0.0.0</ProductVersion>
    <EntryAssemblyFileVersion>15.2.0.1041</EntryAssemblyFileVersion>
    <OperatingSystem>Microsoft Windows 10 Pro</OperatingSystem>
    <ServicePack>NULL</ServicePack>
    <OperatingSystemLanguage>1033</OperatingSystemLanguage>
    <CodePage>1252</CodePage>
    <LoggedOnUser>PERSEPHONE\Zachary</LoggedOnUser>
    <DotNetFrameWork>4.0.30319.42000</DotNetFrameWork>
    <ComputerName>PERSEPHONE</ComputerName>
    <ConnectedToNetwork>True</ConnectedToNetwork>
    <PhysicalMemory>8324652 MB</PhysicalMemory>
  </Environment>
</SDLErrorDetails>

Documentation Survey: help us offer you better documentation! Translate

0 Paul Filkin over 6 years ago in reply to Don Cerny

Thanks Don Cerny

I guess the first thing to do is make sure you're using the latest version of Studio. Can you update to the latest CU?

Then if this still occurs, and it may well do as this is quite a sizeable file, repost the new error stack and Patrik Mazanek might be able to shed some light on why this is happening.

Paul Filkin | RWS

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 Don Cerny over 6 years ago in reply to Paul Filkin

Paul, thanks for your help.

I updated to the latest version and still have issues viewing a preview and saving a target file.

Please see the attached error stack.

Fullscreen sdlerror-2020225-23h35m0s.sdlerror.xml Download

<SDLErrorDetails time="2/25/2020 11:35:03 PM">
  <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.MicrosoftOffice.Core</Source>
    <HResult>-2147467261</HResult>
    <StackTrace><![CDATA[   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Core.Infrastructure.Extensions.EntityExtensions.CollectTagContent(IEnumerable`1 entities)
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.Writer.Cells.StringCellWriterRoute.GetOriginalSharedString(Int32 originalSharedStringIndex)
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.Writer.Cells.StringCellWriterRoute.GetNewSharedStringIndexForCellValue(String cellValue)
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.Writer.Cells.StringCellWriterRoute.Handle(Entity entity)
   at lambda_method(Closure , IMessage )
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Core.Infrastructure.Dispatcher.Publish(IMessage message)
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Core.Services.ParserService.Publish(Entity parsedEntity)
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Core.Services.ParserService.Parse()
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Core.Parser.DispatchingParserService.Process(Func`1 inputStreamFactory, IDispatcherConfiguration dispatcherConfiguration)
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.Writer.Worksheet.WorksheetParser.Process(String relativeSheetPath)
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.Writer.Worksheet.WorksheetWriter.Execute()
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.Writer.Archive.ArchiveWriter.WriteArchiveParts()
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.Writer.Archive.ArchiveWriter.Process(WriterInformation writerInformation)
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.XlsxWriter.FileComplete()
   at Sdl.FileTypeSupport.Framework.BilingualApi.AbstractBilingualContentProcessor.FileComplete()
   at Sdl.FileTypeSupport.Framework.BilingualApi.AbstractBilingualContentProcessor.FileComplete()
   at Sdl.FileTypeSupport.Framework.BilingualApi.AbstractBilingualContentProcessor.FileComplete()
   at Sdl.FileTypeSupport.Framework.BilingualApi.AbstractBilingualContentProcessor.FileComplete()
   at Sdl.FileTypeSupport.Framework.BilingualApi.AbstractBilingualContentProcessor.FileComplete()
   at Sdl.FileTypeSupport.Framework.Integration.AbstractBilingualProcessorContainer.FileComplete()
   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.SaveMonolingualAsJobRequest.Execute(IJobExecutionContext context)
   at Sdl.Desktop.Platform.Implementation.Services.Job.<_worker_DoWork>b__47_0()
   at Sdl.Desktop.Logger.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>15.0.0.0</ProductVersion>
    <EntryAssemblyFileVersion>15.2.0.1041</EntryAssemblyFileVersion>
    <OperatingSystem>Microsoft Windows 10 Pro</OperatingSystem>
    <ServicePack>NULL</ServicePack>
    <OperatingSystemLanguage>1033</OperatingSystemLanguage>
    <CodePage>1252</CodePage>
    <LoggedOnUser>PERSEPHONE\Zachary</LoggedOnUser>
    <DotNetFrameWork>4.0.30319.42000</DotNetFrameWork>
    <ComputerName>PERSEPHONE</ComputerName>
    <ConnectedToNetwork>True</ConnectedToNetwork>
    <PhysicalMemory>8324652 MB</PhysicalMemory>
  </Environment>
</SDLErrorDetails>

Documentation Survey: help us offer you better documentation! Translate

Reply

0 Don Cerny over 6 years ago in reply to Paul Filkin

Paul, thanks for your help.

I updated to the latest version and still have issues viewing a preview and saving a target file.

Please see the attached error stack.

Fullscreen sdlerror-2020225-23h35m0s.sdlerror.xml Download

<SDLErrorDetails time="2/25/2020 11:35:03 PM">
  <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.MicrosoftOffice.Core</Source>
    <HResult>-2147467261</HResult>
    <StackTrace><![CDATA[   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Core.Infrastructure.Extensions.EntityExtensions.CollectTagContent(IEnumerable`1 entities)
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.Writer.Cells.StringCellWriterRoute.GetOriginalSharedString(Int32 originalSharedStringIndex)
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.Writer.Cells.StringCellWriterRoute.GetNewSharedStringIndexForCellValue(String cellValue)
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.Writer.Cells.StringCellWriterRoute.Handle(Entity entity)
   at lambda_method(Closure , IMessage )
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Core.Infrastructure.Dispatcher.Publish(IMessage message)
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Core.Services.ParserService.Publish(Entity parsedEntity)
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Core.Services.ParserService.Parse()
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Core.Parser.DispatchingParserService.Process(Func`1 inputStreamFactory, IDispatcherConfiguration dispatcherConfiguration)
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.Writer.Worksheet.WorksheetParser.Process(String relativeSheetPath)
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.Writer.Worksheet.WorksheetWriter.Execute()
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.Writer.Archive.ArchiveWriter.WriteArchiveParts()
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.Writer.Archive.ArchiveWriter.Process(WriterInformation writerInformation)
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.XlsxWriter.FileComplete()
   at Sdl.FileTypeSupport.Framework.BilingualApi.AbstractBilingualContentProcessor.FileComplete()
   at Sdl.FileTypeSupport.Framework.BilingualApi.AbstractBilingualContentProcessor.FileComplete()
   at Sdl.FileTypeSupport.Framework.BilingualApi.AbstractBilingualContentProcessor.FileComplete()
   at Sdl.FileTypeSupport.Framework.BilingualApi.AbstractBilingualContentProcessor.FileComplete()
   at Sdl.FileTypeSupport.Framework.BilingualApi.AbstractBilingualContentProcessor.FileComplete()
   at Sdl.FileTypeSupport.Framework.Integration.AbstractBilingualProcessorContainer.FileComplete()
   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.SaveMonolingualAsJobRequest.Execute(IJobExecutionContext context)
   at Sdl.Desktop.Platform.Implementation.Services.Job.<_worker_DoWork>b__47_0()
   at Sdl.Desktop.Logger.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>15.0.0.0</ProductVersion>
    <EntryAssemblyFileVersion>15.2.0.1041</EntryAssemblyFileVersion>
    <OperatingSystem>Microsoft Windows 10 Pro</OperatingSystem>
    <ServicePack>NULL</ServicePack>
    <OperatingSystemLanguage>1033</OperatingSystemLanguage>
    <CodePage>1252</CodePage>
    <LoggedOnUser>PERSEPHONE\Zachary</LoggedOnUser>
    <DotNetFrameWork>4.0.30319.42000</DotNetFrameWork>
    <ComputerName>PERSEPHONE</ComputerName>
    <ConnectedToNetwork>True</ConnectedToNetwork>
    <PhysicalMemory>8324652 MB</PhysicalMemory>
  </Environment>
</SDLErrorDetails>

Documentation Survey: help us offer you better documentation! Translate

Children

0 Don Cerny over 6 years ago in reply to Don Cerny

Hi Paul,

I was hoping you or Patrick had a chance to look at this.

Might you have any suggestions?

Thanks!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Share
Documentation Survey: help us offer you better documentation! Translate
0 Alison Field over 6 years ago in reply to Don Cerny

Hi Don Cerny

If you want someone specific to see your post, it is helpful to include an active link of their name in your post, either by copying and pasting it from their previous post header or by typing their name preceded by @ and with no spaces between...

Paul Filkin and Patrik Mazanek will now receive a notification that I've named them in this post and that you were trying to attract their attention.

All the best,

Ali
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Share
Documentation Survey: help us offer you better documentation! Translate
0 Don Cerny over 6 years ago in reply to Alison Field

Thank youAlison Field!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Share
Documentation Survey: help us offer you better documentation! Translate
0 Alison Field over 6 years ago in reply to Don Cerny

You're welcome Don Cerny
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Share
Documentation Survey: help us offer you better documentation! Translate
0 Paul Filkin over 6 years ago in reply to Don Cerny

Don Cerny

I'm afraid not. Are you able to send me your Excel file and I'll take a look? You can send it to pfilkin@sdl.com

Paul Filkin | RWS

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

Cancel

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

Trados Studio > 1. Trados Studio

Microsoft Excel file of over 18000 cells from Japanese to English. "Object not set to an instance of an object." Error