Codejock Developer Community : [SOLVED] AutocolumnSizing

[SOLVED] AutocolumnSizing : jpbro wrote:I might be wrong,...

Wed, 14 Sep 2011 11:59:19 +0000

Author: ABuenger
Subject: 18919
Posted: 14 September 2011 at 11:59am

jpbro wrote:

I might be wrong, but my understanding of the Column.AutoSize property is that it is only valid if the Report.AutoColumnSizing = True. Basically, you can exempt certain columns from the auto column sizing feature by setting the AutoSize property to False

If AutoColumnSizing = False, then the AutoSize property of each column is ignored, since no auto-sizing will be taking place.

This is correct. Maybe the help isn't clear enough here.

[SOLVED] AutocolumnSizing : I might be wrong, but my understanding...

Wed, 14 Sep 2011 07:13:09 +0000

Author: jpbro
Subject: 18919
Posted: 14 September 2011 at 7:13am

I might be wrong, but my understanding of the Column.AutoSize property is that it is only valid if the Report.AutoColumnSizing = True. Basically, you can exempt certain columns from the auto column sizing feature by setting the AutoSize property to False

If AutoColumnSizing = False, then the AutoSize property of each column is ignored, since no auto-sizing will be taking place.

[SOLVED] AutocolumnSizing : ABuenger wrote:Hi,everything...

Wed, 14 Sep 2011 02:58:23 +0000

Author: Albert1
Subject: 18919
Posted: 14 September 2011 at 2:58am

ABuenger wrote:

Hi,
everything is correct here.

To reply without reading the original post causes a waste of time for all.

From the CJ's help:

CJ wrote:

AutoColumnSizing (ReportControl)

If True, all columns are sized to fill the entire width of the ReportControl. When the ReportControl is resized, the Columns will automatically be resized to fit the new size of the RepotControl.

If False, the columns will use the width they were assigned when they were created, or whatever value is stored in the columns width property. [cut]

You can ALSO set each columns AutoSize property manually.

AutoSize Property (ReportControl.Column):

If TRUE, the width of the column is automatically resized when the ReportControl's client area is resized by the user. If FALSE, the column keeps its initial size that was specified when the column was created.

NOTE: When a column is added, the Resizable parameter is used to set the value for BOTH the Resizable and AutoSize property. If these properties will have a different value, then you will have to change the required value after the column has been added.

Well, in the first example I set the AutoColumnSizing to False (I wish the default is NO AutoSize) but I set manually AutoSize property to the Column (why not?) but the result is no autosize at all.

In the second example I removed the reference to the AutoColumnSizing property (at RC level): all works fine.

THIS IS A BUG!!!

Note: Or CodeJock should append ANOTHER (!!!) note in the help to advice "you cannot use BOTH AutoColumnSizing at ReportControl level and AutoSize at ReportColumn level" ...

[SOLVED] AutocolumnSizing : Hi,everything is correct here....

Wed, 14 Sep 2011 01:01:03 +0000

Author: ABuenger
Subject: 18919
Posted: 14 September 2011 at 1:01am

Hi,

everything is correct here. In the first case you've set AutoColumnSizing = False, therefore the columns are not automatically sized to match the report width.

In the second case AutoColumnSizing is True as well as AutoSize for the second column, therefore it gets resized.

Andre

[SOLVED] AutocolumnSizing : The following code will lead...

Thu, 08 Sep 2011 06:04:02 +0000

Author: Albert1
Subject: 18919
Posted: 08 September 2011 at 6:04am

The following code will lead to this result (wrong column width):

Private Sub Form_Load()
    Width = 8000
    Height = 4000
    With ReportControl1
        .Move 0, 0, ScaleWidth / 2, ScaleHeight
        .AllowColumnResize = True
        .AutoColumnSizing = False
        With .Columns.Add(0, "A", 100, False)
            .Resizable = True
            .AutoSize = False
        End With
        With .Columns.Add(0, "B", 100, False)
            .Resizable = True
            .AutoSize = True
        End With
        .Width = ScaleWidth
    End With
End Sub

The following code will lead to the desired layout (removed the AutoColumnSizing statement)

Private Sub Form_Load()
    Width = 8000
    Height = 4000
    With ReportControl1
        .Move 0, 0, ScaleWidth / 2, ScaleHeight
        .AllowColumnResize = True
        With .Columns.Add(0, "A", 100, False)
            .Resizable = True
            .AutoSize = False
        End With
        With .Columns.Add(0, "B", 100, False)
            .Resizable = True
            .AutoSize = True
        End With
        .Width = ScaleWidth
    End With
End Sub

How am I wrong (RC version 15)