Hi raju, On Sat, Aug 06, 2005 at 08:41:54PM -0400, kamaraju kusumanchi wrote: > Hi all > My problem could be that I am using wrong software to do this. So I > will explain the problem and tell how I am currently doing it. If there > are better alternatives (read as less keystrokes) I would like to use it. > > Let's say I print three arrays of data using a fortran 90 program (or > any other high level language for that matter). > > > 0.1 0.2 0.3 > 0.4 0.5 0.6 > 0.7 0.8 0.9 > > First row contains the first array, second row contains second array, > third row contains third array. This way I just have to write one > function to print the array and call it three times with different > arguments. > > But if I want to visualize this data using gnuplot (my favorite plotting > tool), I have to print the data as > > 0.1 0.4 0.7 > 0.2 0.5 0.8 > 0.3 0.6 0.9 > > so that I can plot first column vs second column etc., This is so > because, gnuplot supports plotting only columns. > > So now I have to find a software which will transpose the data file. I > thought oocalc can do it. But my data files usually have a .dat > extension (not .csv extension). So If I do > > oocalc temp.dat > > then it will be loaded in oowriter which is not what I intend to do.
mv temp.dat temp.csv oocalc temp.csv > > So my questions are > > 1) Is there any other plotting tool which can plot across rows? Since you are using oocalc, why not use its diagram assistant? > 2) If this software is not gnuplot, any comparison with gnuplot would be > very helpful in choosing it over gnuplot. > 3) Is there any other spreadsheet program which has builtin capability > to transpose the data? and load the .dat files and save them as .dat > files even after manipulation (ie no complicated xml format just pure > numbers and spaces)? > I can always write a script/program to do this (by python or Fortran 90 > etc.,) But a GUI program like spread sheet would be nice. I am looking > for an easy interface. > 4) Any other relevant suggestions are also welcome. > > thanks in advance > raju > HTH -- Joachim Fahnenmüller -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]