• State Suggested Answer
  • Replies 8 replies
  • Answers 2 answers
  • Subscribers 434 subscribers
  • Views 4871 views
  • Users 0 members are here
Options
Related

How to import numbers in the excel file when creating a project using Studio

Pengfei Niu

Hi Studio experts,

 

I have an excel file. Some cells only have numbers. When I create a project using Studio, those numbers are not imported. It seems this is a default setting. But I do need the numbers imported. For example, the zip code cells are not imported. For localization purpose, I need to change those numbers.

 

 

Thanks,

Ivan
Rate translation
×
Suggest better translation
×
Moderator UI
×
  • Get AI Suggestion
Parents
  • 0

    Hi Ivan,

    Currently, the Excel file type does not extract numbers at all and as far as I know, neither will the new Excel file type. Could you please tell us why exactly do you need to change the zip code from Studio? This rather sounds like a change which should be done from Excel, since it's changing information, not just localizing it. Nevertheless, the development team would appreciate your input. We didn't really have reasons to extract numbers until now, but if it is a feature requested by more users, we will consider implementing it.

    Regards,
    Raul
  • 0 in reply to Raul Bularca
    Hi Raul,

    The file is used for a demo tutorial. The client needs local names, telephone numbers, zip codes, etc. Therefore, I need to change those numbers accordingly.

    I acutlly had another issue with these numbers. See my reply to Ladislav.

    Thanks,
    Ivan
  • 0 in reply to Pengfei Niu
    Hi Ivan,

    I can help you with Bilingual Excel. By default, the file type does not extract any numbers; to do it, go to settings and from the "Exclude" group uncheck "Cells containing formatted numbers". If this is unchecked, every number will be extracted. However, there is a caveat: considering the date that you shown to Ladislav, the filter will display it as a seemingly random number. That is because date, time and other elements are stored in the Excel file as really big numbers. For example, to store the date it counts how many days have passed since 1 January 1900, which is the value you will see extracted in Trados Studio. We don't extract this as a date because if the user wants to modify it, we can't be sure of the date format the user has introduced. Does he live in US and uses MM-DD-YYYY, or does he use another format? This is one of the reasons why we don't extract numbers: it can get quite messy and the values are not necessarily useful for the user.
    If you have any questions or suggestions, please feel free to contact me.

    Regards,
    Raul
Reply
  • 0 in reply to Pengfei Niu
    Hi Ivan,

    I can help you with Bilingual Excel. By default, the file type does not extract any numbers; to do it, go to settings and from the "Exclude" group uncheck "Cells containing formatted numbers". If this is unchecked, every number will be extracted. However, there is a caveat: considering the date that you shown to Ladislav, the filter will display it as a seemingly random number. That is because date, time and other elements are stored in the Excel file as really big numbers. For example, to store the date it counts how many days have passed since 1 January 1900, which is the value you will see extracted in Trados Studio. We don't extract this as a date because if the user wants to modify it, we can't be sure of the date format the user has introduced. Does he live in US and uses MM-DD-YYYY, or does he use another format? This is one of the reasons why we don't extract numbers: it can get quite messy and the values are not necessarily useful for the user.
    If you have any questions or suggestions, please feel free to contact me.

    Regards,
    Raul
Children
No Data