Studio 2009: "Input string was not in a correct format" when opening xls file
Thread poster: Marcel Hlbočan

Marcel Hlbočan
Local time: 10:13
Slovak to English
+ ...
Aug 27, 2012

Using Studio 2009 SP3 I get the following error message: "Input string was not in a correct format" when opening an xls file. The file seems fairly simple, no formulas, no links or references, just 12 sheets of written text in formatted cells. I tried replacing some suspicious characters like the ½ symbol with 1/2, saving the file in xlxs format and copying all worksheets to a new file - still getting the same error. Does anyone have an idea what is preventing Trados from opening this file?

Any solutions appreciated!!

Regards,
Marcel


 

Marcel Hlbočan
Local time: 10:13
Slovak to English
+ ...
TOPIC STARTER
Once again... Aug 30, 2012

Really no one with the same issue?

 

SDL Community  Identity Verified
United Kingdom
Local time: 10:13
English
Not seen it... Aug 30, 2012

... but if you can share the file I'll happily take a look?

Regards

Paul
pfilkin@sdl.com


 

Sasa Kalcik  Identity Verified
Croatia
Local time: 10:13
Member (2010)
French to Croatian
+ ...
Any solution? Feb 2, 2014

If you came up with a solution it would be great to know what it was?

I have same situation here right now. Only I use Trados Studio 2011.

Many thanks!

Sasa

[Edited at 2014-02-02 11:33 GMT]


 

Marcel Hlbočan
Local time: 10:13
Slovak to English
+ ...
TOPIC STARTER
Use TagEditor Feb 2, 2014

I did not resolve the issue in Studio, but found a workaround - use TagEditor to convert the file to a bilingual ttx file and then translate it in Studio. Finally, save the target Excel file using TagEditor once again. This helped most of the time, sometimes it worked with xls, sometimes I had to convert to xlsx in Excel first and then to ttx in TagEditor.
If all fails write to Trados support they will try to convert the file for you.
Or get Studio 2014 - for me this version opened everything so far. I am just a bit worried that once the new MS Office comes out, more issues will crop up - as usual.

Hope this helps.
Marcel


 

JensL  Identity Verified
Dominican Republic
English to Swedish
+ ...
Same problem here Feb 13, 2014

I have the same problem with Studio 2009, sp 3, so it's obviously not an isolated case.

 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

Studio 2009: "Input string was not in a correct format" when opening xls file

Advanced search







SDL MultiTerm 2017
Guarantee a unified, consistent and high-quality translation with terminology software by the industry leaders.

SDL MultiTerm 2017 allows translators to create one central location to store and manage multilingual terminology, and with SDL MultiTerm Extract 2017 you can automatically create term lists from your existing documentation to save time.

More info »
memoQ translator pro
Kilgray's memoQ is the world's fastest developing integrated localization & translation environment rendering you more productive and efficient.

With our advanced file filters, unlimited language and advanced file support, memoQ translator pro has been designed for translators and reviewers who work on their own, with other translators or in team-based translation projects.

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search