Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
170
Exporting a Group Header
posted

I have a grid that has 3 groups and columns in each of the groups. The GroupHeader line = 3. 

I'm creating a caption for each header using something like this:

"Line1" & vbcrlf & "Line2 & vbcrlf & "Line3"

On the screen it looks fine. 3 separate lines;however, when I export to Excel it creates one long line:

Line1Line2Line3

How can I make the exported version look like the on screen version, i.e., 3 separate lines? Thanks -jim

 

  • 469350
    Verified Answer
    Offline posted

    Hi Jim,

    I tried this out and it works fine for me. I see all three lines of text in the Excel file.

    Can you post a small sample project demonstrating this behavior so I can check it out? You can attach a file to your post under the Options tab.