Decimals in node table from Excel file

[German Rosano]

Hi!

I`m trying to import a column from Excel consisting of numbers with decinal points. Cytoscape correctly interprets the column values as floating points (I want to make continuous mapping) but numbers are rounded to an integer. So, e.g., 0.789 becomes 1.0.

How do I keep the decimals? Thanks!

[Scooter Morris]

Greetings!

Well, I've never seen that before.  Are you importing directly as an Excel spreadsheet, or are you exporting from Excel to a tsv or csv file?  If you aren't exporting it, give that a try and then make sure the values are correct in the exported file, then use that file to import things into cytoscape.  If it's still rounding, I would submit a bug and include the excel spreadsheet and your session file.

-- scooter

[Schubidu Lalala]

Hello,

I have the same issue und also importing as csv doesn't help. Is there a solution by now.

[Scooter Morris]

When you exported as a CSV file, what do the values look like?  If the values in the first several rows look like integers, Cytoscape will interpret the column as an integer column.  The fix is to force it to be a floating point column by right clicking on the column in the import interface and setting it to be a floating point column.  Also, make sure that the CSV is using "." as your decimal separator and not ",".

-- scooter