Failed to save target content: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index

I received this error message in Studio 2017 (latest updates installed) under Win 7, when saving a (fairly complex) Excel file as target. I've worked with previous versions of this file in the past and they did have their quirks, but this time I'm completely clueless. Here's the stack trace plus some related information of the error message:

Fullscreen errorstack2.xml Download

<Exception>
  <Type>System.ArgumentOutOfRangeException, mscorlib, Version=4.0.0.0,
  Culture=neutral, PublicKeyToken=b77a5c561934e089</Type>
  <ParamName>index</ParamName>
  <HelpLink />
  <Source>mscorlib</Source>
  <HResult>-2146233086</HResult>
  <StackTrace>
    <![CDATA[ at System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource) at System.Collections.Generic.List`1.get_Item(Int32 index) at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.Writer.Comments.AuthorsBuilder.ExtractCommentFromOriginalComments(String commentFile, CellReference commentCellReference) at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.Writer.Comments.AuthorsBuilder.BuildAuthors(String commentFile, IEnumerable`1 sortedAllCommentsCellReferences) at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.Writer.Comments.CommentsWriter.WriteAuthors(MarkupWriter markupWriter, String commentFile, IEnumerable`1 sortedAllCommentsCellReferences) at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.Writer.Comments.CommentsWriter.WriteTargetCommentFile(String commentFile, String targetFilePath) at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.Writer.Comments.CommentsWriter.WriteTargetCommentsFiles() at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.Writer.Comments.CommentsWriter.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.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>14.0.0.0</ProductVersion>
  <EntryAssemblyFileVersion>14.1.6413.8</EntryAssemblyFileVersion>
  <OperatingSystem>Microsoft Windows 7 Professional</OperatingSystem>
  <ServicePack>Service Pack 1</ServicePack>
  <OperatingSystemLanguage>1031</OperatingSystemLanguage>
  <CodePage>1252</CodePage>
</Environment>

Translate

Rate translation

Suggest better translation

Moderator UI

Thread Subject & Description
Failed to save target content: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index I received this error message in Studio 2017 (latest updates installed) under Win 7, when saving a (fairly complex) Excel file as target. I've worked with previous versions of this file in the past and they did have their quirks, but this time I'm completely clueless. Here's the stack trace plus some related information of the error message: https://community.rws.com< .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/errorstack2.xml?_=636495807455834120 https://community.rws.com/cfs-filesystemfile/__key/communityserver-discussions-components-files/90/errorstack2.xml?_=636495807455834120 <Exception> <Type>System.ArgumentOutOfRangeException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</Type> <ParamName>index</ParamName> <HelpLink /> <Source>mscorlib</Source> <HResult>-2146233086</HResult> <StackTrace> <![CDATA[ at System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource) at System.Collections.Generic.List`1.get_Item(Int32 index) at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.Writer.Comments.AuthorsBuilder.ExtractCommentFromOriginalComments(String commentFile, CellReference commentCellReference) at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.Writer.Comments.AuthorsBuilder.BuildAuthors(String commentFile, IEnumerable`1 sortedAllCommentsCellReferences) at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.Writer.Comments.CommentsWriter.WriteAuthors(MarkupWriter markupWriter, String commentFile, IEnumerable`1 sortedAllCommentsCellReferences) at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.Writer.Comments.CommentsWriter.WriteTargetCommentFile(String commentFile, String targetFilePath) at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.Writer.Comments.CommentsWriter.WriteTargetCommentsFiles() at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.Writer.Comments.CommentsWriter.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.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>14.0.0.0</ProductVersion> <EntryAssemblyFileVersion>14.1.6413.8</EntryAssemblyFileVersion> <OperatingSystem>Microsoft Windows 7 Professional</OperatingSystem> <ServicePack>Service Pack 1</ServicePack> <OperatingSystemLanguage>1031</OperatingSystemLanguage> <CodePage>1252</CodePage> </Environment> jQuery(function(j){ var fullScreenToggle = j('#fragment-1a84591e31034fac832d29ed8584666c1685389779_code-editor-fs'); var codeEditor = j('#fragment-1a84591e31034fac832d29ed8584666c1685389779_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

Parents

0 Paul over 7 years ago

Hi Mike Zobel ,

This article is old but it would be worth checking the resolutions to see if they help:

gateway.sdl.com/.../communityknowledge

Paul Filkin | 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 Mike Zobel over 7 years ago in reply to Paul

I checked all the relevant topics bot none of them helped to solve the issue at hand.
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 over 7 years ago in reply to Mike Zobel

Can you try creating a new project and Pre translate the file from your TM. If that doesn’t help send me the sdlxliff and the original source. I can try and resolve it. Use pfilkin@sdl.com

Paul Filkin | 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

Cancel

Share
Documentation Survey: help us offer you better documentation! Translate
0 Mike Zobel over 7 years ago in reply to Paul

Tried unsuccessfully and sent the files. Thanks again.
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 over 7 years ago in reply to Mike Zobel

Thanks Mike Zobel ,

I sent you your target file by email. Had to process the file again and perfect matched it to your sdlxliff. It then worked fine.

Regards

Paul

Paul Filkin | 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

Reply

0 Paul over 7 years ago in reply to Mike Zobel

Thanks Mike Zobel ,

I sent you your target file by email. Had to process the file again and perfect matched it to your sdlxliff. It then worked fine.

Regards

Paul

Paul Filkin | 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

Children

0 Mike Zobel over 7 years ago in reply to Paul

Thank you ever so much for this effort and enjoy the festive season.
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

Failed to save target content: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index