Re: Importing csv with 2.0 beta

Posted by karenacollins on Aug 29, 2012; 7:26pm
URL: http://astroimagej.170.s1.nabble.com/Importing-csv-with-2-0-beta-tp3p4.html

Willie, sorry for the trouble with the .csv file format. I tried a .csv file here, and I have not been able to duplicate the problem (all 6 decimal places were retained). I sometimes add new columns using a spreadsheet, but I always have to manually set the number format to use 6 decimal places for all data columns after I open the original file, since it seems to default to 3 places. If you did set the number format to 6 decimal places before you saved the .csv file, could you open the .csv file with a text editor of your choice, and verify that all 6 decimal digits are saved into the .csv file? If they are, could you send me a portion of your file to karenDOTcollinsATinsightbbDOTcom so I can test with it here. Also, if you are able to save from the spreadsheet as a tab-delimited file, could you try that and see if you have the same problem? As a final comment, I am adding a feature to the AIJ plot facility to allow users to save a plotted dataset (i.e. after magnitude conversion, operations, normalization(another new feature), etc) back to the table as a new data column. My goal is to avoid the need to go into a spreadsheet to tweak datasets. Is there a specific calculation on the data that would prevent you from having to use a spreadsheet program to manipulate the data? If it is a simple enough and generally useful to the typical AIJ user, I may add it to the final AIJ 2.0 release.