<div dir="ltr">I will ask him to do it, however my guess is that he was not aware of the encoding and tried to use the default encoding which was probably windows-1251 (Latin-1) and thus got the gibrish.<br>In open office it also happened.<br>
Open office recognized UTF-8 by itself but could not recognize windwos-1255 and gave by default windows-1251.<br><br>-- <br>Ori Idan<br><br><br><div class="gmail_quote">On Sat, Jul 31, 2010 at 11:31 PM, 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;">Hello Ori,<br>
I suggest that you ask your client for a screenshot of the Excel window<br>
displaying the sample imported *.csv file.<br>
<br>
How can this benefit:<br>
<br>
1. Clear up any miscommunication - maybe the client is viewing a view<br>
not containing the cells having the Hebrew text; or another equally<br>
ridiculous misunderstanding.<br>
<br>
2. From the gibberish which the client does see (and captured by the<br>
screenshot) you can guess which encoding did his Excel use to import the<br>
file.<br>
<br>
--- Omer<br>
<div><div></div><div class="h5"><br>
<br>
On Sat, 2010-07-31 at 23:04 +0300, Ori Idan wrote:<br>
> I have tested google docs with the same file translated using iconv to<br>
> UTF-8 and it works great.<br>
> I still have a problem with excel, my customer claims he can not see<br>
> the hebrew in the file.<br>
> Does someone on this list has access to Excel and can tell me how to<br>
> 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>
> On Sat, Jul 31, 2010 at 12:47 AM, Omer Zak <<a href="mailto:w1@zak.co.il">w1@zak.co.il</a>> wrote:<br>
><br>
> 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>><br>
> wrote:<br>
> > My experience is limited to whatever my CPA is using<br>
> (I think<br>
> > he uses<br>
> > Excel). By experimenting with utf-8, cp862,<br>
> iso_8859-8 and<br>
> > windows-1255<br>
> > encodings, we found that windows-1255 worked for<br>
> him.<br>
> ><br>
> > If you find that Google Docs and Excel have<br>
> contradictory<br>
> > expectations,<br>
> > then I suggest that you allow people to export the<br>
> CSV file in<br>
> > either<br>
> > "Google Docs compatible" encoding or "Excel<br>
> compatible"<br>
> > encoding.<br>
> ><br>
> > What is google docs compatible format?<br>
><br>
><br>
> By trial, I found that utf-8 is the Google Docs compatible<br>
> 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<br>
> displays<br>
> correctly the modified values.<br>
> 5. By means of xxd -g 1 (or other means), confirm that the<br>
> file is in<br>
> utf-8 encoding.<br>
><br>
> By the way, I expect Excel to be configurable to accept also<br>
> other<br>
> encodings - but you'll have to find how to do it, and to write<br>
> clear<br>
> instructions for the users.<br>
<br>
--<br>
</div></div>Every good master plan involves building a time machine. Moshe Zadka<br>
<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>