Home Devices

RB Excel export: column position error

edited January 2011 in Devices
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

Comments

  • edited January 2011

    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



    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.