All Cells seem to get skipped. It just seems strange that just changing the
location of assigning the event will cause this issue, all code should be
firirng the same in each case. If Active cell does change when I make the
assignment in the initializelayout how come it doesn't when I add the
assignment to form_load. Weird...

Thanks for you help anyway, you are awesome with your assistance with this
forum.


wrote in message news:16079@forums.infragistics.com...
>I don't see anything obvious here... except maybe the setting of
>CellActivation. Are those the cells being skipped?
>
> Or maybe something you are doing in AfterCellUpdate is causing the
> ActiveCell to change.
>
> Perhaps it's some property of the data column, rather than a property of
> the grid that's causing this.
>

I am not sure why either, it works fine when I add it in the form _load.

TabStop and TabIndex property
Columns is enabled.
If something in my code were handling an event wouldn't it also apply no
matter where I set the this.ultraGridTreatedDays.KeyDown +=
UltraWinGridBehavior.KeyDown;

Here is all code from form, maybe a quick look from you will solve it...

FORMCODE
using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Text;

using System.Windows.Forms;

using MarketForecaster.BOL;

using MarketForecaster.DAL;

using Infragistics.Win.UltraWinGrid;

using Infragistics.Win;



namespace MarketForecaster

{

public partial class frm_MF_GenericEroision : Form

{

private DataTable geDataTable = new DataTable();

public frm_MF_GenericEroision()

{

InitializeComponent();

}

#region Form Load

private void frm_MF_GenericEroision_Load(object sender, EventArgs e)

{

LoadGenericErosionInGrid();

//Grid Events - the keydown & keypress events seems to work when

// set in the form load, and not initialize_layout of grid.

//KeyDown

this.ultraGridGenericErosion.KeyDown += UltraWinGridBehavior.KeyDown;

//KeyPress

this.ultraGridGenericErosion.KeyPress += UltraWinGridBehavior.KeyPress;

//Global Error Handling of Grid

this.ultraGridGenericErosion.Error += UltraWinGridErrorHandler.Error;

}

#endregion

#region LoadGenericErosionInGrid

private void LoadGenericErosionInGrid()

{

//Load Grid

UltraGrid ugrid = this.ultraGridGenericErosion;

geDataTable = new DataAccess().GetDataForGrid(IftProperties.IFTNo,
IftProperties.Version, "GenericErosionWRecNo_Pivot");

ugrid.DataSource = geDataTable;

ugrid.DataBind();

ugrid.Refresh();

ugrid = null;

}

#endregion

#region Grid InitializeLayout

private void ultraGridGenericErosion_InitializeLayout(object sender,
InitializeLayoutEventArgs e)

{

UltraGridBand band = this.ultraGridGenericErosion.DisplayLayout.Bands[0];

int ColumnCount =
this.ultraGridGenericErosion.DisplayLayout.Bands[0].Columns.Count;

//Hide Columns

band.Columns["ctOrder"].Hidden = true;

band.Columns["RecNo"].Hidden = true;

//Merge

band.Columns["Drug"].MergedCellStyle = MergedCellStyle.Always;

//Autofit Grid

e.Layout.AutoFitStyle =
Infragistics.Win.UltraWinGrid.AutoFitStyle.ResizeAllColumns;

//Editing

if (IftProperties.Published == true)

{

e.Layout.Override.AllowUpdate = DefaultableBoolean.False;

}

else

{

band.Columns["Pop"].CellActivation = Activation.NoEdit;

band.Columns["Country"].CellActivation = Activation.NoEdit;

band.Columns["Drug"].CellActivation = Activation.NoEdit;

}

//Alignment & Format

ConditionValueAppearance operatorConditionValueAppearance = new
GridConditionalFormat().CreateOperatorConditionValueAppearance("ultraGridGenericErosion");

for (int i = 5; i

{

band.Columns.CellAppearance.TextHAlign = Infragistics.Win.HAlign.Right;

band.Columns.Format = "0.0";

band.Columns.ValueBasedAppearance = operatorConditionValueAppearance;

}

// Turn on all of the Cut, Copy, and Paste functionality.

e.Layout.Override.AllowMultiCellOperations = AllowMultiCellOperation.All;

// In order to cut or copy, the user needs to select cells or rows.

// So set CellClickAction so that clicking on a cell selects that cell

// instead of going into edit mode.

e.Layout.Override.CellClickAction = CellClickAction.CellSelect;

e.Layout.Override.SelectTypeCell = SelectType.Extended;

}

#endregion

#region Grid AfterCellUpdate

private void ultraGridGenericErosion_AfterCellUpdate(object sender,
CellEventArgs e)

{

//Change Forecast State

IftProperties.IsSaved = false;

//Recalculate

UltraGrid ugrid = this.ultraGridGenericErosion;

string Drug = Convert.ToString(e.Cell.Row.Cells["Drug"].Value);

string Country = Convert.ToString(e.Cell.Row.Cells["Country"].Value);

int Year = Convert.ToInt32(e.Cell.Column.Header.Caption);

string Pop = Convert.ToString(e.Cell.Row.Cells["Pop"].Value);

double? Value = null;

if (e.Cell.Value != DBNull.Value)

{

Value = Convert.ToDouble(e.Cell.Value);

}

new DataAccess().UpdateGenericErosion(IftProperties.IFTNo,
IftProperties.Version,

Drug, Country, Year, Pop, Value);

//Call stored Procedure that recalculates values

//New Datatable with new values updated from the database transaction

DataTable dtUpdated = new DataAccess().GetDataForGrid(IftProperties.IFTNo,
IftProperties.Version, "GenericErosionWRecNo_Pivot");

//Merge changes

geDataTable.Merge(dtUpdated, false);

// Refresh grid, this does not redraw grid

ugrid.Rows.Refresh(RefreshRow.ReloadData);

dtUpdated.Dispose();

}

#endregion





}

}



wrote in message news:15885@forums.infragistics.com...
>I don't know why it would work in Form_Load and not InitializeLayout -
>unless maybe InitializeLayout is not firing.
>
> Regarding why it would skip the cell in the first place, the column has a
> TabStop and TabIndex property. So maybe you are setting one or both of
> these. Or maybe the column is not enabled (check CellActivation). Or it
> could be something in your code handling an event. Or you could have
> modified the KeyActionMappings.
>