sorry, I just don’t know how to describe my problem better.
in order to show the correct letters of my foreign language vocabulary set i have to change the font settings of the specified column. for example:
in arial (utf-8 i suppose) there is “la2r+S4F” and only when I change the font of the cell to “Shalom Old Style” I get the desired יִשְׂרָאֵל.
But now I want to import this data into my vocabulary program but whenever I try to export or save in different file formats, the hebrew column changes back to utf-8 mixed letters. Is there a way to keep the hebrew and the latin characters when exporting?
EDIT: Windows 8.1 N, LibreOffice 22.214.171.124, i have the file in different file formats, .ods, .xml, .csv, .xhtml, etc.
I use Anki. I save in different formats and try importing them into anki or open them in editor or notepad++. But in no case it shows me the hebrew letters. i don’t get it.
EDIT2: I should have mentioned, that I extracted the data from another vocabulary program into an txt and that data I imported into LO. the hebrew letters then were already utf-8 converted and I could only make thim appear correctly by adjusting the font of the column to “Shalom Old Style”. Its the only way it even shows hebrew. What I’m looking for is a solution to merge these two formats together into utf-8, like convert the hebrew ones to their correspondent utf-8/unicode ones. On screen the data is fine I just can’t use them elsewhere which sucks.