<div dir="ltr">I have tested google docs with the same file translated using iconv to UTF-8 and it works great.<br>I still have a problem with excel, my customer claims he can not see the hebrew in the file.<br>Does someone on this list has access to Excel and can tell me how to tell excel the right encoding so it can import the hebrew?<br>
I myself don't have access to Exccel and thus can not test it.<br>I can send a sample file.<br><br>-- <br>Ori Idan<br><br><br><div class="gmail_quote">On Sat, Jul 31, 2010 at 12:47 AM, Omer Zak <span dir="ltr"><<a href="mailto:w1@zak.co.il">w1@zak.co.il</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div><div></div><div class="h5">On Sat, 2010-07-31 at 00:20 +0300, Ori Idan wrote:<br>
><br>
><br>
> On Sat, Jul 31, 2010 at 12:17 AM, Omer Zak <<a href="mailto:w1@zak.co.il">w1@zak.co.il</a>> wrote:<br>
> My experience is limited to whatever my CPA is using (I think<br>
> he uses<br>
> Excel). By experimenting with utf-8, cp862, iso_8859-8 and<br>
> windows-1255<br>
> encodings, we found that windows-1255 worked for him.<br>
><br>
> If you find that Google Docs and Excel have contradictory<br>
> expectations,<br>
> then I suggest that you allow people to export the CSV file in<br>
> either<br>
> "Google Docs compatible" encoding or "Excel compatible"<br>
> encoding.<br>
><br>
> What is google docs compatible format?<br>
<br>
</div></div>By trial, I found that utf-8 is the Google Docs compatible encoding:<br>
1. Create in Google Docs a spreadsheet with Hebrew text.<br>
2. Export it in CSV format to a file in your PC.<br>
3. Open the file in gedit and modify some cells.<br>
4. Import the file into Google Docs and demonstrate that it displays<br>
correctly the modified values.<br>
5. By means of xxd -g 1 (or other means), confirm that the file is in<br>
utf-8 encoding.<br>
<br>
By the way, I expect Excel to be configurable to accept also other<br>
encodings - but you'll have to find how to do it, and to write clear<br>
instructions for the users.<br>
<br>
--- Omer<br>
<font color="#888888"><br>
<br>
--<br>
Bottom posters are filthy heretics and infidels and ought to be burned<br>
on the stake after having been tarred, feathered and having rotten eggs<br>
thrown at their faces!<br>
</font><div><div></div><div class="h5">My own blog is at <a href="http://www.zak.co.il/tddpirate/" target="_blank">http://www.zak.co.il/tddpirate/</a><br>
<br>
My opinions, as expressed in this E-mail message, are mine alone.<br>
They do not represent the official policy of any organization with which<br>
I may be affiliated in any way.<br>
WARNING TO SPAMMERS: at <a href="http://www.zak.co.il/spamwarning.html" target="_blank">http://www.zak.co.il/spamwarning.html</a><br>
<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>
</div></div></blockquote></div><br></div>