Source document "upside down"
Inițiatorul discuției: audrey d
audrey d
audrey d
Local time: 16:52
din engleză în franceză
+ ...
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: 17:52
Membru (2006)
din engleză în rusă
+ ...
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: 16:52
din engleză în franceză
+ ...
INIŢIATORUL SUBIECTULUI
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
Franţa
Local time: 16:52
din engleză în franceză
+ ...
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
Ţările de Jos
Local time: 16:52
Membru (2006)
din engleză în 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.


 


Pentru acest forum nu a fost numit niciun moderator.
Pentru a raporta încălcarea regulilor site-ului sau pentru a solicita asistență, vă rugăm să contactați personalul site-ului »


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 »
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 »