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?
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
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
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.
Translate
<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>
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
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.
<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>
Hi Paul,
I was hoping you or Patrick had a chance to look at this.
Might you have any suggestions?
Thanks!
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 
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
