Excel export, linebreak problem..

Posted by: johnnyas on 4 August 2017, 2:54 pm EST

  • Posted 4 August 2017, 2:54 pm EST

    When I export to excel and get text that is too long for their column, it breaks into two cells, not in the same cell as I'd like them too.

    What can I do to get it like I want? (check out the attached image)





  • Replied 4 August 2017, 2:54 pm EST

    There isn't any tweak that makes ActiveReports export a textbox that grows into several line into one cell. Is it possible for you to use the SpreadBuilder API to export the excel file? it requires more code but will give you more control over the output of the report.
  • Replied 4 August 2017, 2:54 pm EST

    It isn't really feasible for us to convert the project to use spreadbuilder now at least. I've been working on other parts of the project, but this keeps returning. What I don't understand, is why it seems that the detailpart (repeating) of the report does what I want without me trying to make it do it.. Long lines breaks inside the cell, which is what I want..

    It won't do it in the header though, I don't get it at all!
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels