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.
Super weird issue. I have an excel file with multiple sheets. I'm trying to import strings from just one sheet using the multilingual delimited text filter. All I need is two columns, one for the source text and one for the translation. Thing is, it refuses to import the source text column, instead only importing the first row. What could possibly cause this? Also, when importing the file it gives me a lot of "merged with other cells, content ignored" messages. What is this?
Super weird issue. I have an excel file with multiple sheets. I'm trying to import strings from just one sheet using the multilingual delimited text filter. All I need is two columns, one for the source text and one for the translation. Thing is, it refuses to import the source text column, instead only importing the first row. What could possibly cause this? Also, when importing the file it gives me a lot of "merged with other cells, content ignored" messages. What is this?
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
Stepan Konev Russian Federation Local time: 20:22 English to Russian
Did you change configuration when you imported the file?
Mar 23, 2021
After you set Multilingual delimited text filter, you also need to set filters by clicking the 'Change filter & configuration' button. In the 'Document import settings' window, go to the Columns tab. Set columns as source and target. Also notice the "Sheet #" field. Make sure you have selected the correct value (sheet number counting from left to r... See more
After you set Multilingual delimited text filter, you also need to set filters by clicking the 'Change filter & configuration' button. In the 'Document import settings' window, go to the Columns tab. Set columns as source and target. Also notice the "Sheet #" field. Make sure you have selected the correct value (sheet number counting from left to right).
After you set Multilingual delimited text filter, you also need to set filters by clicking the 'Change filter & configuration' button. In the 'Document import settings' window, go to the Columns tab. Set columns as source and target. Also notice the "Sheet #" field. Make sure you have selected the correct value (sheet number counting from left to right).
[Edited at 2021-03-23 14:45 GMT]
I'm positive I've selected everything that needed to be selected, down to the exact sheet and columns. I'm guessing something is wrong with this specific excel file, because I've checked a few other files and they imported with no issue.
Stepan Konev
DOYOON KIM
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
Exclusive discount for ProZ.com users!
Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value
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.