- All categories
- Feature Requests (581)
- Help (2,096)
- Finished Features (28)

0 votes

0 votes

Thank you very much for uploading a sample spreadsheet.

After some research, it turns out that the library used for reading spreadsheets does not differentiate between cells formatted for integral numbers and cells formatted for decimal numbers (to be honest I do not know if it is even possible in Excel to restrict cells to integral numbers only). Long story short, data from cells formatted for numbers is always imported as decimal numbers.

The only workaround I can think of is temporarily changing the cell formatting to "Text" right before importing the spreadsheet into yEd and reverting the cell formatting once again afterwards. (Of course, your IDs will then be text in yEd as well.)

After some research, it turns out that the library used for reading spreadsheets does not differentiate between cells formatted for integral numbers and cells formatted for decimal numbers (to be honest I do not know if it is even possible in Excel to restrict cells to integral numbers only). Long story short, data from cells formatted for numbers is always imported as decimal numbers.

The only workaround I can think of is temporarily changing the cell formatting to "Text" right before importing the spreadsheet into yEd and reverting the cell formatting once again afterwards. (Of course, your IDs will then be text in yEd as well.)

Did anybody find a workaround for this problem in the meantime?

Thank you in advance!

Tobias

Update some minutes later:

I saw right now that there were several discussions about this topic and it seems to me, that it's not possible to change this behaviour during Excel import, but it's easily possible to change the data type to "integer" in the custom properties.

This is working for me and I can live with that one additional step.

edited Jun 5