Mike... you're a star!!!

That's hit the nail right on the head.

It works perfectly for me as I'm dealing with a small number of records in my view.

Many thanks,

James

Hi James,

Okay, I tried it out and it seems like the issue is that the calculations are performed asynchronously. So at the time you are performing the resize, the column has not been calculated, so it's being resized based on it's current text, which is empty.

The only way to get around that would be to force the calculations to be performed before the resizing. This might not be very performant, depending on the number and complexity of your calculations, but that's really the only way. I got it to work like so:

this.ultraGrid1.SetDataBinding(this.ultraDataSource1, "Band 0");
this.ForceAllCalculations();
this.ultraGrid1.DisplayLayout.PerformAutoResizeColumns(false, PerformAutoSizeType.AllRowsInBand, AutoResizeColumnWidthOptions.All);

        private void ForceAllCalculations()
        {
            this.ultraCalcManager1.CalcFrequency = Infragistics.Win.UltraWinCalcManager.CalcFrequency.Manual;
            this.ultraCalcManager1.DeferredCalculationsEnabled = false;

            try
            {
                this.ultraCalcManager1.ReCalc();

            }
            finally
            {
                this.ultraCalcManager1.DeferredCalculationsEnabled = true;
                this.ultraCalcManager1.CalcFrequency = Infragistics.Win.UltraWinCalcManager.CalcFrequency.Asynchronous;
            }
        }

Hi Mike,

Thanks for the suggestion... here's some feedback:

1. grid.Update before PerformAutoResizeColumns doesn't work
2. Using the Paint event works some, but not all of the time

I've managed to get this working in an extremely kludgy fashion.

private void NominalLedgerComboEditor_ValueChanged(object sender, EventArgs e)
{
var nominal = (int)NominalLedgerComboEditor.Value;
postingGrid.Paint += new PaintEventHandler(postingGrid_Paint);
postingBindingSource.DataSource = _agreement.AllPostings.Where(p => p.Nominal == nominal).OrderBy(p => p.ValueDate).ThenBy(p => p.Id).ToList();
}

void postingGrid_Paint(object sender, PaintEventArgs e)
{
postingGrid.Paint -= new PaintEventHandler(postingGrid_Paint);
new System.Threading.Timer(AutoFormatGridCallback, postingGrid, 10, -1);
}

void AutoFormatGridCallback(object grid)
{
((UltraGrid)grid).DisplayLayout.Bands[0].PerformAutoResizeColumns(false, PerformAutoSizeType.AllRowsInBand, AutoResizeColumnWidthOptions.All);
}

So here's what I'm doing:

1. I hook up the Paint event just before setting the datasource.
2. I then removed the handler as soon as it fires.
3. I then set a timer for 10 milliseconds to allow for the paint event to complete
4. The timer callback then formats the grid

This works, but it isn't pretty!!!

Any thoughts??

Cheers,

James

Hi James,

Try this... immediately before you call PerformAutoResizeColumns, call grid.Update. That should force the grid to paint once before the autosize occurs.

If that does not work, then try moving this code into the grid's Paint event. You can use a flag so that it's only executed the first time the event fires (since autosizing every time the grid paints would be very inefficient).

Hi Mike,

Thanks for the swift response.

Info about the column:

• created at design time
• called Balance
• calculated using an UltraCalcManager
• the formula is [Total] + if ( iserror ( [Balance(-1)] ), 0, [Balance(-1)] )

The band is being resized with the following call:

• band.PerformAutoResizeColumns(false, PerformAutoSizeType.AllRowsInBand, AutoResizeColumnWidthOptions.All);

The grid is called postingGrid which has a data source of postingBindingSource.

I set the DataSource on the bindingSource and then make the call to format the grid:

postingBindingSource.DataSource = _agreement.AllPostings.Where(p => p.Nominal == nominal).OrderBy(p => p.ValueDate).ThenBy(p => p.Id);
postingGrid.DisplayLayout.Bands[0].PerformAutoResizeColumns(false, PerformAutoSizeType.AllRowsInBand, AutoResizeColumnWidthOptions.All);

Hope this all makes sense!!!

I'm guessing that there is an event that I need to hook up to whereby the calculated column is fully visible, but I can't work out what it is!!

Cheers,

James