Home Devices
New Blog Posts: Merging Reports - Part 1 and Part 2

XLSData - Carriage Returns in Memo not coming through to cell in Excel

edited September 2014 in Devices
Hi,

Using ReportBuilder 14.08 Enterprise.

Just doing some testing with exporting to Excel using XLSData and found
that carriage returns (#13#10 in delphi) are not coming through in the
cell. Rather, four spaces appear to be exported.

Is this by design, or something we can work around?

We don't want to use XLSReport as we want the content to be in one cell.

Cheers
Nicholas

Comments

  • edited September 2014
    Hi Nicholas,

    For RB 15.05 the XLSData exports Memos by preserving blank lines, removing
    CR/LF, allowing the Cell to wrap the text. There are no spaces added. This
    is done because the Memo.Width has to be mapped to one or more column
    widths - which means rounding will occur. In testing preserving the CR/LF
    provided poor results.



    Best regards,

    -
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited October 2014
    Hi Nard,

    Thanks for the response.

    The data the customer wishes to export for a memo, needs to have the
    carriage returns in it as they are important to that particular content
    - removing them changes the significance of the content.

    Is there a way we can override the behaviour of removing the carriage
    returns?

    Cheers
    Nicholas
  • edited October 2014
    Hi Nicholas,

    An XLSSettings property to control this is being add for RB 16.

    Currently there is no way to do it.


    Best regards,

    -
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited October 2014
    Thanks the reply Nard.

    However this leads to the inevitable question - when shall RB16 be
    available?

    Cheers
    Nicholas
This discussion has been closed.