ASP(xlWorksheet.Cells) w/many text chars has #VALUE! error in XL s

Discussion in 'ASP General' started by Matthew Carver, May 3, 2005.

  1. Hello,

    I have an ASP page that loops through a SQL Server 2000 table, then
    downloads an Excel sheet the users can save, etc. Works fine, except, I see
    that in one particular "comments" field the Excel sheet returns a #VALUE!
    error in the cell when there is a large amount of text. I've looked through
    the MSKB, MSDN and many ng posts to see if there is a workaround or solution
    to this, inclduing looking at the xlWorksheet properties (I've tried
    'xlWorksheet.Cells(iRow, 11).WrapText = True), played with Orientation, etc.
    But to no avail. Any help, suggestion or nod in the right direction would be
    greatly appreciated.

    Thanks in advance,
    MC
    Matthew Carver, May 3, 2005
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Replies:
    0
    Views:
    507
  2. Kosio

    Floats to chars and chars to floats

    Kosio, Sep 16, 2005, in forum: C Programming
    Replies:
    44
    Views:
    1,234
    Tim Rentsch
    Sep 23, 2005
  3. Hongyu
    Replies:
    9
    Views:
    881
    James Kanze
    Aug 8, 2008
  4. Joel Finkel

    Cells[].Text or Cells[].Controls[0]

    Joel Finkel, Sep 1, 2003, in forum: ASP .Net Datagrid Control
    Replies:
    0
    Views:
    285
    Joel Finkel
    Sep 1, 2003
  5. M.Posseth

    receiving ??? chars instead of "special" chars

    M.Posseth, Nov 15, 2004, in forum: ASP .Net Web Services
    Replies:
    3
    Views:
    209
    Dan Rogers
    Nov 16, 2004
Loading...

Share This Page