RB Excel export: column position error

rbuser

Hello,

I am using RB 12.3 Pro and exporting data via XLSReport.
I found a error in Excel export column positioning.

Suppose we have columns A, B and C as below:

[Label A] [Label B] [Label C]
-----------------------------
[Data A ] [Data B ] [Data C ]

Suppose [Label A] and [Data A] have the same width and Left properties,
and right aligned. And so on. But A, B and C columns are very next.

If A, B, C data have values, export works fine.
But suppose [Data B] values NULL, [Data C] values is shifted to [Data
B]. It´s wrong.

Example:

Report:
[Label A] [Label B] [Label C]
-----------------------------
10 11 12
20 22
30 31 32

Excel:
[Label A] [Label B] [Label C]
-----------------------------
10 11 12
20 22 <-- value shifted
30 31 32

Thanks in advance

nardmoseley

For XLSReport export, the page elements (Label, DBText, etc) are mapped to
cells based upon their position.

When elements map to the same cell, the right most element will be moved to
the next available cell. Try setting AutoSize to False for all of the
elements. If that does not improve things, try increasing the space between
the columns.

If you would like to create an example project that we can build and run
here, please send to support@ and we can check it out. Please use standard
Delphi components and RB and send in zip format. Use the DBDemos or dump
some of your data to TClientDataSets.



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