<div dir="ltr">Indeed it looks like xml file. but on the web site they publish excel xls file and it is saved on the hd as xls. <br><br>I have open office 3.0 at home and it couldn't read it normally. The portable openoffice that I use now is 3.0.0 and it doesn't read it normally unless i use the workaround mentioned above.I will definitely check the wiki. I wonder if the new version of 3.1 does solve the problem. Yet, I do believe that at least they should create real xls so that sorting and all other calculation can be done properly. <br>
<br><div class="gmail_quote">On Wed, May 13, 2009 at 12:40 PM, Uri Bruck <span dir="ltr"><<a href="mailto:bruck@actcom.net.il">bruck@actcom.net.il</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
This document appears to be in SpreadsheetML<br>
The openoffice wiki has a document on this:<br>
<a href="http://wiki.services.openoffice.org/wiki/SpreadsheetML" target="_blank">http://wiki.services.openoffice.org/wiki/SpreadsheetML</a><br>
<br>
>From a cursory look it looks like OpenOffice 3 is supposed to be able to<br>
handle this.<br>
<div><div></div><div class="h5"><br>
sara fink wrote:<br>
> Regarding the xls files, I just found out that orange xls files where<br>
> you have the details of the conversations aren't readable in open<br>
> office calc. However it work in microsoft excel. In OpenOffice Calc,<br>
> it appears in the begining as xml tags and the rest is something<br>
> unordered. So those who do care, please write or talk to orange DATA<br>
> *663. Otherwise, getting details of the conversations, are charged.<br>
> There is an workaround to solve this problem. The workaround is to<br>
> open the file in microsoft excel, save as xls and then open it in open<br>
> office.<br>
><br>
> Here is how it looks like in OpenOffice calc without the converted file:<br>
><br>
> <?xml version="1.0"?><br>
><br>
><br>
> <ss:Workbook xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"><br>
><br>
><br>
> <ss:Styles><br>
><br>
><br>
> <ss:Style ss:ID="1"><br>
><br>
><br>
> <ss:Font ss:Bold="1" ss:Color="White" ss:FontName="Ariel" /><br>
><br>
><br>
> <ss:Interior ss:Color="Orange" ss:Pattern="Solid" /><br>
><br>
><br>
> </ss:Style><br>
><br>
><br>
> </ss:Styles><br>
><br>
><br>
> <ss:Worksheet ss:Name="Sheet1"><br>
><br>
><br>
> <ss:Table><br>
><br>
><br>
> <ss:Row ss:StyleID="1"><br>
><br>
><br>
> <ss:Cell ss:MergeAcross="1"><br>
><br>
><br>
> <ss:Data ss:Type="String">פירוט שיחות</ss:Data><br>
><br>
><br>
> </ss:Cell><br>
><br>
><br>
> </ss:Row><br>
><br>
><br>
><br>
><br>
><br>
><br>
> <ss:Row ss:StyleID="1"><br>
><br>
><br>
> <ss:Cell><br>
><br>
><br>
> <ss:Data ss:Type="String">תאריך שיחה</ss:Data><br>
><br>
><br>
> </ss:Cell> <ss:Cell><br>
><br>
><br>
> <ss:Data ss:Type="String">שעת שיחה</ss:Data><br>
><br>
><br>
> </ss:Cell> <ss:Cell><br>
><br>
><br>
> <ss:Data ss:Type="String">מספר שחויג</ss:Data><br>
><br>
><br>
> </ss:Cell> <ss:Cell><br>
><br>
><br>
> <ss:Data ss:Type="String">שם מחויג</ss:Data><br>
><br>
><br>
> </ss:Cell> <ss:Cell><br>
><br>
><br>
> <ss:Data ss:Type="String">שם המפעיל</ss:Data><br>
><br>
><br>
> </ss:Cell> <ss:Cell><br>
><br>
><br>
> <ss:Data ss:Type="String">משך שיחה לחיוב</ss:Data><br>
><br>
><br>
> </ss:Cell> <ss:Cell><br>
><br>
><br>
> <ss:Data ss:Type="String">משך שיחה בפועל</ss:Data><br>
><br>
><br>
> </ss:Cell> <ss:Cell><br>
><br>
><br>
> <ss:Data ss:Type="String">תעריף זמן אויר orange</ss:Data><br>
><br>
><br>
> </ss:Cell> <ss:Cell><br>
><br>
><br>
> <ss:Data ss:Type="String">תעריף שימוש ברשתות תקשורת אחרות</ss:Data><br>
><br>
><br>
> </ss:Cell> <ss:Cell><br>
><br>
><br>
> <ss:Data ss:Type="String">סה"כ לחיוב</ss:Data><br>
><br>
><br>
> </ss:Cell> <ss:Cell><br>
><br>
><br>
> <ss:Data ss:Type="String">הערות</ss:Data><br>
><br>
><br>
> </ss:Cell><br>
><br>
><br>
> </ss:Row><br>
><br>
><br>
> <ss:Row><br>
><br>
><br>
><br>
><br>
> I am definitely going to complain about it.<br>
</div></div>> ------------------------------------------------------------------------<br>
><br>
> _______________________________________________<br>
> Linux-il mailing list<br>
> <a href="mailto:Linux-il@cs.huji.ac.il">Linux-il@cs.huji.ac.il</a><br>
> <a href="http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il" target="_blank">http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il</a><br>
><br>
<font color="#888888"><br>
<br>
--<br>
Thanks,<br>
Uri<br>
<br>
Si fractum non sit, noli id reficere.<br>
<br>
</font></blockquote></div><br></div>