- All categories
- Feature Requests (563)
- Help (1,976)
- 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.)