[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
[ic] what spreadsheet program in windows to use
At 06:34 PM 8/2/2002 +0300, you wrote:
> > we use windows xp and excel exp 2002 and its not working right. it puts
> > little squares in teh areas and interchange gives a fatal error when
> > loading a tab text file which was made with excel.
> >
> > what spreadsheet program should we use?
>
>Export the file as tab-delimitd. After that remove the carrige returns with
>the following command on your linux-box:
>
>tr -d '\015' < old_file.txt > new_file.txt
>
>Rene
What Rene recommended should work great. Alternatively, you can try using
the native XLS format instead of working with TXT files. A meager howto is
online:
http://www.icdevgroup.org/~danb/
Second, I've found that OpenOffice actually does *better* than excel when
working with these file formats (i.e. Excel crashes on some of the output
from Spreadsheet::ParseExcel, but OpenOffice Calc opens it fine).
+~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Dan Browning, Kavod Technologies <db@kavod.com>
+~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The day after tomorrow is the third day of the rest of your life.