Technical forums » OmegaT support »
Source document "upside down"
Thread poster: audrey d
audrey d
audrey d
Local time: 11:20
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
esperantisto  Identity Verified
Local time: 12:20
Member (2006)
English to Russian
+ ...
SITE LOCALIZER
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
audrey d
Local time: 11:20
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
Didier Briel  Identity Verified
France
Local time: 11:20
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
Samuel Murray  Identity Verified
Netherlands
Local time: 11:20
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"






TM-Town
Manage your TMs and Terms ... and boost your translation business

Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.

More info »
Trados Business Manager Lite
Create customer quotes and invoices from within Trados Studio

Trados Business Manager Lite helps to simplify and speed up some of the daily tasks, such as invoicing and reporting, associated with running your freelance translation business.

More info »