Drop down box - Hebrew problem [closed]
What a beautiful program you have!
I ran into a little problem when using a drop down box within Calc. I have my worksheet set up to give me a list of customers from my next worksheet -- in a drop down box.
Amongst this list are English and Hebrew names. The English names show fine. But I get rectangles instead of the Hebrew letters for the Hebrew names! Help!
Avrohom
OS - Vista Libre version - 4.0.1.2 I clearly have Hebrew fonts installed. Within the worksheet the Hebrew shows just fine! And also, I never had this problem with Open Office. I now notice, that within the worksheet: in the box next to: fx sigma equal -- also rectangles are showing instead of the Hebrew. I also now tried a few fonts besides Tahoma: Arial, Times New Roman, David Transparent -- all the same issue.
Try the Arial Unicode MS font.
Yes Oweng, I am referring to Data > Validity > Criteria > Allow > Cell range! But I have the same problem with Arial Unicode MS. The Hebrew shows inside the worksheet -- but in the window above and in the drop down box --> rectangles!!!
Does my example display the Hebrew characters or the character placeholder symbol?
Oweng, your example is working perfect! Can you help me with my document? I don't find your font: Nachlieli CLM in my list of fonts...
Under Windows Vista you won't as Nachlieli CLM is part of the Culmus Hebrew package of fonts for GNU/Linux. You can get it and other Hebrew fonts here. Download the
culmus 0.121-1
package for Debian (click on the "all" link and chose a local mirror). You will need to open the DEB file with an archive manager to extract the fonts. Nachlieli may not be the best choice as it is a Type 1 font. There are other truetype fonts included though.I downloaded Culmus. Could you give me a link to an archive manager for extraction? Thank you.
http://www.7-zip.org/