| User | Thread poster: audrey d Source document "upside down" |
audrey d France Local time: 21:53 English to French + ... |
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 Belarus Local time: 22:53
Member (2006) English to Russian + ... |
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 France Local time: 21:53 English to French + ... TOPIC STARTER |
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 France Local time: 21:53
 Member (2007) 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 Netherlands Local time: 21:53
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. | | | |