indi
indi > RE: Variable age
Jul 25, 2011 01:07 PM | Maarten Mennes
RE: Variable age
Hi Alejandro,
I'm posting our solution here as others might run into the same problem.
The problem Alejandro describes is that the age column in the phenotpic files has two formats when he opens the file with OpenOffice 3.2 on windows. Some values are the correct ages, other values are converted to a date format.
It is unclear what causes this problem, but it likely has to do with the way the .csv file is read in and the cell formats are set.
If you encounter this problem, the easiest fix is to open the .csv file with a text editor like Wordpad (Windows), TextEdit (Mac) or Gedit (Linux). No formatting will be applied to the cells and you can just copy and paste into excel or OpenOffice or whatever spreadsheet you are using.
Best,
Maarten
I'm posting our solution here as others might run into the same problem.
The problem Alejandro describes is that the age column in the phenotpic files has two formats when he opens the file with OpenOffice 3.2 on windows. Some values are the correct ages, other values are converted to a date format.
It is unclear what causes this problem, but it likely has to do with the way the .csv file is read in and the cell formats are set.
If you encounter this problem, the easiest fix is to open the .csv file with a text editor like Wordpad (Windows), TextEdit (Mac) or Gedit (Linux). No formatting will be applied to the cells and you can just copy and paste into excel or OpenOffice or whatever spreadsheet you are using.
Best,
Maarten
Threaded View
| Title | Author | Date |
|---|---|---|
| Alejandro Pérez | Jul 18, 2011 | |
| Maarten Mennes | Jul 25, 2011 | |
