Source document "upside down"
Thread poster: audrey d

audrey d
Local time: 09:04
English to French
+ ...
Jul 14, 2011

Hi,
I'm trying to open a very simple 1-column .xlsx source document in english with omegaT and everything seems fine except that the segments are displayed in reverse order. Last segment comes first and first segments comes last, if it makes it any clearer...
Has anyone already had this problem or does anyone know how to solve it ?
Thanks


 

esperantisto  Identity Verified
Local time: 10:04
Member (2006)
English to Russian
+ ...
Known Jul 14, 2011

This issue is known: segments in a spreadsheet file may come in a random order. This is somehow related to the file format and there is nothing that can be done with OmegaT.

 

audrey d
Local time: 09:04
English to French
+ ...
TOPIC STARTER
how strange Jul 14, 2011

thank you
I just copied and pasted the source data into an old source file that worked and was displayed in the right order and now it's ok.
Does anyone know what sort of "format bug" this is related to ?


 

Didier Briel  Identity Verified
France
Local time: 09:04
English to French
+ ...
See OmegaT's bug tracker Jul 14, 2011

audrey d wrote:
I just copied and pasted the source data into an old source file that worked and was displayed in the right order and now it's ok.

Yes, that's a good workaround.

The order in OmegaT is the order in which the cells were created.

Does anyone know what sort of "format bug" this is related to ?

It's documented.
See Open XML: Excel strings are read in random order.

Didier


 

Samuel Murray  Identity Verified
Netherlands
Local time: 09:04
Member (2006)
English to Afrikaans
+ ...
OmegaT only limited .xlsx parsing Jul 14, 2011

audrey d wrote:
I'm trying to open a very simple 1-column .xlsx source document in English with OmegaT and everything seems fine except that the segments are displayed in reverse order.


If you mean that the text that is displayed in OmegaT is displayed in an order or sequence that is different from how it is displayed in the Excel file, then yes, that is a problem with Excel files in OmegaT. OmegaT reads the raw data from the Excel file as-is, and does not try to "understand" it. In the Excel file, the raw data is stored in the sequence that it was edited (usually), and not in the sequence that you visually see it in the Excel program.


 


There is no moderator assigned specifically to this forum.
To report site rules violations or get help, please contact site staff »


Source document "upside down"

Advanced search






PerfectIt consistency checker
Faster Checking, Greater Accuracy

PerfectIt helps deliver error-free documents. It improves consistency, ensures quality and helps to enforce style guides. It’s a powerful tool for pro users, and comes with the assurance of a 30-day money back guarantee.

More info »
Wordfast Pro
Translation Memory Software for Any Platform

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

More info »



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