[ic] what spreadsheet program in windows to use

Dan Browning interchange-users@icdevgroup.org
Fri Aug 2 12:50:01 2002


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.