Sign in Register
Go to solution
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Ali Heristchian 10 posts 70 karma points
    Jan 01, 2017 @ 10:37
    Ali Heristchian
    0

    Formulate export to excel

    Hi

    There is a problem with Unicode characters or something like that in the way that all Persian characters become unreadable while exporting to excel.

    Thanks

    Copy Link
  • Nicholas Westby 2054 posts 7103 karma points c-trib
    Jan 01, 2017 @ 22:46
    Nicholas Westby
    100

    I suspect this has more to do with how you are opening the file. Formulate doesn't actually export to Excel format. It exports to CSV, which is a format that Excel is capable of opening.

    The reason that distinction is important is because Excel may have to infer the character set when opening the CSV file, and it may be doing it incorrectly. For comparison, I have LibreOffice, which has an application similar to Excel called Calc. When I open a CSV in calc that contains Persian characters, this is what I see:

    Default Calc Import

    Note that it selects a character set of "Western Europe" and that the characters appear garbled. If I change that character set to Unicode, this is what I see:

    Unicode Calc Import

    The Persian characters now appear correctly.

    Copy Link
  • Ali Heristchian 10 posts 70 karma points
    Jan 05, 2017 @ 11:33
    Ali Heristchian
    0

    Hi Nicholas,

    Thank you very much. I've changed the encoding and everything works fine now.

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft