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

rbuser

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

nardmoseley

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

rbuser

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

nardmoseley

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

rbuser

Thanks the reply Nard.

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

Cheers
Nicholas