[ic] XLS import failure - 255 character limit issue.

[interchange-users@icdevgroup.org (Dan Browning)]

At 11:56 AM 9/4/2002 -0400, you wrote:
>Quoting Reid Sutherland (reid@vianet.ca):
> > Hi,
> >
> > I've having an issue where I'm trying to import an Excel 97+ spreadsheet
> >   into IC.  The problem is that IC takes a violent fit when the
> > description/comment field is over 255 characters.  It will start to push
> > MySQL errors.  Now I'm from me looking at the
> > UI/usertags/import_fields.tag, I don't see anything that would cause any
> > fields to be truncated/filled with upper ASCII chars by IC.  But then
> > again the code is very well written, making it painful for me to read :)
>
>I have seen problems with XLS created by Excel 97 with long fields. They
>are fine if generated by Gnumeric...

Ditto with OpenOffice "Calc". Funnily enough, Excel will crash on files 
that Calc opens just fine.  You might give it a shot.

/~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\
| Dan Browning, Kavod Technologies      <dan.browning@kavod.com> |
| (360) 882-7872 x7, 6700 NE 162nd Ave, Suite 210, Vancouver, WA |
\~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~/
"What's the use of a good quotation if you can't change it?"
                 -- Dr. Who