Hi,

Is there an alternative solution for displaying NA  instead of cellcontrolattached?

because it is making the grid slower, and especially when scrolling

can i put it for loaded, or anything else?

Hi

Sorry for delay. There is a property which do this

pivotGrid.EditSettings.EditFormattedValue = true;

Setting it to true will solve the problem

Todor

?

ok thanks it worked,

but in this case when i click to edit the cell having the value NA , i get -1 instead of NA and this is not what i want :S

Hi

If yuo want NA to participate in sorting you should give them a double value. So change the follow line of code

cell.SetValue(-1.0, "NA", "NA");

put what value you need instead -1.0. Keep in mind that the value should be double

Regards
Todor