This site uses cookies. Some of these cookies are essential to the operation of the site, while others help to improve your experience by providing insights into how the site is being used. For more information, please see the ProZ.com privacy policy.
Cookie settings

Tehnički forumi » SDL Trados support »
Studio 2009: "Input string was not in a correct format" when opening xls file
Objavljivač niti: Marcel Hlbočan

Marcel Hlbočan
Local time: 05:22
slovački na engleski
+ ...
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?... See more
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 ▲ Collapse
 

Marcel Hlbočan
Local time: 05:22
slovački na engleski
+ ...
POKRETAČ TEME
Once again... Aug 30, 2012

Really no one with the same issue?
 

SDL Community  Identity Verified
Velika Britanija
Local time: 05:22
Član (1970)
engleski
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
Hrvatska
Local time: 05:22
Član (2010)
engleski na hrvatski
+ ...
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: 05:22
slovački na engleski
+ ...
POKRETAČ TEME
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 ... See more
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 ▲ Collapse
 

JensL  Identity Verified
Dominikanska Republika
engleski na švedski
+ ...
Same problem here Feb 13, 2014

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

Stepan Konev  Identity Verified
Ruska Federacija
Local time: 07:22
engleski na ruski
Same here Nov 30, 2020

Is there any news on this issue? Studio 2021 behaves the same way.
 


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

Moderatori ovog foruma
Natalie[Call to this topic]
Myron Netchypor[Call to this topic]
Marco Ramón[Call to this topic]
Maya Gorgoshidze[Call to this topic]
Prachya Mruetusatorn[Call to this topic]

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







Anycount & Translation Office 3000
Translation Office 3000

Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.

More info »
SDL Trados Studio 2021 Freelance
The leading translation software used by over 270,000 translators.

SDL Trados Studio 2021 has evolved to bring translators a brand new experience. Designed with user experience at its core, Studio 2021 transforms how new users get up and running and helps experienced users make the most of the powerful features.

More info »

Skorije objavljene poruke | FAQ | Pravila | Moderatori | Baza članaka

Your current localization setting

srpski

Select a language

More languages...
Close search
Forums
  • All of ProZ.com
  • Pretraga termina
  • Poslovi
  • Forumi
  • Multiple search