Render to Excel - line break problem.

Discussion in 'ASP .Net Datagrid Control' started by Q. John Chen, Aug 28, 2006.

  1. Q. John Chen

    Q. John Chen Guest

    All,

    I posted this in asp.net group some time ago but didn't see any
    respone. Just noticed this group.

    I used DataGrid RenderControl to Excel. It works great except one
    thing:

    I have a cell that contain new lines - <BR> it rendered to the Excel as
    multiple-rows.

    I replaced the <BR> with Char(10), that doesn't work either.

    Any other tricks?

    Thanks

    John
     
    Q. John Chen, Aug 28, 2006
    #1
    1. Advertising

  2. Q. John Chen

    Baski Guest

    Try to replace <BR> with \r or \r\n or replace with Environment.NewLine ?

    "Q. John Chen" <> wrote in message
    news:...
    > All,
    >
    > I posted this in asp.net group some time ago but didn't see any
    > respone. Just noticed this group.
    >
    > I used DataGrid RenderControl to Excel. It works great except one
    > thing:
    >
    > I have a cell that contain new lines - <BR> it rendered to the Excel as
    > multiple-rows.
    >
    > I replaced the <BR> with Char(10), that doesn't work either.
    >
    > Any other tricks?
    >
    > Thanks
    >
    > John
    >
     
    Baski, Sep 22, 2006
    #2
    1. Advertising

  3. Q. John Chen

    Q. John Chen Guest

    Re: Render to Excel - line break problem.

    It was CR/LF. Both the grid and excel was back. I replaced it with <BR>
    so at lease it display correctly in the grid,
     
    Q. John Chen, Oct 2, 2006
    #3
    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. Lau Lei Cheong

    Page.Render do not render complete page

    Lau Lei Cheong, May 15, 2004, in forum: ASP .Net
    Replies:
    1
    Views:
    2,094
    Lau Lei Cheong
    May 15, 2004
  2. =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=

    Problem with Excel reports ::::Excel 2003 Migration To Excel 2007

    =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=, Oct 5, 2007, in forum: ASP .Net
    Replies:
    15
    Views:
    1,548
    =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=
    Oct 24, 2007
  3. Replies:
    12
    Views:
    988
  4. Q. John Chen

    Render to Excel - only one excel instance

    Q. John Chen, Aug 28, 2006, in forum: ASP .Net Datagrid Control
    Replies:
    0
    Views:
    212
    Q. John Chen
    Aug 28, 2006
  5. Glenn Gillen
    Replies:
    0
    Views:
    288
    Glenn Gillen
    Nov 17, 2006
Loading...

Share This Page