{"ygPerms":{"resourceCapabilityList":[{"resourceType":"GROUP","capabilities":[{"name":"UPDATE"},{"name":"READ"},{"name":"WELCOME_MSG"},{"name":"PENDING_COUNT"},{"name":"ACTIVITY_LOGS"}]},{"resourceType":"PHOTO","capabilities":[{"name":"READ"},{"name":"READ"},{"name":"UPLOAD"},{"name":"UPDATE"},{"name":"DELETE"},{"name":"COPY"},{"name":"MOVE"},{"name":"APPROVE"},{"name":"UPLOADTEMP"},{"name":"GROUPCOVER"}]},{"resourceType":"FILE","capabilities":[{"name":"READ"},{"name":"CREATE"},{"name":"UPDATE"},{"name":"DELETE"},{"name":"AUTO_SEND"}]},{"resourceType":"MEMBER","capabilities":[{"name":"READ"},{"name":"READ"},{"name":"EDIT_MODERATOR"},{"name":"DELETE"},{"name":"CREATE"},{"name":"UPDATE"},{"name":"BAN"}]},{"resourceType":"LINK","capabilities":[{"name":"READ"},{"name":"CREATE"},{"name":"UPDATE"},{"name":"DELETE"},{"name":"MOVE_LINK"}]},{"resourceType":"CALENDAR","capabilities":[{"name":"READ"}]},{"resourceType":"DATABASE","capabilities":[{"name":"CREATE"},{"name":"READ"},{"name":"READ_DATA"}]},{"resourceType":"POLL","capabilities":[{"name":"READ"},{"name":"VOTE"},{"name":"UPDATE"},{"name":"CREATE"},{"name":"DELETE"},{"name":"CLOSE"}]},{"resourceType":"MESSAGE","capabilities":[{"name":"CREATE"},{"name":"READ"},{"name":"DELETE"}]},{"resourceType":"PENDING_MESSAGE","capabilities":[{"name":"READ"},{"name":"UPDATE"},{"name":"DELETE"}]},{"resourceType":"ATTACHMENTS","capabilities":[{"name":"READ"},{"name":"DELETE"}]},{"resourceType":"PHOTOMATIC_ALBUMS","capabilities":[{"name":"READ"},{"name":"UPLOAD"}]},{"resourceType":"MEMBERSHIP_TYPE","capabilities":[{"name":"READ"},{"name":"CREATE"},{"name":"DELETE"},{"name":"UPDATE"}]},{"resourceType":"POST","capabilities":[{"name":"CREATE"},{"name":"READ"},{"name":"DELETE"},{"name":"UPDATE"}]},{"resourceType":"PIN","capabilities":[{"name":"CREATE"},{"name":"READ"},{"name":"DELETE"},{"name":"UPDATE"}]}],"modStatus":"MODERATOR","subStatus":"NORMAL","groupUrl":"groups.yahoo.com","intlCode":"us"},"comscore":"pageview_candidate","ygData":{"userId":12196177,"authorName":"Marc Prior","from":"Marc Prior &lt;mail@marcprior.de&gt;","profile":"lin4trans","replyTo":"LIST","senderId":"t3jVIpbuQPSThuLAbjFVKIsM1jOKnZKsTJdcHG_uvE6iVhc4kg_pRQwHBoEhFDuds0WcSEyt-Gh0cpX26zOPRmpqqPDg","spamInfo":{"isSpam":false,"reason":"12"},"subject":"Re: [OmT] Segments from XLSX not in order","postDate":"1285701377","msgId":19192,"canDelete":true,"contentTrasformed":false,"systemMessage":false,"headers":{"messageIdInHeader":"PDRDQTIzRjAxLjEwNTAwMDZAbWFyY3ByaW9yLmRlPg==","inReplyToHeader":"PDRDQTIzMzY1LjcwOTA2MDRAYWJzYW1haWwuY28uemE+","referencesHeader":"PDRDQTIzMzY1LjcwOTA2MDRAYWJzYW1haWwuY28uemE+"},"prevInTopic":19190,"nextInTopic":19195,"prevInTime":19191,"nextInTime":19193,"topicId":19190,"numMessagesInTopic":13,"msgSnippet":"I would have done the same as you: converted to a different format. After translating the converted file in OmegaT, put the .xlsx file in /source, reload,","rawEmail":"Return-Path: &lt;mail@marcprior.de&gt;\r\nX-Sender: mail@marcprior.de\r\nX-Apparently-To: OmegaT@yahoogroups.com\r\nX-Received: (qmail 18012 invoked from network); 28 Sep 2010 19:16:37 -0000\r\nX-Received: from unknown (98.137.34.45)\n  by m6.grp.sp2.yahoo.com with QMQP; 28 Sep 2010 19:16:37 -0000\r\nX-Received: from unknown (HELO mo-p00-ob.rzone.de) (81.169.146.160)\n  by mta2.grp.sp2.yahoo.com with SMTP; 28 Sep 2010 19:16:36 -0000\r\nX-RZG-AUTH: :IW0NeWCleu3NCLZrvwV6ORkX9kpsdepz7ym3QvLwqKG/CxzSJ1M8iwz3PqB3XA==\r\nX-RZG-CLASS-ID: mo00\r\nX-Received: from [192.168.0.100] (p5086AD50.dip.t-dialin.net [80.134.173.80])\n\tby post.strato.de (fruni mo31) (RZmta 23.5)\n\twith ESMTP id e005a0m8SHbU1Y for &lt;OmegaT@yahoogroups.com&gt;;\n\tTue, 28 Sep 2010 21:16:34 +0200 (MEST)\r\nMessage-ID: &lt;4CA23F01.1050006@marcprior.de&gt;\r\nDate: Tue, 28 Sep 2010 21:16:17 +0200\r\nUser-Agent: Thunderbird 2.0.0.23 (X11/20090817)\r\nMIME-Version: 1.0\r\nTo: OmegaT@yahoogroups.com\r\nReferences: &lt;4CA23365.7090604@absamail.co.za&gt;\r\nIn-Reply-To: &lt;4CA23365.7090604@absamail.co.za&gt;\r\nContent-Type: text/plain; charset=ISO-8859-1; format=flowed\r\nContent-Transfer-Encoding: 7bit\r\nX-Originating-IP: 81.169.146.160\r\nX-eGroups-Msg-Info: 1:12:0:0:0\r\nFrom: Marc Prior &lt;mail@marcprior.de&gt;\r\nSubject: Re: [OmT] Segments from XLSX not in order\r\nX-Yahoo-Group-Post: member; u=12196177; y=Rv4CUaaBPLN4dFUSH4i1ihUlBO-81hV7Md7it5E86hYQd7aJ\r\nX-Yahoo-Profile: lin4trans\r\n\r\nI would have done the same as you: converted to a different format. \nAfter translating the converted file in OmegaT, put the .xlsx file in \n/source, reload, check that everything is translated.\n\nWhat kind of content was lost when you converted to .ods?\n\nIs there another format you can consider - html, perhaps?\n\nMarc\n\n\n\nSamuel Murray (Durbanville) wrote:\n&gt; G&#39;day everyone\n&gt;\n&gt; I loaded an XLSX file into OmegaT but the segments are all jumbled up \n&gt; (i.e. they&#39;re not in the same order as they appear in the Excel file). \n&gt; I have tried converting to ODS but then about 80% of the content is \n&gt; lost, so that route is not viable (although the content that did survive \n&gt; the conversion do appear in the correct order in OmT).\n&gt;\n&gt; For example, out of 1000 segments, the first cell with content in the \n&gt; Excel file is segment number 240 in OmegaT (and the second and third \n&gt; cell in the Excel file are nowhere near segment number 240 in OmT).\n&gt;\n&gt; Is there a way to fix this?\n&gt;\n&gt; Using the latest version of OmT.\n&gt;\n&gt; Samuel\n&gt;\n&gt;\n&gt; ------------------------------------\n&gt;\n&gt; The OmegaT Project Philosophy:\n&gt; http://www.omegat.org/en/philosophy.html\n&gt; The OmegaT Project and You:\n&gt; http://www.omegat.org/en/involved.html\n&gt;\n&gt; OmegaT contributors should join the &quot;omegat-development&quot; group\n&gt; OmegaT localizers should join the &quot;omegat-l10n&quot; group\n&gt; http://sourceforge.net/mail/?group_id=68187\n&gt;\n&gt; IRC channel: http://java.freenode.net//index.php?channel=omegat\n&gt; or: irc://irc.freenode.net/omegat\n&gt; Bug reports, feature requests, OmegaT test versions etc...:\n&gt; http://sourceforge.net/projects/omegat/\n&gt;\n&gt; ------------------------------------\n&gt;\n&gt; Yahoo! Groups Links\n&gt;\n&gt;\n&gt;\n&gt;\n&gt;   \n\n\n"}}