Welcome to yEd Q&A!
Here you can ask questions and receive answers from other members of the community and yEd developers. And you can tell us your most wanted feature requests.


yEd misinterprets decimal numbers from Excel at import

0 votes

Dear yEd-Team,

I tried to open an Excel file, that looks like follows:

column SOURCE: text
column TARGET: text
column VALUE1: decimal numbers
column VALUE2: integer numbers
column VALUE3: text

Everything works fine, the graph looks fine and I can use the different value-columns as edge labels. Bu when I used VALUE1 I discovered, that yEd misinterprets the decimal numbers. yEd cuts off the decimal part and treats it as 0. For example 20.8 is converted to 20.0, and 0.195 is converted to 0.0.

Can you help me with this issue?

To your information: In the import dialogue window where the imported data is selected, everything look fine (20.8, 0.195, ...)

I tried to change the decimal separator from comma (,) (my German regional setting) to point (.) in Excel (Excel-options) and Windows (control panel): no difference

I tried xls and xlsx: no difference

I work with yEd 3.9.2 (latest version AFAIK), Excel 2007 and Windows XP.


best regards,

in Help by

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.
Legal Disclosure | Privacy Policy